This course is designed for experienced SAS users and for those who have already taken the SAS fundamentals course and who want to study in detail some SAS programming aspects.

These topics will be discussed:

• the position of the 'Macro facility' in the SAS environment
• the basic elements of the Macro language
• the integration of Macro structures in the 'SAS Base' programming language
• how to add the Macro logic to the 'step' reasoning of the SAS compiler

• macro concept - principles, macro compiler, programme flow library structures
• conditional and standard execution of macros
• debugging, autocall and macro library structures
• 'quoting' techniques for the use of special characters
• macro integration in the classic SAS programmes (Data Step - Proc Step)
• indirect variable references (Proc Step)
• implementation of macros in order to extend the SAS language (functions, statements)
• SAS Macro programming:
  • calculations
  • integration of functions and routines
  • manipulation of variables, local and global
  • conditional and iterative programme logic
  • debugging/troubleshooting

Classroom training with demonstrations and exercises. SAS enterprise guide will be used as IDE, but on demand also z/OS mainframe could be used.

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

Participants should have followed the course SAS programming part 1: fundamentals or should have equivalent experience. Some practical SAS programming experience is a must.

Analysts, programmers, people responsible for support as well as experienced SAS users.