SAS Tutorial | Using SAS Macro Variable Lists to Create Dynamic Data-Driven Programs

The SAS® macro facility is an amazing tool for creating dynamic, flexible, reusable programs that can automatically adapt to change. In this presentation, you’ll learn how to create and use macro variable lists, a simple but powerful mechanism for creating data-driven programming logic. Don’t hardcode data values into your programs. Eliminate data dependencies forever and let the macro facility write your SAS code for you!

Content Outline
00:00:00 – Introduction
00:03:10 – Macro Language Review
00:14:51 – Exercise 1 Using Data Step
00:21:07 – Exercise 2 Using PROC SQL
00:24:53 – Creating Macro Variable Lists
00:28:16 – With PROC SQL – Horizontal list
00:32:26 – Exercise 3
00:35:18 – With PROC SQL – Vertical List
00:37:21 – Exercise 4
00:39:39 – With Data Step - Horizontal List
00:46:25 – Exercise 5
00:50:04 – With Data Step – Vertical List
00:53:07 – Exercise 6
00:56:00 – Using Macro Variable Lists
00:56:29 – Using Horizontal Macro Variable Lists
00:59:55 – Exercise 7
01:05:59 – Using Vertical Macro Variable Lists
01:09:22 – Exercise 8
01:13:46 – Conclusion

Session ID: N/A
Presenter: Joshua Horstman, Nested Loop
Topic: Programming
Industry: Non-Industry Specific
Audience: All
Level: All

Tutorial exercises and solutions -- https://github.com/sascommunities/sas...

Learn more about SAS Software
Free SAS Online Training – https://www.sas.com/en_us/training/of...
Contact SAS® – https://www.sas.com/en_us/contact.geo...


SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF
https://www.youtube.com/SASUsers?sub_...

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
SAS ► https://www.sas.com/contact
SAS Customer Support ► https://support.sas.com
SAS Communities ► https://communities.sas.com
SAS Analytics Explorers ► https://explorers.sas.com
Facebook ►   / sassoftware  
Twitter ►   / sassoftware  
LinkedIn ►   / sas  
Blogs ► https://blogs.sas.com
RSS ►https://www.sas.com/rss