This course is part of the SAS Advanced Programmer Professional Certificate

Michele Ensor

Offered By

SAS Advanced Programmer Professional CertificateSAS

About this Course

8,770 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.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 3 in the

SAS Advanced Programmer

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 17 hours to complete

English

Subtitles: English

Instructor

Michele Ensor

285 Learners

1 Course

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 3 in the

SAS Advanced Programmer

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 17 hours to complete

English

Subtitles: English

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.

Syllabus - What you will learn from this course

Week

Week 1

1 hour to complete

Course Overview, Review, and Data Setup

In this module, you'll set up software and data for this course. Then you'll review the concepts of SAS DATA step processing and how to process data sets.

1 hour to complete

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

5 videos

Welcome to the Course45s

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

Week 2

4 hours to complete

Using Advanced Functions

In this module, you'll use advanced functions to compare data between multiple rows in a SAS table, find and count substrings within a column, and clean and standardize data.

4 hours to complete

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

16 videos

Overview37s

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

Week 3

3 hours to complete

Defining and Processing Arrays

In this module, you'll learn how to use arrays to simplify your code. You'll use arrays to process repetitive code, rotate data, and perform table lookups.

3 hours to complete

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

18 videos

Overview25s

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

Week 4

4 hours to complete

Defining and Processing Hash Objects

In this module, you'll learn how to declare a hash object, instantiate or create an instance of the object, and initialize its lookup keys and data. You'll use the hash object to store and retrieve data, create an output table from the data in the hash object, and create a hash iterator object to process the data in a particular order.

4 hours to complete

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

19 videos

Overview43s

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.

Frequently Asked Questions

Can I preview a course before enrolling?
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.
What will I get when I enroll?
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.
When will I receive my 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.
Why can’t I audit this course?
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.

More questions? Visit the Learner Help Center.

Advanced SAS Programming Techniques