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

Macros - The Language of SAS at Newtyne, Edinburgh


Course Length:

This is a two-day course.

Course Summary:

Do you run your programs more than once?  The Macros course teaches you techniques to make your programs smarter.  Learn how to write dynamic data-dependent code using macro variables and macro programs.

What you will be taught:

  • Review of 'Foundations - The Language of SAS'
    • Compilation and Execution of DATA Steps
    • Selecting Observations
    • Conditional Processing
    • Iterative Processing
    • Sorting Data
  • Introduction to Macro Processing
    • Tokenization
    • Macro Triggers
    • The %PUT Statement
  • Introduction to Macro Variables
    • Macro Variable Storage
    • Macro Variable Resolution
    • User-Defined Macro Variables
    • The %LET Statement
    • The SYMBOLGEN Option
    • Delimiting Macro Variables
  • Macro Functions
    • Character Manipulation Functions
    • Using Macro Functions
    • Numeric Functions
    • The %SYSFUNC Function
  • Macro Programs
    • Compilation
    • Macro Calls
    • Generating Code
    • The MPRINT Option
    • Storage
    • Autocall Macros
    • Best Practices
    • Macro Program Parameters
  • Global and Local Symbol Tables
    • The Global Symbol Table
    • The Local Symbol Table
    • Nested Macros
    • Creating and Updating Macro Variables
    • Resolving Macro Variables
  • Conditional Processing
    • %IF - %THEN - %ELSE
    • The MLOGIC Option
    • Conditionally Returning a Program Step
    • Conditionally Retuning a Statement
    • Conditionally Returning a Partial Statement
    • %DO - %END
    • The %INCLUDE Statement
  • DATA Step and PROC SQL
    • Create Macro Variable in a DATA Step
    • Create a Series of Macro Variables
    • Create Macro Variables in PROC SQL

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' and 'Data Step Techniques: The Language of SAS' courses (or comparable course of study), covering topics including:

  • Use of Global statements e.g. LIBNAME FILENAME and OPTIONS
  • Use of functions to transform character data (e.g. SCAN, FIND, SUBSTR)
  • Use of functions to transform numeric data (e.g. CEIL, INT, FLOOR, ROUND)
  • Use of functions to transform dates (e.g. DAY, MONTH, YEAR, INTCK)
  • KEEP and DROP to select variables
  • IF and WHERE statements to select observations
  • Conditional Processing with IF-THEN-ELSE
  • Iterative DO Loops
  • Conditional Do Loops - DO WHILE, DO UNTIL
  • Compile-Time statements (e.g. LENGTH, RETAIN)
  • Combining Data Sets vertically and horizontally
  • Summarizing data with the FREQ, MEANS and TABULATE procedures



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.