This course covers macro quoting functions, macro storage, and macro techniques for advanced data access, table lookup operations, advanced parameter validation, and macro windows.
Learn How To
Store and share macros with the autocall macro facility and stored compiled macros.
Protect special characters with macro quoting functions.
Automate data-driven macro calls.
Access data properties with SAS I/O functions.
Work with external directories and files in a macro program.
Resolve macro variables during DATA step execution to perform table lookup operations.
Create your own macro functions.
Integrate parameter validation in macro programs.
Build self-documenting macros.
Use the macro language with SAS Viya.
Who Should Attend
Experienced SAS macro programmers who want to learn advanced techniques
Prerequisites
In order to be successful in this course, you should have completed the SAS Macro Language 1: Essentials course or have equivalent knowledge and experience. Specifically, you should be able to:;
Write macro programs that contain iterative processing and conditional processing.
Create local and global macro variables.
Create macro variables using the SYMPUTX routine.
Use indirect macro variable references.
Use the INTO clause in the SQL procedure's SELECT statement.
SAS Products Covered
Base SAS
Course Outline
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
Live Instructor Dates