SAS Tutorial | How to Create Macro Variables and Use Macro Functions

Using the SAS Macro Language, you can produce SAS programs that are easier to modify and maintain – or better yet, programs which modify and maintain themselves. In this SAS How to Tutorial, Stacey demonstrates using SAS macro variables to store text and substitute values dynamically in your program.

Download Data Files
See SASHELP data sets in SAS.

Chapters
00:00 – Overview of what you’ll learn
01:04 – What macro variables are and how you can create them
05:57 – Manipulating macro variables with macro functions
10:19 – Creating macro variables from data using SQL
14:58 – Using the trimmed option

Learn more about SAS Software
◉ Passing comma-delimited values into SAS macros and macro functions –

Related Videos
%SURVEYCORRCOV

SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS

ABOUT SAS
SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

CONNECT WITH SAS

[staceysyphus]

Thanks so much for taking the time to watch this video tip! This is probably my favorite topic to teach about the SAS language. I'd love to hear your thoughts and questions :)

[patricklewis]

You have given a great introduction to Macros.

[yoannkouame]

STACEY always doing great with SAS, so nice to have you as instructor!

[talie]

You are one awesome teacher. Very articulate, friendly, knowledgeable and beautiful ☺️.

[benobasa]

That's my SAS tutor on Cosera. I am excited to see her here!

[thepineweaver]

Very clear material - one of my favorite SAS instructors.

[niyazshaik]

Thank you so much stacey..i learned base sas programming-1 from your e learning which is available in sas website...i really enjoy your classes...god bless you stacey.

[anvarisamukhamedov]

Thanks for this session, now I understand how and where to use a macro variable. You are a very beautiful, friendly, and knowledgeable teacher.

[ARSagar-dtyj]

This is an amazing video and simple to understand the importance and beauty of manipulating code. Would love to learn from you more. Please make a video of DO Loop and Arrays if possible. i became ta big fan to the way you explain it

[SoleLo]

Recently started using Macro language and what a game changer… %include has been my favorite

[sharangnimonkar]

Hi Stacey,
Really great way of explanation.
Systematic approach made it easy to comprehend.

[chunleizhang]

Excellent video with bells and whistles. Thanks, Stacey!

[parulanand]

Very useful and easy approach. Loved the way you explain !

[dominicmutiso]

Wow😂 @7:42 to 7:43. I love the effect- "reaction"

[himself]

Hi Stacey many thanks for the great presentation, I just love the flow of the info. I love using Macro, as it simplifies a code, #manipulating code

[oluwaledurojaye]

GRAET INSTRUCTOR, always enjoy your teaching on sas macro.

[omadnomad]

You are an amazing teacher . Love all your classes

[darshmathur]

Loved it short and crisp. Please make a video on user defined macro functions. Would appreciate it 😊.

[steveellison]

Great instructor- I love your delivery!

[sarajitsil]

Hi Stacey, a very helpful tutorial indeed! Many thanks for making this content.