SAS Macro
Course Length - 2 Days
This course covers the SAS Macro Language in depth. The theory and methods of the Macro facility are discussed through examples and applications. You will be able to write your own Macros, understand the structure of the SAS Macro Language and deal with the various functions available in the SAS Macro Language.
Public Course price:
£700.00 plus VAT per delegate
View On-Site course prices »
SAS Macro Public Course Dates
Due to Covid-19 all Amadeus training will be delivered via live web classes. Our live Web classes are as interactive as our classroom training, there are also some benefits - no travelling time and costs!
Audience
SAS users seeking to extend their Programming Skills.
Prerequisites
Ideally the delegate will have attended the SAS Fundamentals course or have an equivalent level of competence. We recommend that attendees have three to six months of regular SAS programming experience to gain the most benefit from this course.
Topics
M1 lntroduction
- Common Coding Tasks
- General Strategy
M2 Macro Variables
- Introduction
- Automatic Macro Variables
- Determining the Values of Macro Variables
- User-Defined Macro Variables
- Resolution Considerations
- Macro Variables vs. DATA Step Variables
M3 Macros
- Definition of a Macro
- Passing Parameters
- Compilation and Execution Phases
M4 Behind the Scenes
- Symbol Table Rules
- Deleting Macro Variables
- Nested Macros
- GLOBAL and LOCAL Variables
M5 Macro Programming
- Directing Macro Execution
- Conditional Termination of Macro Flow
- String Manipulation
- %SYSFUNC and %QSYSFUNC and %SYSCALL
M6 The DATA Step Interface
- Functions and Call Routines
- SYMGET
- Call SYMPUT
M7 Handling Special Characters
- Introduction
- Numeric Evaluations
- Introduction to Quoting Functions
M8 Working with Macros
- Using the %INCLUDE Statement
- The Autocall Library
- How SAS Resolves Macro Calls
- Writing Successful Macros