In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.
This course is part of the SAS Advanced Programmer Professional Certificate
Offered By
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
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
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
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
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. You'll also explore CALL routines, Perl regular expressions, and how to use advanced functions to modify and analyze storm, weather, and population 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
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
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.
When will I have access to the lectures and assignments?
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.
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.
What is the refund policy?
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.
