SAS Tutorial | 3 Steps to Build a SAS Macro Program

Who doesn’t want code that rewrites itself? Enter the SAS Macro Language. Say you’re running a SAS program routinely but need to make specific modifications each time. A SAS macro program could make those changes for you. In this SAS How To Tutorial, SAS’ Stacey Syphus breaks down how to build a SAS macro program into 3 steps: creating a macro program, using macro parameters and executing code conditionally.

Download Data Files
See SASHELP.CARS data sets in SAS.

Chapters
0:00 – The SAS program scenario that may need the SAS macro language
2:20 – Creating and calling a macro program
4:11 – Use macro parameters to substitute values
8:42 – Execute code conditionally

Learn more about SAS Software
◉ Multi-purpose macro function for getting information about data sets –

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! I hope you find it helpful. The SAS macro language is the best. :)

[rodrigolalloz]

Thanks a lot, you are so clear when talking (not only explanation, but pronunciation too)! pls keep upload more videos!

[niyazshaik]

One of the Best trainers for SAS. Thanks for uploading this video.

[rinrinrikuriku]

I am UGLY CRYING. THIS IS SO UNDERSTANDABLE AND SAVED ME. Thank you so much!! I hope you continue to make more videos!!

[davidpope]

Nice job in teaching about creating a macro program within SAS. What I really like about the SAS macro language is not only can you share this code with other SAS users, but you can learn how to turn this macro into either a stored process (in 9.4) or a SAS Job Execution job (in SAS Viya) which then allows 3rd party languages/programming to execute and or interact with the SAS process/results.

[AlexBrazilDF]

Amazing SAS Tutorial... congratulations Instrutor 🤓

[dominicmutiso]

This is good. Please do more videos on macro language topics

[narjissio]

IS SO UNDERSTANDABLE AND VERY HELPFUL VIDEO THANKS A LOT

[arifehtesham]

Thank you very much for sharing the video. Everything is explained in a very simple and easy way.

[rogerward]

This is excellent. Thank you, Stacy. Thank you, SAS.

[avinashprasadmahato]

Very good session with practically applied examples !

[JoanApita]

This is a very helpful video! This tutorial was very easy for me to understand how marco works on sas. I just learned week ago. Thank you!

[danvt]

I really like your videos, the explanation is clear and detail. Very useful. I hope you will do more macro videos like this.

[itsmev]

Thank you, as a SAS beginner it's really helpful for me to find such amazing explanations!

[DipendraKumarAyer]

Thank you very much for the video, it's really helpful. Can you please help me how to update old codes of PROC GPLOT to PROC SGPLOT for biplot graphs using macro language?

[KJosue-oblm]

Hi! thanks for this course. Please the first resource's link is not working ... :( Could you provide us another one?
I'm a beginner with SAS and I need to go deeper with macro programs .
Thanks for all !!

[madhur]

You are amazing..thanks for the video :)

[hangho]

Thanks so much. Can I use SAS studio for the augmented backward elimination method ?

[abhijitnair]

When do you use &macro_var. As opposed to &macro_var

[aditisalot]

I went through your two videos Stacey they were amazing but Can u teach A to Z in macro. What is the process and how to write your own macro?