SAS Macro Language

This course is part of SAS Advanced Programmer Professional Certificate

Instructor: Stacey Syphus

8,100 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

151 reviews

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

151 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

56 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 5 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 begin with a brief course overview and set up your practice files. You’ll then explore SAS macro programming, including what the macro facility enables you to do and how it can make programming more efficient. You’ll also learn how SAS processes code behind the scenes and how macro language elements affect that processing, then practice creating and using macro variables to dynamically modify text in your programs.

What's included

20 videos3 readings7 assignments

20 videosTotal 28 minutes

Course Overview1 minute
Introduction0 minutes
Benefits of Using SAS Macro2 minutes
Efficiency of Macro-Based Applications0 minutes
Developing Macro Applications1 minute
Introduction0 minutes
SAS Programming Languages1 minute
Program Flow1 minute
Tokens2 minutes
Tokenization1 minute
Tokenizing Code with Macro Triggers2 minutes
Macro Variables1 minute
Creating Macro Variables With %LET3 minutes
Deleting Macro Variables1 minute
Resolving Macro Variables4 minutes
Using SYMBOLGEN to Troubleshoot Macro Variable References1 minute
Delimiting Macro Variable References2 minutes
Displaying Macro Variables1 minute
Automatic Macro Variables1 minute
Updating Macro Variables1 minute

3 readingsTotal 22 minutes

Learner Prerequisites2 minutes
Access SAS Software & Set up Data(REQUIRED)10 minutes
Frequently Asked Questions10 minutes

7 assignmentsTotal 127 minutes

SAS Macro Facility50 minutes
Knowledge Check: Tokens2 minutes
Knowledge Check: Program Flow15 minutes
Knowledge Check: SYMBOLGEN to Troubleshoot Macro Variable References10 minutes
Level 1 Practice: Defining and Using Macro Variables for Substitution20 minutes
Knowledge Check: Delimiting, Displaying & Automatic Macro Variables 10 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 videosTotal 49 minutes

Introduction1 minute
Using Macro Functions1 minute
SAS Functions and Macro Functions3 minutes
Processing Text with Macro Functions2 minutes
Executing SAS DATA Step Functions During Tokenization1 minute
Evaluating Arithmetic Expressions3 minutes
Using Special Characters5 minutes
Demo: Using Macro Functions4 minutes
Creating Macro Variables in PROC SQL5 minutes
Demo: Creating Macro Variables with a PROC SQL Query4 minutes
Scenario: Create Macro Variables in a DATA Step2 minutes
DATA Step versus Macro Execution Timing2 minutes
Creating Macro Variables in a DATA Step3 minutes
Creating Macro Variables During DATA Step Execution2 minutes
Demo: Creating Macro Variables with the DATA Step4 minutes
Comparing the DATA Step and PROC SQL1 minute
Scenario: Using Indirect References2 minutes
Forward Rescan Rule2 minutes
Demo: Indirect References to Macro Variables5 minutes

17 assignmentsTotal 274 minutes

Storing and Processing Text50 minutes
Activity 3.0110 minutes
Question 3.022 minutes
Activity 3.0310 minutes
Activity 3.0410 minutes
Level 1 Practice: Using the %UPCASE and %SCAN Functions20 minutes
Level 2 Practice: Using Macro Quoting Functions20 minutes
Level 1 Practice: Using PROC SQL to Generate Macro Variables for Use in a Report Title20 minutes
Level 2 Practice: Using PROC SQL to Generate Macro Variables for Use in Subsequent Steps20 minutes
Activity3.0510 minutes
Question 3.062 minutes
Activity 3.0710 minutes
Level 1 Practice: Creating Macro Variables with the SYMPUTX Routine20 minutes
Level 2 Practice: Using a DATA _NULL_ Step to Create a Series of Macro Variables20 minutes
Activity 3.0810 minutes
Level 1 Practice: Using Indirect References to Macro Variables20 minutes
Level 2 Practice: Using Indirect References to Macro Variables20 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 videosTotal 63 minutes

