Doing More with SAS Programming

This course is part of SAS Programmer Professional Certificate

Instructor: Stacey Syphus

Skills you'll gain

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

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

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

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 videos3 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 videosTotal 22 minutes

Overview0 minutesPreview module
DATA Step Review0 minutes
DATA Step Processing0 minutes
DATA Step Processing: Compilation3 minutes
DATA Step Processing: Execution1 minute
Demo: DATA Step Processing in Action5 minutes
Viewing Execution in the Log1 minute
Controlling DATA Step Processing1 minute
Implicit and Explicit Output1 minute
Sending Output to Multiple Tables0 minutes
Demo: Directing Row Output3 minutes
Controlling Column Output0 minutes
Demo: Directing Column Output3 minutes
Columns in the PDV0 minutes

1 readingTotal 10 minutes

Syntax Review10 minutes

9 assignmentsTotal 105 minutes

Controlling DATA Step Processing0 minutes
Activity 1.0110 minutes
Activity 1.0210 minutes
Practice: Using PUTLOG Statements to Examine Execution Steps20 minutes
Activity 1.0310 minutes
Activity 1.0410 minutes
Question 1.055 minutes
Level 1 Practice: Conditionally Creating Multiple Output Tables20 minutes
Level 2 Practice: Conditionally Creating Columns and Output Tables20 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 videosTotal 18 minutes

Overview0 minutesPreview module
Demo: Creating an Accumulating Column3 minutes
Retaining Values in the PDV1 minute
Using the Sum Statement0 minutes
Answering Questions about Groups0 minutes
Processing Sorted Data in Groups1 minute
Demo: Identifying the First and Last Row in Each Group4 minutes
Subsetting Rows in the Execution Phase2 minutes
Demo: Creating an Accumulating Column within Groups2 minutes
Using Multiple BY Columns1 minute

1 readingTotal 10 minutes

Syntax Review10 minutes

11 assignmentsTotal 180 minutes

Summarizing Data50 minutes
Activity 2.0110 minutes
Question 2.025 minutes
Level 1 Practice: Producing a Running Total20 minutes
Level 2 Practice: Producing Multiple Totals20 minutes
Activity 2.0310 minutes
Activity 2.0410 minutes
Activity 2.0510 minutes
Question 2.065 minutes
Level 1 Practice: Generating an Accumulating Column within Groups20 minutes
Level 2 Practice: Generating an Accumulating Column within Multiple Groups20 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 videosTotal 39 minutes

Overview0 minutesPreview module
Review of Functions0 minutes
Specifying Columns Lists1 minute
Using a CALL Routine to Modify Data1 minute
Using Numeric Functions1 minute
Demo: Using Numeric Functions2 minutes
SAS Date, Datetime, and Time Values0 minutes
Extracting Data from a Datetime Value0 minutes
Calculating Date Intervals2 minutes
Shifting Date Values0 minutes
Demo: Shifting Date Values Based on an Interval3 minutes
Useful Character Functions0 minutes
Extracting Words from a String0 minutes
Demo: Using Character Functions to Extract Words from a String3 minutes
Searching for Character Strings0 minutes
Replacing Character Strings0 minutes
Handling Column Type0 minutes
Converting Column Type1 minute
Converting Character Values to Numeric Values1 minute
Using a Generic Informat to Read Dates1 minute
Converting the Type of an Existing Column1 minute
Converting Numeric Values to Character Values1 minute
Demo: Using the INPUT Function to Convert Column Types7 minutes
Demo: Using the PUT Function to Convert Column Types3 minutes

5 readingsTotal 50 minutes

Using Numeric Functions to Change Precision10 minutes
Removing Characters from a String10 minutes
Identifying Character Positions10 minutes
Building Character Strings10 minutes
Syntax Review10 minutes

18 assignmentsTotal 250 minutes

Manipulating Data with Functions50 minutes
Activity 3.0110 minutes
Activity 3.0210 minutes
Activity 3.0310 minutes
Activity 3.0410 minutes
Question 3.055 minutes
Level 1 Practice: Using the LARGEST and ROUND Functions20 minutes
Level 2 Practice: Working with Date/Time Values20 minutes
Activity 3.0610 minutes
Activity 3.0710 minutes
Activity 3.0810 minutes
Activity 3.0910 minutes
Level 1 Practice: Using the SCAN and PROPCASE Functions20 minutes
Level 2 Practice: Searching for Character Strings20 minutes
Activity 3.1010 minutes
Activity 3.1110 minutes
Question 3.125 minutes
Activity 3.1310 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 videosTotal 16 minutes

