About this Course

26,508 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 2 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 19 hours to complete
English
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 2 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 19 hours to complete
English

Offered by

Placeholder

SAS

Syllabus - What you will learn from this course

Week
1

Week 1

1 hour to complete

Introduction

1 hour to complete
5 videos (Total 5 min), 4 readings
5 videos
Introduction14s
Benefits of Using SAS Macro2m
Efficiency of Macro-Based Applications17s
Developing Macro Applications54s
4 readings
Learner Prerequisites2m
Using Forums and Getting Help10m
Access SAS Software for this Course10m
Set Up Data for This Course 30m
Week
2

Week 2

2 hours to complete

SAS Macro Facility

2 hours to complete
15 videos (Total 22 min)
15 videos
SAS Programming Languages1m
Program Flow1m
Tokens2m
Tokenization1m
Tokenizing Code with Macro Triggers2m
Macro Variables1m
Creating Macro Variables With %LET3m
Deleting Macro Variables36s
Resolving Macro Variables3m
Using SYMBOLGEN to Troubleshoot Macro Variable References38s
Delimiting Macro Variable References2m
Displaying Macro Variables54s
Automatic Macro Variables57s
Updating Macro Variables49s
11 practice exercises
Question 2.012m
Question 2.022m
Question 2.035m
Question 2.042m
Activity 2.0510m
Activity 2.0610m
Activity 2.0710m
Activity 2.0810m
Level 1 Practice: Defining and Using Macro Variables for Substitution20m
Level 2 Practice: Using Macro Variable References with Delimiters20m
SAS Macro Facility Review 30m
Week
3

Week 3

5 hours to complete

Storing and Processing Text

5 hours to complete
19 videos (Total 49 min)
19 videos
Using Macro Functions1m
SAS Functions and Macro Functions2m
Processing Text with Macro Functions2m
Executing SAS DATA Step Functions During Tokenization1m
Evaluating Arithmetic Expressions2m
Using Special Characters4m
Demo: Using Macro Functions4m
Creating Macro Variables in PROC SQL4m
Demo: Creating Macro Variables with a PROC SQL Query4m
Scenario: Create Macro Variables in a DATA Step1m
DATA Step versus Macro Execution Timing1m
Creating Macro Variables in a DATA Step2m
Creating Macro Variables During DATA Step Execution1m
Demo: Creating Macro Variables with the DATA Step3m
Comparing the DATA Step and PROC SQL45s
Scenario: Using Indirect References2m
Forward Rescan Rule2m
Demo: Indirect References to Macro Variables4m
17 practice exercises
Activity 3.0110m
Question 3.022m
Activity 3.0310m
Activity 3.0410m
Level 1 Practice: Using the %UPCASE and %SCAN Functions20m
Level 2 Practice: Using Macro Quoting Functions20m
Level 1 Practice: Using PROC SQL to Generate Macro Variables for Use in a Report Title20m
Level 2 Practice: Using PROC SQL to Generate Macro Variables for Use in Subsequent Steps20m
Activity3.0510m
Question 3.062m
Activity 3.0710m
Level 1 Practice: Creating Macro Variables with the SYMPUTX Routine20m
Level 2 Practice: Using a DATA _NULL_ Step to Create a Series of Macro Variables20m
Activity 3.0810m
Level 1 Practice: Using Indirect References to Macro Variables20m
Level 2 Practice: Using Indirect References to Macro Variables20m
Storing and Processing Text Review 30m
Week
4

Week 4

5 hours to complete

Working with Macro Programs

5 hours to complete
29 videos (Total 63 min)
29 videos
Defining a Macro2m
Using the MCOMPILENOTE Option20s
Calling a Macro1m
Using the MPRINT Option43s
Macro Parameters1m
Demo: Defining a Macro with Parameters3m
Macro Keyword Parameters2m
Mixed Parameter Lists57s
Global Macro Variables1m
Local Macro Variables1m
Macro Variable Scope1m
Controlling Macro Variable Scope3m
Resolving Macro Variables1m
Nested Macro Calls4m
Conditional Processing3m
Conditionally Executing Program Steps1m
Scenario: Nested Conditional Processing1m
Conditionally Generating Program Steps3m
Conditionally Generating Complete and Partial Statements1m
Using the MLOGIC Option36s
Demo: Conditional Processing5m
Scenario: Generating Repetitive Code49s
%DO Iterative Statement3m
Demo: Iterative %DO Loops3m
Using a %DO Loop with Indirect References2m
Demo: %DO Loops with Indirect References3m
%DO WHILE Loops2m
%DO UNTIL Loops41s
19 practice exercises
Activity 4.0110m
Activity 4.0210m
Activity 4.0310m
Level 1 Practice: Defining and Using a Macro with Parameters20m
Level 2 Practice: Using a Macro to Generate PROC MEANS Code20m
Question 4.042m
Activity 4.0510m
Activity 4.0610m
Level 1 Practice: Understanding Symbol Tables10m
Level 2 Practice: Controlling Macro Variable Scope20m
Activity 4.0710m
Activity 4.0810m
Level 1 Practice: Using Macro Conditional Processing to Choose Which SAS Statements are Generated20m
Level 2 Practice: Using Macro Conditional Processing in Open Code20m
Activity 4.0910m
Code Challenge 4.105m
Level 1 Practice: Using Iterative Processing and Indirect Referencing20m
Level 2 Practice: Using a %DO %UNTIL Loop20m
Working with Macro Programs Review30m

Reviews

TOP REVIEWS FROM SAS MACRO LANGUAGE

View all reviews

About the SAS Advanced Programmer Professional Certificate

SAS Advanced Programmer

Frequently Asked Questions

More questions? Visit the Learner Help Center.