Advanced SAS Programming Techniques

Grow your skills with Coursera Plus for $239/year (usually $399). Save now.

Advanced SAS Programming Techniques

This course is part of SAS Advanced Programmer Professional Certificate

Instructor: Michele Ensor

4,734 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

95 reviews

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

95 reviews

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

43 assignments

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Analysis expertise

This course is part of the SAS Advanced Programmer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from SAS

There are 5 modules in this course

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.

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.

What's included

5 videos5 readings1 assignment

5 videos Total 15 minutes

Welcome to the Course 1 minute
Practicing in the Course 2 minutes
DATA Step Processing 3 minutes
Processing a Data Set 3 minutes
Demo: Reviewing DATA Step Syntax and Processing 6 minutes

5 readings Total 70 minutes

Learner Prerequisites 10 minutes
Using Forum and Getting Help 10 minutes
Access SAS Software for this Course 10 minutes
Set Up Data for This Course 30 minutes
Frequently Asked Questions 10 minutes

1 assignment Total 10 minutes

Activity 1.01 10 minutes

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.

What's included

16 videos1 reading12 assignments

16 videos Total 36 minutes

Overview 1 minute
Using Functions in SAS 2 minutes
Using the LAG Function 2 minutes
Demo: Retrieving Previous Values with the LAG Function 2 minutes
Calculating a Moving Average 1 minute
Best Practice for Calculating a Moving Average 1 minute
Using COUNT Functions 2 minutes
Using FIND Functions 2 minutes
Demo: Counting and Finding Words with Character Functions 3 minutes
What are Perl Regular Expressions? 1 minute
What are Metacharacters? 4 minutes
PRXPARSE and PRXMATCH Functions 3 minutes
Demo: Validating Data with the PRXMATCH Function 4 minutes
PRXCHANGE Function 2 minutes
Capture Buffers 2 minutes
Demo: Standardizing Data with the PRXCHANGE Function 3 minutes

1 reading Total 10 minutes

Metacharacter Examples 10 minutes

12 assignments Total 195 minutes

Activity 2.01 10 minutes
Activity 2.02 10 minutes
Activity 2.03 10 minutes
Activity 2.04 10 minutes
Practice Level 1: Using the LAG Function 20 minutes
Practice Level 2: Using the COUNT and FINDW Functions 20 minutes
Question 2.05 5 minutes
Activity 2.06 10 minutes
Activity 2.07 10 minutes
Practice Level 1: Using the PRXMATCH and PRXCHANGE Functions 20 minutes
Practice Level 2: Using the PRXCHANGE Function with Capture Buffers 20 minutes
Using Advanced Functions 50 minutes

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.

What's included

18 videos1 reading11 assignments

18 videos Total 35 minutes

Overview 0 minutes
Processing Repetitive Code 1 minute
Using an Array 3 minutes
Referencing an Array in a DO Loop 1 minute
Unknown Number of Array Elements 1 minute
Creating Numeric Columns with an Array 2 minutes
Specifying Lower and Upper Bounds 1 minute
Demo: Processing One-Dimensional Arrays: Part 1 4 minutes
Rotating Data 2 minutes
Specifying Initial Values for Array Elements 2 minutes
Creating Character Columns with an Array 1 minute
Demo: Processing One-Dimensional Arrays: Part 2 3 minutes
Two-Dimensional Arrays 0 minutes
Performing a Table Lookup 4 minutes
Demo: Processing Two-Dimensional Arrays: Part 1 3 minutes
Specifying Initial Values for Two-Dimensional Array Elements 1 minute
Loading a Two-Dimensional Array from a Table 1 minute
Demo: Processing Two-Dimensional Arrays: Part 2 3 minutes

1 reading Total 10 minutes

Array Advantages and Disadvantages 10 minutes

11 assignments Total 185 minutes

Activity 3.01 10 minutes
Activity 3.02 10 minutes
Activity 3.03 10 minutes
Question 3.04 10 minutes
Practice Level 1: Using One-Dimensional Arrays on Numeric Data 20 minutes
Practice Level 2: Using One-Dimensional Arrays on Character Data 20 minutes
Question 3.05 5 minutes
Activity 3.06 10 minutes
Practice Level 1: Using a Two-Dimensional Array Based on Initial Values 20 minutes
Practice Level 2: Using a Two-Dimensional Array Based on Loading a Table 20 minutes
Defining and Processing Arrays 50 minutes

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.

