Advanced Macros - The Language of SAS
Simply fill in the form below to sign up for our Newsletter:
Sign Up for our Newsletter

Foundations - The Language of SAS training at Newtyne, Edinburgh


Course Length:

This is a two-day course.

Course Summary:

The Advanced Macro course covers the additional Macros techniques used in the programming language of SAS  enabling you to write dynamic Macros and extend the functionality of your code.  


What you will be taught:


A Review of Macro Processing

  • System Processing Macro Processing
  • Macro Variables
  • Creating / Updating Macro Variables
  • Resolving Macro Variables
  • Delimiting Macro Variables Macro Functions
  • Macro Programs
  • The Forward Rescan Rule


How to handle Special Characters at Compile Time

  • Special Characters – Definition
  • Handling Special Characters
  • %str(  )
  • %nrstr(  )
  • %unquote(  )
  • How to handle Mnemonics
  • Handling Blanks
  • Handling Unmatched Quotes
  • Handling Special Characters in Functions
  • Best Practice


How to handle Special Characters at Execution Time

  • Compile vs Execution Time
  • %superq( )
  • Q-Functions


Using Functions in Macro Code

  • Using Functions – Overview
  • %sysfunc Syntax
  • Nesting Functions
  • When to use %sysfunc
  • Useful Functions
  • Call Routines


How to Perform Numeric Calculations

  • %eval(  )
  • %eval(  ) With Comparisons
  • %sysevalf(  )
  • %sysevalf – Type argument
  • %sysevalf(  ) With Comparisons
  • How to use Macros Effectively
  • User-Created Functions
  • Macro Programs
  • Using %include
  • The Autocall Library
  • Stored Compiled Macros
  • Conditional Logic
  • Conditional Logic – DATA and PROC Steps
  • Conditional Logic – Whole Programs


How to use Macro Applications

  • Debugging Macros
  • Validation Techniques
  • Log Messages
  • Useful System Options
  • %goto ... %label:
  • Storing Session Settings
  • Running on Different Platforms
  • Sample Macro Application 


What you should already know:

In order to gain a suitable understanding from this course, it is expected that you should have attended the, 'Foundations: The Language of SAS' , 'Data Step Techniques: The Language of SAS' courses  and the 'Macros: The Language of SAS' courses (or comparable course of study), or have completed twelve months of developing code in the language of SAS covering topics including being able to:


  • write macro programs that contain iterative processing and conditional processing
  • create local and global macro variables
  • create macro variables using the SYMPUTX routine
  • utilize indirect macro variable references
  • utilize the SQL procedure SELECT statement INTO clause.



If the dates below do not suit please contact us on +44 (0)131 225 6952 as alternative dates can be arranged.



Don't Delay - Book Today!

Select a date and click on the button below to register.