This course is part of the SAS Advanced Programmer Professional Certificate

4.8
stars
79 ratings

Michele Ensor

2,684 already enrolled

Offered By

SAS Advanced Programmer Professional CertificateSAS

About this Course

16,523 recent views

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.
“By the end of this course, a learner will be able to…”
●	Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW).
●	Perform pattern matching using PRX functions.
●	Process repetitive code, rotate data, and perform table lookups using arrays.
●	Perform table lookups and sort data using hash and hash iterator objects.
●	Create numeric templates using the FORMAT procedure.
●	Create custom functions using the FCMP procedure.

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 3 of 3 in the

SAS Advanced Programmer Professional Certificate

Intermediate Level

Approx. 17 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 3 of 3 in the

SAS Advanced Programmer Professional Certificate

Intermediate Level

Approx. 17 hours to complete

English

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

Try Coursera for Business

Instructor

Instructor rating

4.81/5 (23 Ratings)

Michele Ensor

2,684 Learners

1 Course

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

Course Overview, Review, and Data Setup

1 hour to complete

5 videos (Total 15 min), 4 readings, 1 quiz

Week2

Week 2

4 hours to complete

Using Advanced Functions

4 hours to complete

16 videos (Total 36 min), 1 reading, 12 quizzes

16 videos

Overview37sUsing Functions in SAS2mUsing the LAG Function2mDemo: Retrieving Previous Values with the LAG Function2mCalculating a Moving Average49sBest Practice for Calculating a Moving Average37sUsing COUNT Functions2mUsing FIND Functions1mDemo: Counting and Finding Words with Character Functions3mWhat are Perl Regular Expressions?1mWhat are Metacharacters?3mPRXPARSE and PRXMATCH Functions3mDemo: Validating Data with the PRXMATCH Function4mPRXCHANGE Function2mCapture Buffers2mDemo: Standardizing Data with the PRXCHANGE Function3m

1 reading

Metacharacter Examples10m

12 practice exercises

Activity 2.0110mActivity 2.0210mActivity 2.0310mActivity 2.0410mPractice Level 1: Using the LAG Function20mPractice Level 2: Using the COUNT and FINDW Functions20mQuestion 2.055mActivity 2.0610mActivity 2.0710mPractice Level 1: Using the PRXMATCH and PRXCHANGE Functions20mPractice Level 2: Using the PRXCHANGE Function with Capture Buffers20mUsing Advanced Functions50m

Week3

Week 3

4 hours to complete

Defining and Processing Arrays

4 hours to complete

18 videos (Total 35 min), 1 reading, 11 quizzes

18 videos

Overview25sProcessing Repetitive Code1mUsing an Array2mReferencing an Array in a DO Loop1mUnknown Number of Array Elements57sCreating Numeric Columns with an Array1mSpecifying Lower and Upper Bounds1mDemo: Processing One-Dimensional Arrays: Part 13mRotating Data1mSpecifying Initial Values for Array Elements1mCreating Character Columns with an Array56sDemo: Processing One-Dimensional Arrays: Part 22mTwo-Dimensional Arrays28sPerforming a Table Lookup4mDemo: Processing Two-Dimensional Arrays: Part 13mSpecifying Initial Values for Two-Dimensional Array Elements1mLoading a Two-Dimensional Array from a Table1mDemo: Processing Two-Dimensional Arrays: Part 22m

1 reading

Array Advantages and Disadvantages10m

11 practice exercises

Activity 3.0110mActivity 3.0210mActivity 3.0310mQuestion 3.0410mPractice Level 1: Using One-Dimensional Arrays on Numeric Data20mPractice Level 2: Using One-Dimensional Arrays on Character Data20mQuestion 3.055mActivity 3.0610mPractice Level 1: Using a Two-Dimensional Array Based on Initial Values20mPractice Level 2: Using a Two-Dimensional Array Based on Loading a Table20mDefining and Processing Arrays50m

Week4

Week 4

4 hours to complete

Defining and Processing Hash Objects

4 hours to complete

19 videos (Total 30 min), 3 readings, 10 quizzes

19 videos

Overview43sPerforming a Table Lookup: Example 11mWhat is a Hash Object?1mHash Object Process: Example 11mDeclaring a Hash Object1mUsing Hash Object Methods2mDemo: Declaring and Defining a Hash Object2mPerforming a Table Lookup: Example 227sFIND Method1mKEY Arguments50sDemo: Performing a Table Lookup with the FIND Method3mAdding Data to a Hash Object1mSaving a Hash Object1mDemo: Creating a Table with the ADD and OUTPUT Methods3mUnique and Duplicate Key Components35sWhat is a Hash Iterator Object?1mCreating the Hash Object and Hash Iterator Object1mHash Iterator Object Methods46sDemo: Reading Data in Forward and Reverse Direction2m

3 readings

Specifying the DATASET Argument10mUsing Multiple Method Statements10mHash Object Advantages and Disadvantages10m

10 practice exercises

Activity 4.0110mActivity 4.0210mPractice Level 1: Performing a Table Lookup Using One Key20mPractice Level 2: Performing a Table Lookup Using Three Keys20mActivity 4.0310mPractice Level 1: Creating a Sorted Table from a Hash Object20mPractice Level 2: Eliminating a PROC SORT step by Creating a Sorted Table from a Hash Object20mPractice Level 1: Reading Data in Forward and Reverse Direction20mPractice Level 2: Reading Data in Forward and Reverse Directions20mDefining and Processing Hash Objects50m

Reviews

4.8

18 reviews

5 stars
88.60%
4 stars
8.86%
3 stars
1.26%
2 stars
1.26%

TOP REVIEWS FROM ADVANCED SAS PROGRAMMING TECHNIQUES

by MSNov 14, 2020

The Course goes through detailed examples and practices to clarify the techniques and concepts, useful and efficient.

by SWOct 18, 2020

Passed SAS adv exam after taking this course. It's very useful.

by RCJun 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!

by DGDec 12, 2022

Amazing course! With some additional practice, I feel like I'll soon be ready to pass the exam :-)

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

Advanced SAS Programming Techniques

About this Course