SAS® Macro Language 1: Essentials Training

  • Learn via: Classroom
  • Duration: 2 Days
  • Price: From $1,287+VAT
We can host this training at your preferred location. Contact us!

This course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with macro code are processed.

Before attending this course, you should have completed the SAS Programming 2: Data Manipulation Techniques course or have equivalent knowledge. Specifically, you should be able to

  • use a DATA step to read from or write to a SAS data set or external file
  • use DATA step programming statements such as IF-THEN/ELSE, DO WHILE, DO UNTIL, and iterative DO
  • use SAS data set options such as DROP=, KEEP=, and OBS=
  • use character functions such as SUBSTR, SCAN, INDEX, and UPCASE
  • form subsets of data using the WHERE clause
  • create and use SAS date values and constants
  • use SAS procedures such as SORT, PRINT, CONTENTS, MEANS, FREQ, TABULATE, and CHART.

This course addresses Base SAS software.

This course is appropriate for students who are using SAS 9 software.

Who should attend

Experienced SAS programmers who have a sound understanding of DATA step processing and who want to write SAS programs that are reusable and dynamic

  • perform text substitution in SAS code
  • automate and customize the production of SAS code
  • conditionally or iteratively construct SAS code
  • use macro variables and macro functions.

Introduction

  • course logistics
  • purpose of the macro facility
  • program flow

Macro Variables

  • introduction to macro variables
  • automatic macro variables
  • macro variable references
  • user-defined macro variables
  • delimiting macro variable references
  • macro functions

Macro Definitions

  • defining and calling a macro
  • macro parameters

DATA Step and SQL Interfaces

  • creating macro variables in the DATA step
  • indirect references to macro variables
  • creating macro variables in SQL

Macro Programs

  • conditional processing
  • parameter validation
  • iterative processing
  • global and local symbol tables

Learning More

  • SAS resources
  • beyond this course

Supplemental Materials

  • program flow



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
15 April 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
24 April 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
26 April 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
04 May 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
19 June 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
08 July 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
17 August 2024
Istanbul, Ankara, London
2 Days
Classroom / Virtual Classroom
21 October 2024
Istanbul, Ankara, London
2 Days
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.