SAS Macro CPD
Audience
SAS Programmers seeking to extend their Programming Skills with the added support of our Continuous Professional Development Program.Prerequisites
To take this course, you should have taken the SAS Fundamentals course and have at least 6 months SAS programming experience.Objectives
This course covers the SAS Macro Language in depth; it is also part of our Continuous Professional Development Program (CPD) detailed below. 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 Macro Language.
The Continuous Professional Development program has 5 elements:
1. ASSESS knowledge in preparation for the SAS Macro course.
- Optional pre course tests and questionnaires are available to access your level of expertise prior to the training
- Optional discussion with one of our trainers to make sure your course selection is appropriate for your needs
2. LEARN SAS Macro from our highly qualified SAS certified instructors who bring real world experience to the classroom.
- Amadeus instructors use proven effective learning methods with a practical approach during the training sessions
- Bring along your questions and code problems to the course instructors
3. REINFORCE knowledge through hands on workshops during the SAS Macro training session and receive course material that is packed full of examples and SAS techniques
- The training course is interactive and we encourage delegate participation. The days are split into live SAS demonstration sessions, lectures and workshops
- You will receive your own set of Amadeus colour course material at the beginning of the course which is written from many years experience and is recognised as valuable reference material to use back in the workplace
4. SUPPORT is provided by our instructors during the SAS Macro course and through live revision sessions following the training. Free resources are also available to download.
- You can register for the SAS Macro CPD two hour live revision webinar session up to four months following your course attendance to help reinforce your new SAS knowledge
- Free resources are available to you following the course including: Tips and Techniques, Podcasts and Technical Papers
5. VALIDATE and measure the effectiveness after the SAS Macro course back in the work place
- Optional post course tests are available to access your level of expertise after the training
- Optional consultancy service to validate your code back in the workplace
Topics
M1 lntroduction
- Common Coding Tasks
- General Strategy
- Workshop Session
M6 The Data Step Interface
- Functions and Call Routines
- SYMGET
- Call SYMPUT and Call SYMPUTX
- Workshop Session
M2 Variable Code
- Macro Variables
- Resolution Considerations
- Macro Variables vs. Data Step Variables
- Workshop Session
M7 Special Characters
- Evaluations
- The Quoting Functions
- Workshop Session
M3 Code Bundles
- Definition of a Macro
- Passing Parameters
- Compilation and Execution Phases
- Workshop Session
M8 Working with Macros
- The Autocall Library
- The Stored Compiled Macro Facility
- SAS System Options
- Writing Successful Macros
- Workshop Session
M4 Behind the Scenes
- Symbol Table Rules
- Deleting Macro Variables
- Nested Macros
- GLOBAL and LOCAL Variables
- Workshop Session
M9 Windows and Menus (Optional)
- Window Definition with %Window
- %Display
- Examples
- Workshop Session
M5 Code Generation
- Directing Macro Execution
- Conditional Termination of Macro Flow
- String Manipulation
- %SYSFUNC and %QSYSFUNC
- Debugging
- Workshop Session
On-site courses prices
| Attendees | 2 Days |
|---|---|
| 1 | £1670 |
| 2 | £1760 |
| 3 | £2160 |
| 4 | £2640 |
| 5 | £3200 |
| 6 | £3720 |
| 7 | £4200 |
| 8 | £4480 |
| 9 | £4860 |
| 10 | £5100 |
On-site Training Enquiry
This course is available on-site.

