Macro variables are tools that enable you to dynamically modify the text in a SAS program through symbolic substitution. You can assign large or small amounts of text to macro variables, when you reference the variable afterward the text that it contains will substitute the variable name.

In this tips and tricks, we will start the SAS Macro language from scratch and learn how to create and use macro variables in order to dynamize SAS codes. More precisely, we will cover the following topics:

• How can we create macro with %let statement ?
• What are the system macro variables and how to use them
• Use macro together with SAS code
• Use character macro functions
• How to deal with numeric values using macro functions
• Creation of the macro using the CALL SYMPUTX in datastep
• Creation of the macro using the INTO clause in PROC SQL

You have some SAS experience and would like to use and create SAS macro variables in your SAS codes.