Doing More with SAS Programming

This course is part of SAS Programmer Professional Certificate

Instructor: Stacey Syphus

Access provided by MCPL TOLARAM

33,121 already enrolled

8 modules

Gain insight into a topic and learn the fundamentals.

944 reviews

Intermediate level

Some related experience required

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

8 modules

Gain insight into a topic and learn the fundamentals.

944 reviews

Intermediate level

Some related experience required

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

95%

Most learners liked this course

Skills you'll gain

Tools you'll learn

SAS (Software)

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

74 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 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 8 modules in this course

This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users.

In this course you learn how to understand and control DATA step processing, create an accumulating column and process data in groups, manipulate data with functions, convert column type, create custom formats, concatenate and merge tables, process repetitive code, and restructure tables. This course addresses Base SAS software. Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and apply SAS formats.

In this module you get an overview of what you learn in this course and you set up the software and data you use for activities and practices in the course.

What's included

2 videos4 readings

In this module, we dig deeper into the DATA step. You learn how the DATA step processes data behind the scenes. Then you use this knowledge to control when and where the DATA step outputs rows to new tables.

What's included

14 videos1 reading9 assignments

14 videos Total 23 minutes

Overview 0 minutes
DATA Step Review 1 minute
DATA Step Processing 1 minute
DATA Step Processing: Compilation 3 minutes
DATA Step Processing: Execution 1 minute
Demo: DATA Step Processing in Action 6 minutes
Viewing Execution in the Log 1 minute
Controlling DATA Step Processing 1 minute
Implicit and Explicit Output 1 minute
Sending Output to Multiple Tables 0 minutes
Demo: Directing Row Output 3 minutes
Controlling Column Output 1 minute
Demo: Directing Column Output 3 minutes
Columns in the PDV 1 minute

1 reading Total 10 minutes

Syntax Review 10 minutes

9 assignments Total 105 minutes

Controlling DATA Step Processing 0 minutes
Activity 1.01 10 minutes
Activity 1.02 10 minutes
Practice: Using PUTLOG Statements to Examine Execution Steps 20 minutes
Activity 1.03 10 minutes
Activity 1.04 10 minutes
Question 1.05 5 minutes
Level 1 Practice: Conditionally Creating Multiple Output Tables 20 minutes
Level 2 Practice: Conditionally Creating Columns and Output Tables 20 minutes

In this module, you learn new syntax that enables you to alter the default behavior of the DATA step to solve a problem. First you learn to create an accumulating column, or in other words generate a running total. Then you learn to process data in groups, so you can perform an action when each group begins or ends.

What's included

10 videos1 reading11 assignments

10 videos Total 19 minutes

Overview 0 minutes
Demo: Creating an Accumulating Column 4 minutes
Retaining Values in the PDV 1 minute
Using the Sum Statement 1 minute
Answering Questions about Groups 1 minute
Processing Sorted Data in Groups 1 minute
Demo: Identifying the First and Last Row in Each Group 4 minutes
Subsetting Rows in the Execution Phase 2 minutes
Demo: Creating an Accumulating Column within Groups 3 minutes
Using Multiple BY Columns 1 minute

1 reading Total 10 minutes

Syntax Review 10 minutes

11 assignments Total 180 minutes

Summarizing Data 50 minutes
Activity 2.01 10 minutes
Question 2.02 5 minutes
Level 1 Practice: Producing a Running Total 20 minutes
Level 2 Practice: Producing Multiple Totals 20 minutes
Activity 2.03 10 minutes
Activity 2.04 10 minutes
Activity 2.05 10 minutes
Question 2.06 5 minutes
Level 1 Practice: Generating an Accumulating Column within Groups 20 minutes
Level 2 Practice: Generating an Accumulating Column within Multiple Groups 20 minutes

In this module, you learn to use some new functions that enable you to manipulate numeric, date, and character values. In addition, you learn to use functions that change a column from one data type to another.

What's included

24 videos5 readings18 assignments

24 videos Total 40 minutes