Introduction1 minute
Defining a Macro2 minutes
Using the MCOMPILENOTE Option0 minutes
Calling a Macro2 minutes
Using the MPRINT Option1 minute
Macro Parameters1 minute
Demo: Defining a Macro with Parameters4 minutes
Macro Keyword Parameters2 minutes
Mixed Parameter Lists1 minute
Global Macro Variables2 minutes
Local Macro Variables1 minute
Macro Variable Scope1 minute
Controlling Macro Variable Scope3 minutes
Resolving Macro Variables1 minute
Nested Macro Calls4 minutes
Conditional Processing3 minutes
Conditionally Executing Program Steps2 minutes
Scenario: Nested Conditional Processing1 minute
Conditionally Generating Program Steps4 minutes
Conditionally Generating Complete and Partial Statements2 minutes
Using the MLOGIC Option1 minute
Demo: Conditional Processing6 minutes
Scenario: Generating Repetitive Code1 minute
%DO Iterative Statement4 minutes
Demo: Iterative %DO Loops4 minutes
Using a %DO Loop with Indirect References2 minutes
Demo: %DO Loops with Indirect References4 minutes
%DO WHILE Loops3 minutes
%DO UNTIL Loops1 minute

19 assignmentsTotal 287 minutes

Working with Macro Programs 50 minutes
Activity 4.0110 minutes
Activity 4.0210 minutes
Activity 4.0310 minutes
Level 1 Practice: Defining and Using a Macro with Parameters20 minutes
Level 2 Practice: Using a Macro to Generate PROC MEANS Code20 minutes
Question 4.042 minutes
Activity 4.0510 minutes
Activity 4.0610 minutes
Level 1 Practice: Understanding Symbol Tables10 minutes
Level 2 Practice: Controlling Macro Variable Scope20 minutes
Activity 4.0710 minutes
Activity 4.0810 minutes
Level 1 Practice: Using Macro Conditional Processing to Choose Which SAS Statements are Generated20 minutes
Level 2 Practice: Using Macro Conditional Processing in Open Code20 minutes
Activity 4.0910 minutes
Code Challenge 4.105 minutes
Level 1 Practice: Using Iterative Processing and Indirect Referencing20 minutes
Level 2 Practice: Using a %DO %UNTIL Loop20 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 videosTotal 36 minutes

Introduction1 minute
Compiled Macros2 minutes
Autocall Macro Facility2 minutes
Calling Autocall Macros2 minutes
Adding Personal Macros to an Autocall Library3 minutes
Demo: Macro Autocall Libraries5 minutes
Develop a SPLITTABLE Macro Application4 minutes
Demo: Generating Data-Dependent Code4 minutes
Enhancing Macro Applications1 minute
Validating Parameters2 minutes
Additional Validation Techniques3 minutes
Demo: Validating Parameters8 minutes
Documenting a Macro1 minute
Complex Macro Enhancements1 minute

1 readingTotal 2 minutes

SAS Autocall Facility Options2 minutes

12 assignmentsTotal 175 minutes

Developing Macro Applications 25 minutes
Activity 5.0110 minutes
Activity 5.0210 minutes
Activity 5.0310 minutes
Activity 5.0410 minutes
Level 1 Practice: Generating Data-Dependent Listing Reports20 minutes
Level 2 Practice: Exporting Data to Separate Worksheets in Microsoft Excel20 minutes
Activity 5.0510 minutes
Activity 5.0610 minutes
Activity 5.0710 minutes
Level 1 Practice: Validating a Macro Parameter20 minutes
Level 2 Practice: Validating Macro Parameters with Data Values20 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

11 Courses129,913 learners

Offered by

SAS

Explore more from Software Development

Status: Free Trial
EDUCBA
Mastering SAS Macros: Build, Automate & Optimize Programs
Course
Status: Free Trial
EDUCBA
Master SAS Macros for Dynamic and Automated Programming
Course
Status: Free Trial
EDUCBA
Advanced SAS Programming, Macros & Reporting
Specialization
Status: Free Trial
SAS
Doing More with SAS Programming
Course

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.43%
4 stars
10.59%
3 stars
2.64%
2 stars
0.66%
1 star
0.66%

Showing 3 of 151

Reviewed on Nov 15, 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 Feb 12, 2022

Thank you Stacey for your training with practical examples.

Reviewed on Jun 24, 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!

View more reviews

Unlock access to 10,000+ courses with a subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.