Practical SAS Programming and Certification Review

Instructor: Stacey Syphus

Access provided by Transport and Telecommunication Institute

15,580 already enrolled

7 modules

Gain insight into a topic and learn the fundamentals.

356 reviews

Intermediate level

Some related experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

7 modules

Gain insight into a topic and learn the fundamentals.

356 reviews

Intermediate level

Some related experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

94%

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

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

In this course you have the opportunity to use the skills you acquired in the two SAS programming courses to solve realistic problems. This course is also designed to give you a thorough review of SAS programming concepts so you are prepared to take the SAS Certified Specialist: Base Programming Using SAS 9.4 Exam.

In this module you get an overview of this course and set up the data you need for practices and activities.

What's included

3 videos4 readings

This module is a review of the first three modules of the Getting Started with SAS Programming course. Lectures demonstrate the concepts you learned, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.

What's included

9 videos3 readings11 assignments

9 videos Total 26 minutes

Program Structure and Syntax 3 minutes
Required SAS Column Attributes 4 minutes
Finding and Resolving Syntax Errors 2 minutes
Overview 1 minute
Directly Accessing Structured Data 4 minutes
Importing Unstructured Data 3 minutes
Viewing Table Properties with PROC CONTENTS 3 minutes
Overview 1 minute
Using SAS Procedures to Explore and Validate Data 7 minutes

3 readings Total 30 minutes

SAS® Certification Prep Guide Review: Essentials 10 minutes
SAS® Certification Prep Guide Review - Access 10 minutes
SAS® Certification Prep Guide Review - Explore 10 minutes

11 assignments Total 140 minutes

Programming Question 1.01 10 minutes
Programming Question 1.02 10 minutes
Programming Question 1.03 10 minutes
Programming Question 1.04 10 minutes
Programming Question 1.05 10 minutes
Programming Question 1.06 10 minutes
Programming Question 1.07 10 minutes
Programming Question 1.08 10 minutes
Essentials Review Questions 20 minutes
Accessing Data Review Questions 20 minutes
Exploring Data Review Questions 20 minutes

This module reviews the preparing, analyzing and exporting modules of the Getting Started with SAS Programming course. Lectures demonstrate the concepts you learned, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.

What's included

8 videos3 readings14 assignments

8 videos Total 31 minutes

Overview 1 minute
Using the DATA Step to Prepare Data 7 minutes
Using PROC SQL to Join Tables 3 minutes
Using PROC FREQ 3 minutes
Using PROC MEANS 7 minutes
Overview 1 minute
Using PROC EXPORT 3 minutes
Using the Output Delivery System 6 minutes

3 readings Total 30 minutes

SAS® Certification Prep Guide Review - Prepare 10 minutes
SAS® Certification Prep Guide Review - Analyze 10 minutes
SAS® Certification Prep Guide Review - Export 10 minutes

14 assignments Total 170 minutes

Programming Question 2.01 10 minutes
Programming Question 2.02 10 minutes
Programming Question 2.03 10 minutes
Programming Question 2.04 10 minutes
Programming Question 2.05 10 minutes
Programming Question 2.06 10 minutes
Programming Question 2.07 10 minutes
Programming Question 2.08 10 minutes
Programming Question 2.09 10 minutes
Programming Question 2.10 10 minutes
Programming Question 2.11 10 minutes
Preparing Data Review Questions 20 minutes
Analyzing Data Review Questions 20 minutes
Exporting Data Review Questions 20 minutes

This module enables you to apply what you learned in Getting Started with SAS Programming to a real programming problem.

What's included

6 videos9 readings1 assignment1 discussion prompt

6 videos Total 35 minutes

Case Study Overview 5 minutes
Accessing Data - Solution 3 minutes
Exploring Data - Solution 6 minutes
Preparing Data - Solution 8 minutes
Analyzing Data - Solution 10 minutes
Exporting Reports - Solution 4 minutes

9 readings Total 90 minutes

Possible Approaches to Solving this Case Study 10 minutes
TSA Case Study: Data and Report Requirements 10 minutes
TSA Case Study: Assignment Guide 10 minutes
Accessing Data - Hints 10 minutes
Exploring Data - Hints 10 minutes
Preparing Data - Hints 10 minutes
Analyzing Data - Hints 10 minutes
Exporting Reports - Hints 10 minutes
Check Your Code 10 minutes

1 assignment Total 20 minutes

Test your Case Study Code 20 minutes

1 discussion prompt Total 10 minutes

Your turn - How did you solve this case study? 10 minutes

This module is a review of the first four modules of the Doing More with SAS Programming course. Lectures demonstrate the concepts you learned about for preparing data, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.

What's included

6 videos4 readings16 assignments

6 videos Total 34 minutes

Understanding DATA Step Processing 7 minutes
Directing DATA Step Output 3 minutes
Summarizing Data 7 minutes
Using Numeric, Character, and Date Functions 8 minutes
Using the INTNX and INTCK Functions 3 minutes
Creating and Using Custom Formats 6 minutes

4 readings Total 40 minutes

SAS® Certification Prep Guide Review - Controlling DATA Step Processing 10 minutes
SAS® Certification Prep Guide Review - Summarizing Data 10 minutes
SAS® Certification Prep Guide Review - Manipulating Data with Functions 10 minutes
SAS® Certification Prep Guide Review - Creating & Using Custom Formats 10 minutes

16 assignments Total 210 minutes

Programming Question 4.01 10 minutes
Programming Question 4.02 10 minutes
Programming Question 4.03 10 minutes
Programming Question 4.04 10 minutes
Programming Question 4.05 10 minutes
Programming Question 4.06 10 minutes
Programming Question 4.07 10 minutes
Programming Question 4.08 10 minutes
Programming Question 4.09 10 minutes
Programming Question 4.10 10 minutes
Programming Question 4.11 10 minutes
Programming Question 4.12 10 minutes
Controlling DATA Step Processing Review Questions 20 minutes
Summarizing Data Review Questions 20 minutes
Manipulating Data with Functions Review Questions 20 minutes
Creating and Using Custom Formats Review Questions 30 minutes

This module is a review of the last three modules of the Doing More with SAS Programming course. Lectures demonstrate the concepts you learned about for preparing data, and readings from the SAS Certification Prep Guide reinforce those concepts. The review and programming questions assess your understanding of the material.