Macro programs or Macros are compiled line of codes referred by a name that you can call anywhere in a SAS program using that name. This allows you to create SAS toolbox of code which can be used in different codes, using different parameters, using Conditional processing....

In this tips and tricks designed especially for SQL users, we will cover the very interesting topic of the macro programs:

• What are macro program and how can we create and use them ?
• What kind of parameters exists and how to we use them?
• How can we use conditional expression
• How can we loop using do loop & do while
• How can we perform data driven execution of macro programs
• Difference between Global symbol table VS Local symbol table
• Macro program storage: Compiled in permanent library, autocall or autoexec ?

You have some SAS experience, already know what is a macro variable and would like to use and create SAS macro programs.