Overview 0 minutes
Review of Functions 1 minute
Specifying Columns Lists 1 minute
Using a CALL Routine to Modify Data 1 minute
Using Numeric Functions 1 minute
Demo: Using Numeric Functions 3 minutes
SAS Date, Datetime, and Time Values 1 minute
Extracting Data from a Datetime Value 0 minutes
Calculating Date Intervals 2 minutes
Shifting Date Values 1 minute
Demo: Shifting Date Values Based on an Interval 3 minutes
Useful Character Functions 1 minute
Extracting Words from a String 1 minute
Demo: Using Character Functions to Extract Words from a String 3 minutes
Searching for Character Strings 1 minute
Replacing Character Strings 0 minutes
Handling Column Type 1 minute
Converting Column Type 1 minute
Converting Character Values to Numeric Values 2 minutes
Using a Generic Informat to Read Dates 2 minutes
Converting the Type of an Existing Column 2 minutes
Converting Numeric Values to Character Values 1 minute
Demo: Using the INPUT Function to Convert Column Types 7 minutes
Demo: Using the PUT Function to Convert Column Types 4 minutes

5 readings Total 50 minutes

Using Numeric Functions to Change Precision 10 minutes
Removing Characters from a String 10 minutes
Identifying Character Positions 10 minutes
Building Character Strings 10 minutes
Syntax Review 10 minutes

18 assignments Total 250 minutes

Manipulating Data with Functions 50 minutes
Activity 3.01 10 minutes
Activity 3.02 10 minutes
Activity 3.03 10 minutes
Activity 3.04 10 minutes
Question 3.05 5 minutes
Level 1 Practice: Using the LARGEST and ROUND Functions 20 minutes
Level 2 Practice: Working with Date/Time Values 20 minutes
Activity 3.06 10 minutes
Activity 3.07 10 minutes
Activity 3.08 10 minutes
Activity 3.09 10 minutes
Level 1 Practice: Using the SCAN and PROPCASE Functions 20 minutes
Level 2 Practice: Searching for Character Strings 20 minutes
Activity 3.10 10 minutes
Activity 3.11 10 minutes
Question 3.12 5 minutes
Activity 3.13 10 minutes

In this module, you learn to create and use custom formats to enhance the way your data is displayed in a table or report.

What's included

8 videos1 reading10 assignments1 discussion prompt

8 videos Total 16 minutes

Overview 0 minutes
Formatting Data Values 0 minutes
Creating and Applying a Custom Format 3 minutes
Using Ranges 2 minutes
Demo: Creating and Using Custom Formats 3 minutes
Reading a Table of Values for a Format 2 minutes
Demo: Creating Custom Formats from Tables 4 minutes
Storing Custom Formats 1 minute

1 reading Total 10 minutes

Syntax Review 10 minutes

10 assignments Total 180 minutes

Creating and Using Custom Formats 50 minutes
Activity 4.01 10 minutes
Activity 4.02 10 minutes
Activity 4.03 10 minutes
Level 1 Practice: Creating Custom Formats Based on Single Values 20 minutes
Level 2 Practice: Creating Custom Formats Based on a Range of Values 20 minutes
Activity 4.04 10 minutes
Activity 4.05 10 minutes
Level 1 Practice: Creating a Custom Format from a Table 20 minutes
Level 2 Practice: Using Conditional Processing to Create a Format from a Table 20 minutes

1 discussion prompt Total 10 minutes

Your Turn - Evaluate different methods for creating custom formats 10 minutes

In this module, we take a comprehensive look at combining tables by using the DATA step. You learn to concatenate tables, merge tables, and identify matching and nonmatching rows.

What's included

14 videos1 reading10 assignments

14 videos Total 28 minutes

Overview 0 minutes
Concatenating Tables with Matching Columns 1 minute
Demo: Concatenating Tables 3 minutes
Handling Column Attributes 1 minute
What is a Merge? 2 minutes
Processing a One-to-One Merge 2 minutes
Processing a One-To-Many Merge 1 minute
Demo: Merging Tables 3 minutes
Merging Tables with Nonmatching Rows 2 minutes
Identifying Matches and Nonmatches 2 minutes
Demo: Merging Tables with Nonmatching Rows 7 minutes
Merging Tables with Matching Column Names 1 minute
Merging Tables without a Common Column 1 minute
DATA Step Merge and PROC SQL Join 1 minute

