This course is part of the SAS Advanced Programmer Professional Certificate

4.8
stars
126 ratings

Stacey Syphus

5,274 already enrolled

Offered By

SAS Advanced Programmer Professional CertificateSAS

About this Course

31,967 recent views

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.
Course Learning Objectives: (3+ per course)
“By the end of this course, a learner will be able to…”
●	Perform text substitution in SAS code.
●	Use macro variables and macro functions.
●	Automate and customize the production of SAS code.
●	Conditionally or iteratively construct SAS code.
●	Write self-modifying, data-driven programs.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 2 of 3 in the

SAS Advanced Programmer Professional Certificate

Intermediate Level

Approx. 20 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 2 of 3 in the

SAS Advanced Programmer Professional Certificate

Intermediate Level

Approx. 20 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.67/5 (34 Ratings)

Stacey Syphus

Offered by

SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

1 hour to complete

Introduction

1 hour to complete

5 videos (Total 5 min), 4 readings

Week2

Week 2

3 hours to complete

SAS Macro Facility

3 hours to complete

15 videos (Total 22 min)

15 videos

Introduction27sSAS Programming Languages1mProgram Flow1mTokens2mTokenization1mTokenizing Code with Macro Triggers2mMacro Variables1mCreating Macro Variables With %LET3mDeleting Macro Variables36sResolving Macro Variables3mUsing SYMBOLGEN to Troubleshoot Macro Variable References38sDelimiting Macro Variable References2mDisplaying Macro Variables54sAutomatic Macro Variables57sUpdating Macro Variables49s

11 practice exercises

Question 2.012mQuestion 2.022mQuestion 2.035mQuestion 2.042mActivity 2.0510mActivity 2.0610mActivity 2.0710mActivity 2.0810mLevel 1 Practice: Defining and Using Macro Variables for Substitution20mLevel 2 Practice: Using Macro Variable References with Delimiters20mSAS Macro Facility50m

Week3

Week 3

5 hours to complete

Storing and Processing Text

5 hours to complete

19 videos (Total 49 min)

19 videos

Introduction35sUsing Macro Functions1mSAS Functions and Macro Functions2mProcessing Text with Macro Functions2mExecuting SAS DATA Step Functions During Tokenization1mEvaluating Arithmetic Expressions2mUsing Special Characters4mDemo: Using Macro Functions4mCreating Macro Variables in PROC SQL4mDemo: Creating Macro Variables with a PROC SQL Query4mScenario: Create Macro Variables in a DATA Step1mDATA Step versus Macro Execution Timing1mCreating Macro Variables in a DATA Step2mCreating Macro Variables During DATA Step Execution1mDemo: Creating Macro Variables with the DATA Step3mComparing the DATA Step and PROC SQL45sScenario: Using Indirect References2mForward Rescan Rule2mDemo: Indirect References to Macro Variables4m

17 practice exercises

Activity 3.0110mQuestion 3.022mActivity 3.0310mActivity 3.0410mLevel 1 Practice: Using the %UPCASE and %SCAN Functions20mLevel 2 Practice: Using Macro Quoting Functions20mLevel 1 Practice: Using PROC SQL to Generate Macro Variables for Use in a Report Title20mLevel 2 Practice: Using PROC SQL to Generate Macro Variables for Use in Subsequent Steps20mActivity3.0510mQuestion 3.062mActivity 3.0710mLevel 1 Practice: Creating Macro Variables with the SYMPUTX Routine20mLevel 2 Practice: Using a DATA _NULL_ Step to Create a Series of Macro Variables20mActivity 3.0810mLevel 1 Practice: Using Indirect References to Macro Variables20mLevel 2 Practice: Using Indirect References to Macro Variables20mStoring and Processing Text50m

Week4

Week 4

6 hours to complete

Working with Macro Programs

6 hours to complete

29 videos (Total 63 min)

29 videos

Introduction42sDefining a Macro2mUsing the MCOMPILENOTE Option20sCalling a Macro1mUsing the MPRINT Option43sMacro Parameters1mDemo: Defining a Macro with Parameters3mMacro Keyword Parameters2mMixed Parameter Lists57sGlobal Macro Variables1mLocal Macro Variables1mMacro Variable Scope1mControlling Macro Variable Scope3mResolving Macro Variables1mNested Macro Calls4mConditional Processing3mConditionally Executing Program Steps1mScenario: Nested Conditional Processing1mConditionally Generating Program Steps3mConditionally Generating Complete and Partial Statements1mUsing the MLOGIC Option36sDemo: Conditional Processing5mScenario: Generating Repetitive Code49s%DO Iterative Statement3mDemo: Iterative %DO Loops3mUsing a %DO Loop with Indirect References2mDemo: %DO Loops with Indirect References3m%DO WHILE Loops2m%DO UNTIL Loops41s

19 practice exercises

Activity 4.0110mActivity 4.0210mActivity 4.0310mLevel 1 Practice: Defining and Using a Macro with Parameters20mLevel 2 Practice: Using a Macro to Generate PROC MEANS Code20mQuestion 4.042mActivity 4.0510mActivity 4.0610mLevel 1 Practice: Understanding Symbol Tables10mLevel 2 Practice: Controlling Macro Variable Scope20mActivity 4.0710mActivity 4.0810mLevel 1 Practice: Using Macro Conditional Processing to Choose Which SAS Statements are Generated20mLevel 2 Practice: Using Macro Conditional Processing in Open Code20mActivity 4.0910mCode Challenge 4.105mLevel 1 Practice: Using Iterative Processing and Indirect Referencing20mLevel 2 Practice: Using a %DO %UNTIL Loop20mWorking with Macro Programs 50m

Reviews

4.8

27 reviews

5 stars
85.71%
4 stars
11.11%
3 stars
2.38%
1 star
0.79%

TOP REVIEWS FROM SAS MACRO LANGUAGE

by DLDec 9, 2021

The course is great. I wonder if the instructor is Stacey Syphus. I took two other courses where Stacey Syphus was the instructor. The voice in this course is totally different from the other two.

by AVJun 25, 2022

I love it a lot. The best course ever that I could take. Many thanks

by TWMar 29, 2021

Another great course from SAS and Coursera. My macro skills are now quite a bit better than they were prior to the course. Great focus on using macros in iterative processing.

by MRFeb 11, 2022

Thank you Stacey for your training with practical examples.

View all reviews

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.

Frequently Asked Questions

When will I have access to the lectures and assignments?
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.
What will I get if I subscribe to this Certificate?
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.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

SAS Macro Language

About this Course