Overview0 minutesPreview module
Formatting Data Values0 minutes
Creating and Applying a Custom Format2 minutes
Using Ranges1 minute
Demo: Creating and Using Custom Formats3 minutes
Reading a Table of Values for a Format2 minutes
Demo: Creating Custom Formats from Tables4 minutes
Storing Custom Formats1 minute

1 readingTotal 10 minutes

Syntax Review10 minutes

10 assignmentsTotal 180 minutes

Creating and Using Custom Formats50 minutes
Activity 4.0110 minutes
Activity 4.0210 minutes
Activity 4.0310 minutes
Level 1 Practice: Creating Custom Formats Based on Single Values20 minutes
Level 2 Practice: Creating Custom Formats Based on a Range of Values20 minutes
Activity 4.0410 minutes
Activity 4.0510 minutes
Level 1 Practice: Creating a Custom Format from a Table20 minutes
Level 2 Practice: Using Conditional Processing to Create a Format from a Table20 minutes

1 discussion promptTotal 10 minutes

Your Turn - Evaluate different methods for creating custom formats10 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 videosTotal 28 minutes

Overview0 minutesPreview module
Concatenating Tables with Matching Columns1 minute
Demo: Concatenating Tables3 minutes
Handling Column Attributes0 minutes
What is a Merge?1 minute
Processing a One-to-One Merge2 minutes
Processing a One-To-Many Merge1 minute
Demo: Merging Tables3 minutes
Merging Tables with Nonmatching Rows2 minutes
Identifying Matches and Nonmatches1 minute
Demo: Merging Tables with Nonmatching Rows6 minutes
Merging Tables with Matching Column Names1 minute
Merging Tables without a Common Column1 minute
DATA Step Merge and PROC SQL Join0 minutes

1 readingTotal 10 minutes

Syntax Review10 minutes

10 assignmentsTotal 170 minutes

Combining Tables50 minutes
Activity 5.0110 minutes
Level 1 Practice: Concatenating Like-Structured Tables20 minutes
Level 2 Practice: Concatenating Unlike-Structured Tables20 minutes
Question 5.025 minutes
Activity 5.0310 minutes
Question 5.045 minutes
Activity 5.0510 minutes
Level 1 Practice: Performing a One-to-Many Merge20 minutes
Level 2 Practice: Writing Matches and Nonmatches to Separate Tables20 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 videosTotal 25 minutes

Overview0 minutesPreview module
Processing Repetitive Code0 minutes
Iterative DO Loops2 minutes
Demo: Executing an Iterative DO Loop2 minutes
Output Inside and Outside the DO Loop2 minutes
Demo: Using Iterative DO Loops5 minutes
Conditional DO Loops1 minute
Checking the Condition1 minute
Demo: Using Conditional DO Loops4 minutes
Combining Iterative and Conditional DO Loops1 minute
Demo: Combining Iterative and Conditional DO Loops3 minutes

1 readingTotal 10 minutes

Syntax Review10 minutes

7 assignmentsTotal 150 minutes

Processing Repetitive Code50 minutes
Activity 6.0110 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.0210 minutes
Level 1 Practice: Using a Conditional DO Loop20 minutes
Level 2 Practice: Using an Iterative and Conditional DO Loop20 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 videosTotal 12 minutes

Overview0 minutesPreview module
Understanding Table Structure0 minutes
Restructuring Data0 minutes
Demo: Creating a Narrow Table with the DATA Step2 minutes
Creating a Wide Table with the DATA Step0 minutes
The Transpose Procedure0 minutes
Transposing Values within Groups0 minutes
Demo: Creating a Wide Table with PROC TRANSPOSE4 minutes
Creating a Narrow Table with PROC TRANSPOSE0 minutes
Changing Column Names0 minutes

1 readingTotal 10 minutes

Syntax Review10 minutes

9 assignmentsTotal 165 minutes

Restructuring Tables50 minutes
Question 7.015 minutes
Activity 7.0210 minutes
Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow20 minutes
Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide20 minutes
Activity 7.0310 minutes
Activity 7.0410 minutes
Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow20 minutes
Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide20 minutes

Instructor

Instructor ratings

4.9 (186 ratings)

Stacey Syphus

SAS

8 Courses118,900 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

4.8

934 reviews

5 stars
85.66%
4 stars
12.51%
3 stars
1.60%
2 stars
0%
1 star
0.21%

Showing 3 of 934

Reviewed on Sep 17, 2019

very professional, with good examples, the only thing it didn't have was MACROS. Other than that it's a perfect course

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 Dec 1, 2019

The course is very informative and interactive. Challenging and exciting, as it balances between theory and practicals. Looking forward to the last course of the series.

View more reviews