SAS Training
SAS Programming
Statistical Consulting
Arthur L. Carpenter


Advanced Techniques Using the SAS Macro Language  

1       Course Introduction
2       Anatomy of a Macro
3       Macro Variables
4       Using Macros
5       Macro Parameters
6       Program Control Through Macros
7       Data-Driven Macro Parameters
8       Macro Function References
9       Automatic Macro Variables
10     Macro Options
11     Referencing Environments
12     Execution Phases
13     Diagnosing Errors
14     Optimization Strategies

This course is designed to teach the participant how to write useful and powerful macros using the SAS System Macro Facility. Emphasis is placed on how the macro facility works and what impact a macro program has on the normal processing of SAS System programs.

The material in this course is directed at programmers and end-users who need an in-depth understanding of how the macro language can be used as a productivity tool. Previous experience with the material covered in the SAS Software Basics and SAS Software Intermediate courses is recommended.

At the completion of this course the student will have a broad understanding of the following topics:

  • Features of the SAS System Macro Facility.
  • The relationship between the DATA and PROC Steps and the Macro Language.
  • Description of Macro Compilation and Macro Execution.
  • Explanation of Macro Language Statements:
  • Explanation of Macro Variables.
  • Explanation of Character, Evaluation, and Quoting Macro Functions.
  • Explanation of Referencing Environments.
  • Detect and Correct Macro Programming Errors.