Advanced Macro Concepts

  • Storing macros with the autocall facility.
  • Understanding macro program flow.

Protecting Special Characters

  • Protecting constant text during macro compilation.
  • Protecting resolved text during macro execution.

Accessing Data with the Macro Language

  • Automating macro calls.
  • Accessing data properties with SAS I/O functions.

Working with External Files

  • Working with directory contents in a macro program.
  • Working with external files in a macro program.
  • Working with Microsoft Excel files in a macro program.

Resolving Macro Variables during DATA Step Execution Validating Macro Parameters Additional Macro Topics

  • Building self-documenting macros.
  • Using the stored compiled macro facility.
  • How to use the macro language in SAS Viya.