Doing More with SAS Programming

This course is part of SAS Programmer Professional Certificate

Instructor: Stacey Syphus

33,448 already enrolled

Included with Learn more

Ask Coursera

8 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

8 modules

Gain insight into a topic and learn the fundamentals.

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

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 videosTotal 23 minutes

Overview: Controlling DATA Step Processing0 minutes
DATA Step Review1 minute
DATA Step Processing1 minute
DATA Step Processing: Compilation3 minutes
DATA Step Processing: Execution1 minute
Demo: DATA Step Processing in Action6 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 Output1 minute
Demo: Directing Column Output3 minutes
Columns in the PDV1 minute

1 readingTotal 10 minutes

Syntax Review: Controlling DATA Step Processing10 minutes

9 assignmentsTotal 135 minutes

Controlling DATA Step Processing45 minutes
Activity 1.01 10 minutes
Activity 1.0210 minutes
Practice: Using PUTLOG Statements to Examine Execution Steps20 minutes
Activity 1.035 minutes
Activity 1.0410 minutes
Question 1.05 5 minutes
Level 1 Practice: Conditionally Creating Multiple Output Tables 10 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 19 minutes

Overview: Summarizing Data0 minutes
Demo: Creating an Accumulating Column4 minutes
Retaining Values in the PDV1 minute
Using the Sum Statement1 minute
Answering Questions about Groups1 minute
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 Groups3 minutes
Using Multiple BY Columns1 minute

1 readingTotal 10 minutes

Syntax Review: Summarizing Data10 minutes

11 assignmentsTotal 170 minutes

Summarizing Data50 minutes
Activity 2.0110 minutes
Question 2.025 minutes
Level 1 Practice: Producing a Running Total 10 minutes
Level 2 Practice: Producing Multiple Totals20 minutes
Activity 2.0310 minutes
Activity 2.0410 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 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 40 minutes

Overview: Manipulating Data with Functions0 minutes
Review of Functions1 minute
Specifying Columns Lists1 minute
Using a CALL Routine to Modify Data1 minute
Using Numeric Functions1 minute
Demo: Using Numeric Functions3 minutes
SAS Date, Datetime, and Time Values1 minute
Extracting Data from a Datetime Value0 minutes
Calculating Date Intervals2 minutes
Shifting Date Values1 minute
Demo: Shifting Date Values Based on an Interval3 minutes
Useful Character Functions1 minute
Extracting Words from a String1 minute
Demo: Using Character Functions to Extract Words from a String3 minutes
Searching for Character Strings1 minute
Replacing Character Strings0 minutes
Handling Column Type1 minute
Converting Column Type1 minute
Converting Character Values to Numeric Values2 minutes
Using a Generic Informat to Read Dates2 minutes
Converting the Type of an Existing Column2 minutes
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 Types4 minutes

5 readingsTotal 24 minutes

Using Numeric Functions to Change Precision3 minutes
Removing Characters from a String3 minutes
Identifying Character Positions5 minutes
Building Character Strings3 minutes
Syntax Review: Manipulating Data with Functions10 minutes

18 assignmentsTotal 220 minutes

Manipulating Data with Functions50 minutes
Activity 3.01 10 minutes
Activity 3.02 10 minutes
Activity 3.03 10 minutes
Activity 3.04 10 minutes
Question 3.055 minutes
Level 1 Practice: Using the LARGEST and ROUND Functions 10 minutes
Level 2 Practice: Working with Date/Time Values10 minutes
Activity 3.06 10 minutes
Activity 3.0710 minutes
Activity 3.08 10 minutes
Activity 3.0910 minutes
Level 1 Practice: Using the SCAN and PROPCASE Functions 10 minutes
Level 2 Practice: Searching for Character Strings20 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 assignments

8 videosTotal 16 minutes

Overview: Creating and Using Custom Formats0 minutes
Formatting Data Values0 minutes
Creating and Applying a Custom Format3 minutes
Using Ranges2 minutes
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 Review: Creating and Using Custom Formats10 minutes

10 assignmentsTotal 160 minutes

Creating and Using Custom Formats50 minutes
Activity 4.0110 minutes
Activity 4.02 10 minutes
Activity 4.03 10 minutes
Level 1 Practice: Creating Custom Formats Based on Single Values 10 minutes
Level 2 Practice: Creating Custom Formats Based on a Range of Values 10 minutes
Activity 4.0410 minutes
Activity 4.05 10 minutes
Level 1 Practice: Creating a Custom Format from a Table20 minutes
Level 2 Practice: Using Conditional Processing to Create a Format from a Table 20 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 minutes
Concatenating Tables with Matching Columns1 minute
Demo: Concatenating Tables3 minutes
Handling Column Attributes1 minute
What is a Merge?2 minutes
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 Nonmatches2 minutes
Demo: Merging Tables with Nonmatching Rows7 minutes
Merging Tables with Matching Column Names1 minute
Merging Tables without a Common Column1 minute
DATA Step Merge and PROC SQL Join1 minute

1 readingTotal 10 minutes

Syntax Review: Combining Tables10 minutes

10 assignmentsTotal 140 minutes

Combining Tables50 minutes
Activity 5.01 10 minutes
Level 1 Practice: Concatenating Like-Structured Tables10 minutes
Level 2 Practice: Concatenating Unlike-Structured Tables 10 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 10 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 videosTotal 25 minutes

Overview: Processing Repetitive Code0 minutes
Processing Repetitive Code1 minute
Iterative DO Loops2 minutes
Demo: Executing an Iterative DO Loop3 minutes
Output Inside and Outside the DO Loop2 minutes
Demo: Using Iterative DO Loops6 minutes
Conditional DO Loops1 minute
Checking the Condition1 minute
Demo: Using Conditional DO Loops5 minutes
Combining Iterative and Conditional DO Loops1 minute
Demo: Combining Iterative and Conditional DO Loops3 minutes

1 readingTotal 10 minutes

Syntax Review: Processing Repetitive Code10 minutes

7 assignmentsTotal 140 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) 10 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 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 minutes
Understanding Table Structure1 minute
Restructuring Data1 minute
Demo: Creating a Narrow Table with the DATA Step3 minutes
Creating a Wide Table with the DATA Step1 minute
The Transpose Procedure0 minutes
Transposing Values within Groups1 minute
Demo: Creating a Wide Table with PROC TRANSPOSE4 minutes
Creating a Narrow Table with PROC TRANSPOSE0 minutes
Changing Column Names1 minute

1 readingTotal 10 minutes

Syntax Review: Restructuring Tables10 minutes

9 assignmentsTotal 155 minutes

Restructuring Tables50 minutes
Question 7.01 5 minutes
Activity 7.02 10 minutes
Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow 10 minutes
Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide20 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

Stacey Syphus

SAS

11 Courses130,474 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."

Unlock access to 10,000+ courses with a subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.

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.