This SAS Macro Language training course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.
By attending SAS Macro Language workshop, delegates will learn to:
- Perform text substitution in SAS code
- Use macro variables and macro functions
- Automate and customize the production of SAS code
- Conditionally or iteratively construct SAS code
- Write self-modifying, data-driven programs
Attend trainings on SAS Programming and SAS - Data Manipulation Techniques or equivalent practical knowledge. Specifically, you should be able to do the following:
- Write simple SQL queries using the SELECT statement
- Read from and write to SAS tables using a DATA step
- Use DATA step programming statements, including IF-THEN/ELSE, DO WHILE, DO UNTIL, and iterative DO
- Use SAS data set options, including DROP=, KEEP=, and OBS=
- Use character functions, including SUBSTR, SCAN, and UPCASE
- Read subsets from tables using the WHERE statement
- Create and use SAS date values and constants
- Use Base SAS procedures such as SORT, PRINT, CONTENTS, MEANS, and FREQ
The SAS Macro Language class is ideal for:
- Experienced SAS programmers who are familiar with simple SQL queries and well-versed in DATA step processing and who want to write reusable, dynamic programs and automate repetitive processing in SAS