Skip to main Content

SAS Macro CPD

Selected option:
On-Site
Other options:
Public
Duration:
2 Days

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.

Items marked with a * are mandatory