SAS Macro Language

This course is part of SAS Advanced Programmer Professional Certificate

Instructor: Stacey Syphus

Access provided by Interbank

8,006 already enrolled

6 modules

Gain insight into a topic and learn the fundamentals.

149 reviews

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

149 reviews

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

SAS (Software)

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

60 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Software Development expertise

This course is part of the SAS Advanced Programmer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from SAS

There are 6 modules in this course

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.

In this module you'll get an overview of this course and set up your practice files. Then you'll explore macro programming and learn what the macro facility will enable you to do and why it can make your job as a SAS programmer easier.

What's included

5 videos5 readings

5 videos Total 5 minutes

Course Overview 1 minute
Introduction 0 minutes
Benefits of Using SAS Macro 2 minutes
Efficiency of Macro-Based Applications 0 minutes
Developing Macro Applications 1 minute

5 readings Total 57 minutes

Learner Prerequisites 2 minutes
Using Forums and Getting Help 5 minutes
Access SAS Software for this Course 10 minutes
Set Up Data for This Course 30 minutes
Frequently Asked Questions 10 minutes

In this module, you learn how SAS processes code behind the scenes. This is important because mastering the SAS macro facility is only possible if you understand how macro language elements impact this processing. You also learn how to create and use macro variables to dynamically modify text in a program.

What's included

15 videos11 assignments

15 videos Total 22 minutes

Introduction 0 minutes
SAS Programming Languages 1 minute
Program Flow 1 minute
Tokens 2 minutes
Tokenization 1 minute
Tokenizing Code with Macro Triggers 2 minutes
Macro Variables 1 minute
Creating Macro Variables With %LET 3 minutes
Deleting Macro Variables 1 minute
Resolving Macro Variables 4 minutes
Using SYMBOLGEN to Troubleshoot Macro Variable References 1 minute
Delimiting Macro Variable References 2 minutes
Displaying Macro Variables 1 minute
Automatic Macro Variables 1 minute
Updating Macro Variables 1 minute

11 assignments Total 141 minutes

SAS Macro Facility 50 minutes
Question 2.01 2 minutes
Question 2.02 2 minutes
Question 2.03 5 minutes
Question 2.04 2 minutes
Activity 2.05 10 minutes
Activity 2.06 10 minutes
Activity 2.07 10 minutes
Activity 2.08 10 minutes
Level 1 Practice: Defining and Using Macro Variables for Substitution 20 minutes
Level 2 Practice: Using Macro Variable References with Delimiters 20 minutes

In this module, you learn more about storing and processing text. You learn to use macro functions to manipulate text, and how to use both PROC SQL and the DATA step to create macro variables based on values read from your data. You also learn how to use indirect referencing to look up a macro variable's value based on another macro variable.

What's included

19 videos17 assignments

19 videos Total 49 minutes

Introduction 1 minute
Using Macro Functions 1 minute
SAS Functions and Macro Functions 3 minutes
Processing Text with Macro Functions 2 minutes
Executing SAS DATA Step Functions During Tokenization 1 minute
Evaluating Arithmetic Expressions 3 minutes
Using Special Characters 5 minutes
Demo: Using Macro Functions 4 minutes
Creating Macro Variables in PROC SQL 5 minutes
Demo: Creating Macro Variables with a PROC SQL Query 4 minutes
Scenario: Create Macro Variables in a DATA Step 2 minutes
DATA Step versus Macro Execution Timing 2 minutes
Creating Macro Variables in a DATA Step 3 minutes
Creating Macro Variables During DATA Step Execution 2 minutes
Demo: Creating Macro Variables with the DATA Step 4 minutes
Comparing the DATA Step and PROC SQL 1 minute
Scenario: Using Indirect References 2 minutes
Forward Rescan Rule 2 minutes
Demo: Indirect References to Macro Variables 5 minutes

17 assignments Total 274 minutes

Storing and Processing Text 50 minutes
Activity 3.01 10 minutes
Question 3.02 2 minutes
Activity 3.03 10 minutes
Activity 3.04 10 minutes
Level 1 Practice: Using the %UPCASE and %SCAN Functions 20 minutes
Level 2 Practice: Using Macro Quoting Functions 20 minutes
Level 1 Practice: Using PROC SQL to Generate Macro Variables for Use in a Report Title 20 minutes
Level 2 Practice: Using PROC SQL to Generate Macro Variables for Use in Subsequent Steps 20 minutes
Activity3.05 10 minutes
Question 3.06 2 minutes
Activity 3.07 10 minutes
Level 1 Practice: Creating Macro Variables with the SYMPUTX Routine 20 minutes
Level 2 Practice: Using a DATA _NULL_ Step to Create a Series of Macro Variables 20 minutes
Activity 3.08 10 minutes
Level 1 Practice: Using Indirect References to Macro Variables 20 minutes
Level 2 Practice: Using Indirect References to Macro Variables 20 minutes

