Job Meter = High
Advanced SAS Macro
30 Hours
Online Instructor-led Training
USD 2800
About this Course
After instructor led tuition attendees will be able to:
- Apply best practices when designing and programming SAS macros;
- Understand when to use advanced DATA step functions to work with SAS Macro Language;
- Ensure macros developed are resilient and robust;
- Use advanced SAS file input and output functions with SAS Macro Language.
Target Audience
Programmers who wish to extend their knowledge of the SAS Macro Language. The course focuses specifically on applying best practices when developing macros, advanced DATA step techniques and the use of SAS file I/O functions.
--------------------------------------------------Advanced SAS Macro
Course Details & Curriculum
AM1 SAS Macro Best Practices
- Writing Reusable Macros
- Modular Programming
- Design Considerations
- Passing Values between Macros
- Debugging
- Log Messaging
AM2 SAS I/O Functions
- Introduction
- Using Table Functions
- Using Directory Functions
- Using File Functions
AM3 Programming Resilient Macros
- Parameter Validation
- Macro Quoting Functions
AM4 Advanced DATA Step Techniques
- Call EXECUTE
- Call SET
- RESOLVE Function (Optional)
- DOSUBL Function (Optional)