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.
Course delegates are entitled to attend a free live two hour Macro revision webinar when back in the workplace up to one year following the course.
Public Course price:
£700.00 plus VAT per delegate
View On-Site course prices »
SAS Macro Public Course Dates
Public SAS Training courses are run from our training centre - The Old School Hall, 11 Wesley Walk, Witney, Oxfordshire, OX28 6ZJ.
- Monday 25 February 2019 - Tuesday 26 February 2019Book Now
- Thursday 14 March 2019 - Friday 15 March 2019Book Now
- Tuesday 09 April 2019 - Wednesday 10 April 2019Book Now
- Tuesday 07 May 2019 - Wednesday 08 May 2019Book Now
- Tuesday 30 July 2019 - Wednesday 31 July 2019Book Now
- Thursday 22 August 2019 - Friday 23 August 2019Book Now
- Monday 16 September 2019 - Tuesday 17 September 2019Book Now
- Wednesday 30 October 2019 - Thursday 31 October 2019Book Now
- Thursday 21 November 2019 - Friday 22 November 2019Book Now
- Monday 09 December 2019 - Tuesday 10 December 2019Book Now
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
- Creating 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 and Call SYMPUTX
M7 Handling Special Characters
- Introduction
- Numeric Evaluations
- Introduction to Quoting Functions
M8 Working with Macros
- Using the %INCLUDE Statement
- The Autocall Library
- Storing Macros as Catalog Source Entries (Optional)
- How SAS Resolves Macro Calls
- Writing Successful Macros