In this module, you learn to write and call macro programs to generate SAS code based on input values. You also learn about macro variable scope - where macro variables are stored and how long they are available. Finally you learn about conditionally generating and processing code using macro IF/THEN statements, and iterative processing with macro DO loops.

What's included

29 videos19 assignments

29 videos Total 63 minutes

Introduction 1 minute
Defining a Macro 2 minutes
Using the MCOMPILENOTE Option 0 minutes
Calling a Macro 2 minutes
Using the MPRINT Option 1 minute
Macro Parameters 1 minute
Demo: Defining a Macro with Parameters 4 minutes
Macro Keyword Parameters 2 minutes
Mixed Parameter Lists 1 minute
Global Macro Variables 2 minutes
Local Macro Variables 1 minute
Macro Variable Scope 1 minute
Controlling Macro Variable Scope 3 minutes
Resolving Macro Variables 1 minute
Nested Macro Calls 4 minutes
Conditional Processing 3 minutes
Conditionally Executing Program Steps 2 minutes
Scenario: Nested Conditional Processing 1 minute
Conditionally Generating Program Steps 4 minutes
Conditionally Generating Complete and Partial Statements 2 minutes
Using the MLOGIC Option 1 minute
Demo: Conditional Processing 6 minutes
Scenario: Generating Repetitive Code 1 minute
%DO Iterative Statement 4 minutes
Demo: Iterative %DO Loops 4 minutes
Using a %DO Loop with Indirect References 2 minutes
Demo: %DO Loops with Indirect References 4 minutes
%DO WHILE Loops 3 minutes
%DO UNTIL Loops 1 minute

19 assignments Total 287 minutes

Working with Macro Programs 50 minutes
Activity 4.01 10 minutes
Activity 4.02 10 minutes
Activity 4.03 10 minutes
Level 1 Practice: Defining and Using a Macro with Parameters 20 minutes
Level 2 Practice: Using a Macro to Generate PROC MEANS Code 20 minutes
Question 4.04 2 minutes
Activity 4.05 10 minutes
Activity 4.06 10 minutes
Level 1 Practice: Understanding Symbol Tables 10 minutes
Level 2 Practice: Controlling Macro Variable Scope 20 minutes
Activity 4.07 10 minutes
Activity 4.08 10 minutes
Level 1 Practice: Using Macro Conditional Processing to Choose Which SAS Statements are Generated 20 minutes
Level 2 Practice: Using Macro Conditional Processing in Open Code 20 minutes
Activity 4.09 10 minutes
Code Challenge 4.10 5 minutes
Level 1 Practice: Using Iterative Processing and Indirect Referencing 20 minutes
Level 2 Practice: Using a %DO %UNTIL Loop 20 minutes

In this module you learn how to store and retrieve macros so they are available in any SAS session. You also learn to build data-driven macro applications that dynamically generate SAS code based on values in your data. Finally, you learn to build safety precautions and documentation into your macro applications so that they correct themselves if problems occur, or provide helpful messages to direct the user to a resolution.

What's included

14 videos1 reading12 assignments

14 videos Total 36 minutes

Introduction 1 minute
Compiled Macros 2 minutes
Autocall Macro Facility 2 minutes
Calling Autocall Macros 2 minutes
Adding Personal Macros to an Autocall Library 3 minutes
Demo: Macro Autocall Libraries 5 minutes
Develop a SPLITTABLE Macro Application 4 minutes
Demo: Generating Data-Dependent Code 4 minutes
Enhancing Macro Applications 1 minute
Validating Parameters 2 minutes
Additional Validation Techniques 3 minutes
Demo: Validating Parameters 8 minutes
Documenting a Macro 1 minute
Complex Macro Enhancements 1 minute

1 reading Total 2 minutes

SAS Autocall Facility Options 2 minutes

12 assignments Total 175 minutes

Developing Macro Applications 25 minutes
Activity 5.01 10 minutes
Activity 5.02 10 minutes
Activity 5.03 10 minutes
Activity 5.04 10 minutes
Level 1 Practice: Generating Data-Dependent Listing Reports 20 minutes
Level 2 Practice: Exporting Data to Separate Worksheets in Microsoft Excel 20 minutes
Activity 5.05 10 minutes
Activity 5.06 10 minutes
Activity 5.07 10 minutes
Level 1 Practice: Validating a Macro Parameter 20 minutes
Level 2 Practice: Validating Macro Parameters with Data Values 20 minutes

In this case study, you solve a real-world business problem by applying concepts that you learned in this course.

What's included

3 readings1 assignment1 app item

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(39 ratings)

Stacey Syphus

SAS

8 Courses 128,470 learners

Offered by

SAS

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
85.23%
4 stars
10.73%
3 stars
2.68%
2 stars
0.67%
1 star
0.67%

Showing 3 of 149

Reviewed on Nov 14, 2021

I am really thankful to the instructor for guiding macro trainings in such a way. After this course, I can able to write macro by my own.

Reviewed on Jun 23, 2021

Great course! If you can follow this course, you will be no problem on SAS advanced certificate! The contents are much more indepth than the exam requirement!