What's included

19 videos3 readings10 assignments

19 videos Total 30 minutes

Overview 1 minute
Performing a Table Lookup: Example 1 2 minutes
What is a Hash Object? 2 minutes
Hash Object Process: Example 1 1 minute
Declaring a Hash Object 1 minute
Using Hash Object Methods 2 minutes
Demo: Declaring and Defining a Hash Object 2 minutes
Performing a Table Lookup: Example 2 0 minutes
FIND Method 1 minute
KEY Arguments 1 minute
Demo: Performing a Table Lookup with the FIND Method 3 minutes
Adding Data to a Hash Object 1 minute
Saving a Hash Object 2 minutes
Demo: Creating a Table with the ADD and OUTPUT Methods 3 minutes
Unique and Duplicate Key Components 1 minute
What is a Hash Iterator Object? 1 minute
Creating the Hash Object and Hash Iterator Object 1 minute
Hash Iterator Object Methods 1 minute
Demo: Reading Data in Forward and Reverse Direction 2 minutes

3 readings Total 30 minutes

Specifying the DATASET Argument 10 minutes
Using Multiple Method Statements 10 minutes
Hash Object Advantages and Disadvantages 10 minutes

10 assignments Total 200 minutes

Activity 4.01 10 minutes
Activity 4.02 10 minutes
Practice Level 1: Performing a Table Lookup Using One Key 20 minutes
Practice Level 2: Performing a Table Lookup Using Three Keys 20 minutes
Activity 4.03 10 minutes
Practice Level 1: Creating a Sorted Table from a Hash Object 20 minutes
Practice Level 2: Eliminating a PROC SORT step by Creating a Sorted Table from a Hash Object 20 minutes
Practice Level 1: Reading Data in Forward and Reverse Direction 20 minutes
Practice Level 2: Reading Data in Forward and Reverse Directions 20 minutes
Defining and Processing Hash Objects 50 minutes

In this module, you'll learn how to use PROC FORMAT's PICTURE statement to create a custom template to display large numbers, dates, and times. You'll also use PROC FCMP, the function compiler procedure, to create custom functions and CALL routines.

What's included

12 videos1 reading9 assignments1 app item

12 videos Total 31 minutes

Overview 1 minute
Creating Custom Formats 2 minutes
Custom Date and Datetime Formats 4 minutes
Demo: Specifying a Template for Datetime Values 2 minutes
Custom Numeric Formats 6 minutes
Custom Large Number Format 2 minutes
Demo: Specifying a Template for Large Numbers 3 minutes
Creating and Using a Custom Function 4 minutes
Demo: Creating Functions Containing One Argument 2 minutes
Passing and Returning Values 1 minute
Demo: Creating Functions Containing Multiple Arguments 3 minutes
Creating a Custom Call Routine 2 minutes

1 reading Total 10 minutes

Advantages to Custom Functions and Call Routines 10 minutes

9 assignments Total 160 minutes

Question 5.01 5 minutes
Activity 5.02 10 minutes
Question 5.03 5 minutes
Practice Level 1: Specifying a Template Based on Date Directives 20 minutes
Practice Level 2: Specifying a Template Based on Digit Selectors 20 minutes
Activity 5.04 10 minutes
Practice Level 1: Creating a Custom Function That Returns a Numeric Value 20 minutes
Practice Level 2: Creating a Custom Function That Returns a Character Value 20 minutes
Using Utility Procedures 50 minutes

1 app item Total 60 minutes

SAS Certification Practice Exam: SAS 9.4 Advanced Programming Performance-Based Exam 60 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(27 ratings)

Michele Ensor

SAS

1 Course 4,734 learners

Offered by

SAS

Explore more from Data Analysis

EDUCBA
Master & Apply Advanced SAS Programming Techniques
Course
SAS
Doing More with SAS Programming
Course
EDUCBA
Apply Advanced PROC SQL Techniques for Data Analysis
Course
SAS
SAS Advanced Programmer
Professional Certificate

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
86.31%
4 stars
10.52%
3 stars
2.10%
2 stars
1.05%
1 star
0%

Showing 3 of 95

Reviewed on Oct 18, 2020

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

Reviewed on Feb 16, 2021

I want more! all of these SAS courses are great from format, pace, delivery! I'm truly enjoying the learning experience.

Reviewed on Nov 14, 2020

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

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

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.