SAS(R) Macro Language 1: Essentials

Course code: MC1V2

This course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.
1 080 EUR

1 307 EUR including VAT

Selection of dates
Do you have a question?
+420 731 175 867

and certified lecturers

recognized certifications

Wide range of technical
and soft skills courses

Great customer

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Type: E-learning

Course duration: 14 hours

Language: en

Price without VAT: 1 080 EUR


Starting date: Upon request

Type: Upon request

Course duration: 17h 30min

Language: en

Price without VAT: 1 800 EUR


Type Course
Language Price without VAT
Upon request E-learning 14 hours en 1 080 EUR Register
Upon request Upon request 17h 30min en 1 800 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.


Target group

Experienced SAS programmers who are familiar with simple SQL queries and well-versed in DATA step processing and who want to write reusable, dynamic programs and automate repetitive processing in SAS

Course structure


  • Why SAS macro?
  • Setting up for this course.

SAS Macro Facility

  • Program flow.
  • Creating and using macro variables.

Storing and Processing Text

  • Macro functions.
  • Using SQL to create macro variables.
  • Using the DATA step to create macro variables.
  • Indirect references to macro variables.

Working with Macro Programs

  • Defining and calling a macro.
  • Macro variable scope.
  • Conditional processing.
  • Iterative processing.

Developing Macro Applications

  • Storing macros.
  • Generating data-dependent code.
  • Validating parameters and documenting macros.


Before attending this course, you should have knowledge equivalent to having completed the SAS Programming 1: Essentials and SAS Programmierung 2: Datenmanagement courses. Specifically, you should be able to do the following:
  • Write simple SQL queries using the SELECT statement.
  • Read from and write to SAS tables using a DATA step.
  • Use DATA step programming statements, including IF-THEN/ELSE, DO WHILE, DO UNTIL, and iterative DO.
  • Use SAS data set options, including DROP=, KEEP=, and OBS=.
  • Use character functions, including SUBSTR, SCAN, and UPCASE.
  • Read subsets from tables using the WHERE statement.
  • Create and use SAS date values and constants.
  • Use Base SAS procedures such as SORT, PRINT, CONTENTS, MEANS, and FREQ.
  • Do you need advice or a tailor-made course?


    product support

    ComGate payment gateway MasterCard Logo Visa logo