About this Course

19,979 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. 18 hours to complete
English
Subtitles: 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. 18 hours to complete
English
Subtitles: English

Offered by

SAS logo

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

About the SAS Advanced Programmer Professional Certificate

When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam....
SAS Advanced Programmer

Frequently Asked Questions

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. 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. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

  • This Course doesn't carry university credit, but some universities may choose to accept Course Certificates for credit. Check with your institution to learn more. Online Degrees and Mastertrack™ Certificates on Coursera provide the opportunity to earn university credit.

More questions? Visit the Learner Help Center.