SAS® Macro Language 1: Essentials
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
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
IntroductionWhy SAS macro? Setting up for this course. SAS Macro FacilityProgram flow. Creating and using macro variables. Storing and Processing TextMacro functions. Using SQL to create macro variables. Using the DATA step to create macro variables. Indirect references to macro variables. Working with Macro ProgramsDefining and calling a macro. Macro variable scope. Conditional processing. Iterative processing. Developing Macro ApplicationsStoring macros. Generating data-dependent code. Validating parameters and documenting macros.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
|
SOLD SEPARATELY | ||||
|---|---|---|---|---|---|
| DATES ▼ |
LOCATION
▲ ▼ |
TIME
▲ ▼ |
LANGUAGE | EVENT FEE | |
| 11-15 AUG 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | |
| 25-28 AUG 2025 | Live Web, US | 10:30 AM-2:30 PM EDT | Spanish | 1,600 USD | |
| 08-12 SEP 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | |
| 18-19 SEP 2025 | Live Web, US | 9:00 AM-5:00 PM EDT | English | 1,600 USD | |
| 29 SEP-03 OCT 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | |
| 13-16 OCT 2025 | Live Web, US | 10:30 AM-2:30 PM EDT | Spanish | 1,600 USD | |
| 23-24 OCT 2025 | Live Web, US | 9:00 AM-5:00 PM EDT | English | 1,600 USD | |
| 17-21 NOV 2025 | Live Web, US | 1:00 PM-4:30 PM EST | English | 1,600 USD | |
| 08-09 DEC 2025 | Live Web, US | 9:00 AM-5:00 PM EST | English | 1,600 USD | |
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.
This course helps prepare you to earn the following SAS Credentials:
SAS Certification Manager
SAS partners with Pearson VUE to provide you with the best possible certification experience.
Certification Resources
