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
◉ SAS Macro Language 1: Essentials Course – learn.sas.com/course/view.php?id=121
◉ Getting Started with the Macro Facility – go.documentation.sas.com/?docsetId=mcrolref&…
◉ SAS Macro Language Documentation – go.documentation.sas.com/?cdcId=pgmsascdc&c…
◉ Passing comma-delimited values into SAS macros and macro functions –
blogs.sas.com/content/sgf/2019/07/17/passing-co…
◉ Tip: %LET macro statement – communities.sas.com/t5/SAS-Communities-Library/…
◉ How to create and use SAS macro functions – blogs.sas.com/content/sgf/2020/04/22/how-to-cre…

Related Videos
◉ SAS Enterprise Guide: Macro Variables – youtube.com/watch?v=cMNycxza6Zo&t
Beyond the Basics of Macro – youtube.com/watch?v=P1LZ2_sjvtc
◉ Getting the Most out of SAS Macro and SQL – youtube.com/watch?v=sM3sidYPT-o
%SURVEYCORRCOV
◉ Macro: Complex Survey Data Correlations for Multivariate Analysis and Model Building – youtube.com/watch?v=Q89nL7h9AbE


SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS
youtube.com/SASUsers?sub_confirmation=1

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 ► sas.com
SAS Customer Support ► support.sas.com
SAS Communities ► communities.sas.com
SAS Analytics Explorers ► explorers.sas.com
Facebook ► facebook.com/SASsoftware
Twitter ► twitter.com/SASsoftware
LinkedIn ► linkedin.com/company/sas
Blogs ► blogs.sas.com
RSS ► sas.com/rss