About this Course

3,308 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 3 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 16 hours to complete
English
Subtitles: English
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 3 of 3 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 16 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

Course Overview, Review, and Data Setup

1 hour to complete
5 videos (Total 15 min), 4 readings, 1 quiz
5 videos
Practicing in the Course2m
DATA Step Processing3m
Processing a Data Set2m
Demo: Reviewing DATA Step Syntax and Processing6m
4 readings
Learner Prerequisites10m
Using Forums and Getting Help10m
Access SAS Software for this Course10m
Set Up Data for This Course 30m
1 practice exercise
Activity 1.0110m
Week
2

Week 2

4 hours to complete

Using Advanced Functions

4 hours to complete
16 videos (Total 36 min), 1 reading, 12 quizzes
16 videos
Using Functions in SAS2m
Using the LAG Function2m
Demo: Retrieving Previous Values with the LAG Function2m
Calculating a Moving Average49s
Best Practice for Calculating a Moving Average37s
Using COUNT Functions2m
Using FIND Functions1m
Demo: Counting and Finding Words with Character Functions3m
What are Perl Regular Expressions?1m
What are Metacharacters?3m
PRXPARSE and PRXMATCH Functions3m
Demo: Validating Data with the PRXMATCH Function4m
PRXCHANGE Function2m
Capture Buffers2m
Demo: Standardizing Data with the PRXCHANGE Function3m
1 reading
Metacharacter Examples10m
12 practice exercises
Activity 2.0110m
Activity 2.0210m
Activity 2.0310m
Activity 2.0410m
Practice Level 1: Using the LAG Function20m
Practice Level 2: Using the COUNT and FINDW Functions20m
Question 2.055m
Activity 2.0610m
Activity 2.0710m
Practice Level 1: Using the PRXMATCH and PRXCHANGE Functions20m
Practice Level 2: Using the PRXCHANGE Function with Capture Buffers20m
Using Advanced Functions Review30m
Week
3

Week 3

3 hours to complete

Defining and Processing Arrays

3 hours to complete
18 videos (Total 35 min), 1 reading, 11 quizzes
18 videos
Processing Repetitive Code1m
Using an Array2m
Referencing an Array in a DO Loop1m
Unknown Number of Array Elements57s
Creating Numeric Columns with an Array1m
Specifying Lower and Upper Bounds1m
Demo: Processing One-Dimensional Arrays: Part 13m
Rotating Data1m
Specifying Initial Values for Array Elements1m
Creating Character Columns with an Array56s
Demo: Processing One-Dimensional Arrays: Part 22m
Two-Dimensional Arrays28s
Performing a Table Lookup4m
Demo: Processing Two-Dimensional Arrays: Part 13m
Specifying Initial Values for Two-Dimensional Array Elements1m
Loading a Two-Dimensional Array from a Table1m
Demo: Processing Two-Dimensional Arrays: Part 22m
1 reading
Array Advantages and Disadvantages10m
11 practice exercises
Activity 3.0110m
Activity 3.0210m
Activity 3.0310m
Question 3.0410m
Practice Level 1: Using One-Dimensional Arrays on Numeric Data20m
Practice Level 2: Using One-Dimensional Arrays on Character Data20m
Question 3.055m
Activity 3.0610m
Practice Level 1: Using a Two-Dimensional Array Based on Initial Values20m
Practice Level 2: Using a Two-Dimensional Array Based on Loading a Table20m
Defining and Processing Arrays Review30m
Week
4

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
Performing a Table Lookup: Example 11m
What is a Hash Object?1m
Hash Object Process: Example 11m
Declaring a Hash Object1m
Using Hash Object Methods2m
Demo: Declaring and Defining a Hash Object2m
Performing a Table Lookup: Example 227s
FIND Method1m
KEY Arguments50s
Demo: Performing a Table Lookup with the FIND Method3m
Adding Data to a Hash Object1m
Saving a Hash Object1m
Demo: Creating a Table with the ADD and OUTPUT Methods3m
Unique and Duplicate Key Components35s
What is a Hash Iterator Object?1m
Creating the Hash Object and Hash Iterator Object1m
Hash Iterator Object Methods46s
Demo: Reading Data in Forward and Reverse Direction2m
3 readings
Specifying the DATASET Argument10m
Using Multiple Method Statements10m
Has Object Advantages and Disadvantages10m
10 practice exercises
Activity 4.0110m
Activity 4.0210m
Practice Level 1: Performing a Table Lookup Using One Key20m
Practice Level 2: Performing a Table Lookup Using Three Keys20m
Activity 4.0310m
Practice Level 1: Creating a Sorted Table from a Hash Object20m
Practice Level 2: Eliminating a PROC SORT step by Creating a Sorted Table from a Hash Object20m
Practice Level 1: Reading Data in Forward and Reverse Direction20m
Practice Level 2: Reading Data in Forward and Reverse Directions20m
Defining and Processing Hash Objects 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

  • Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

  • If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

  • Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

  • If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

  • This course is one of a few offered on Coursera that are currently available only to learners who have paid or received financial aid, when available.

  • 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.

More questions? Visit the Learner Help Center.