SAS® Macro Language 1: Essentials
Available in:
Education Category Image


  
SAS® Macro Language 1: Essentials
Duration: 14 hours
MAC1 : 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.
Learn How To
  • Perform text substitution in SAS code.
  • Use macro variables and macro functions.
  • Automate and customize the production of SAS code.
  • Conditionally or iteratively construct SAS code.
  • Write self-modifying, data-driven programs.
  • Who Should Attend
    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
    Prerequisites
    Before attending this course, you should have knowledge equivalent to having completed the SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques 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.
  • SAS Products Covered
    Base SAS
    Course Outline
    Introduction
  • 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.

  • Live Instructor Dates SOLD SEPARATELY
    DATES ▼ LOCATION
    TIME
    LANGUAGEEVENT FEE
    19-22 MAY 2025Live Web, US11:00 AM-3:30 PM EDTSpanish1,600 USD
    16-20 JUN 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    07-11 JUL 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    28-29 JUL 2025Live Web, US9:00 AM-5:00 PM EDTEnglish1,600 USD
    11-15 AUG 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    25-28 AUG 2025Live Web, US10:30 AM-2:30 PM EDTSpanish1,600 USD
    08-12 SEP 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    18-19 SEP 2025Live Web, US9:00 AM-5:00 PM EDTEnglish1,600 USD
    29 SEP-03 OCT 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    13-16 OCT 2025Live Web, US10:30 AM-2:30 PM EDTSpanish1,600 USD
    23-24 OCT 2025Live Web, US9:00 AM-5:00 PM EDTEnglish1,600 USD
    17-21 NOV 2025Live Web, US1:00 PM-4:30 PM ESTEnglish1,600 USD
    08-09 DEC 2025Live Web, US9:00 AM-5:00 PM ESTEnglish1,600 USD



    SAS Certification Manager

    SAS partners with Pearson VUE to provide you with the best possible certification experience.

    Login


    Certification Resources


    THIS COURSE IS PART OF

    SAS Advanced Programming Professional Subscription



    Skip Earn this badge

    Earn this badge

    Badge Image