1 reading Total 10 minutes

Syntax Review 10 minutes

10 assignments Total 170 minutes

Combining Tables 50 minutes
Activity 5.01 10 minutes
Level 1 Practice: Concatenating Like-Structured Tables 20 minutes
Level 2 Practice: Concatenating Unlike-Structured Tables 20 minutes
Question 5.02 5 minutes
Activity 5.03 10 minutes
Question 5.04 5 minutes
Activity 5.05 10 minutes
Level 1 Practice: Performing a One-to-Many Merge 20 minutes
Level 2 Practice: Writing Matches and Nonmatches to Separate Tables 20 minutes

In this module, you learn to save time by taking advantage of iterative processing with DO loops. First you learn to create an iterative DO Loop, then you learn to create conditional DO loops.

What's included

11 videos1 reading7 assignments

11 videos Total 25 minutes

Overview 0 minutes
Processing Repetitive Code 1 minute
Iterative DO Loops 2 minutes
Demo: Executing an Iterative DO Loop 3 minutes
Output Inside and Outside the DO Loop 2 minutes
Demo: Using Iterative DO Loops 6 minutes
Conditional DO Loops 1 minute
Checking the Condition 1 minute
Demo: Using Conditional DO Loops 5 minutes
Combining Iterative and Conditional DO Loops 1 minute
Demo: Combining Iterative and Conditional DO Loops 3 minutes

1 reading Total 10 minutes

Syntax Review 10 minutes

7 assignments Total 150 minutes

Processing Repetitive Code 50 minutes
Activity 6.01 10 minutes
Level 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement) 20 minutes
Level 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement) 20 minutes
Activity 6.02 10 minutes
Level 1 Practice: Using a Conditional DO Loop 20 minutes
Level 2 Practice: Using an Iterative and Conditional DO Loop 20 minutes

In this module, you learn techniques that can be used to transpose or restructure a table. First you learn to restructure data with the DATA step. Then you learn to restructure data by using the TRANSPOSE procedure.

What's included

10 videos1 reading9 assignments

10 videos Total 12 minutes

Overview 0 minutes
Understanding Table Structure 1 minute
Restructuring Data 1 minute
Demo: Creating a Narrow Table with the DATA Step 3 minutes
Creating a Wide Table with the DATA Step 1 minute
The Transpose Procedure 0 minutes
Transposing Values within Groups 1 minute
Demo: Creating a Wide Table with PROC TRANSPOSE 4 minutes
Creating a Narrow Table with PROC TRANSPOSE 0 minutes
Changing Column Names 1 minute

1 reading Total 10 minutes

Syntax Review 10 minutes

9 assignments Total 165 minutes

Restructuring Tables 50 minutes
Question 7.01 5 minutes
Activity 7.02 10 minutes
Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow 20 minutes
Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide 20 minutes
Activity 7.03 10 minutes
Activity 7.04 10 minutes
Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow 20 minutes
Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide 20 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

(188 ratings)

Stacey Syphus

SAS

8 Courses 128,501 learners

Offered by

SAS

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
85.69%
4 stars
12.50%
3 stars
1.58%
2 stars
0%
1 star
0.21%

Showing 3 of 944

Reviewed on Jun 25, 2022

It was a good and informative course and I learned from it. However, soemtimes I felt that various compnents of the code were not being explained very well.

Reviewed on Aug 14, 2019

This course provided me with the know how needed to write SAS programs. I would definitely recommend this course for folks looking to get an insight on writing or understanding SAS codes.

Reviewed on Apr 16, 2020

Very good course. The instructor is one of the greatest I found when dealing with online courses. It is easy to understand, and you will definitely use it throughout your codes. Take it!

View more reviews