Explore

Practical SAS Programming and Certification Review

Approx. 21 hours to complete

Save Course

Go to Course

Course Summary

Prepare for the SAS Base Programming Certification exam with this review course. Learn how to write SAS programs, perform data manipulation and analysis, and more.

Key Learning Points

Learn from experienced SAS programmers and experts
Get hands-on practice with real-life datasets
Prepare for the SAS Base Programming Certification exam

Learning Outcomes

Ability to write SAS programs and perform data manipulation and analysis
Preparation for the SAS Base Programming Certification exam
Hands-on experience with real-life datasets

Prerequisites or good to have knowledge before taking this course

Basic understanding of programming concepts
Access to SAS software

Course Difficulty Level

Intermediate

Course Format

Self-paced online course
Video lectures
Hands-on practice exercises

Similar Courses

Advanced SAS Programming
Data Science Essentials

Related Education Paths

Notable People in This Field

SAS Institute Inc.
Kirk Paul Lafler

Related Books

Description

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.

Outline

Course Overview and Data Setup
Welcome to the Course
About the Certification Exam
How to Take This Course
Learner Prerequisites
Access SAS Software and Set Up Practice Files
Using Forums and Getting Help

Review of Getting Started with SAS Programming, Part 1
Program Structure and Syntax
Required SAS Column Attributes
Finding and Resolving Syntax Errors
Overview
Directly Accessing Structured Data
Importing Unstructured Data
Viewing Table Properties with PROC CONTENTS
Overview
Using SAS Procedures to Explore and Validate Data
SAS® Certification Prep Guide Review: Essentials
SAS® Certification Prep Guide Review - Access
SAS® Certification Prep Guide Review - Explore
Essentials Review Questions
Programming Question 1.01
Programming Question 1.02
Accessing Data Review Questions
Programming Question 1.03
Programming Question 1.04
Programming Question 1.05
Exploring Data Review Questions
Programming Question 1.06
Programming Question 1.07
Programming Question 1.08

Review of Getting Started with SAS Programming, Part 2
Overview
Using the DATA Step to Prepare Data
Using PROC SQL to Join Tables
Using PROC FREQ
Using PROC MEANS
Overview
Using PROC EXPORT
Using the Output Delivery System
SAS® Certification Prep Guide Review - Prepare
SAS® Certification Prep Guide Review - Analyze
SAS® Certification Prep Guide Review - Export
Preparing Data Review Questions
Programming Question 2.01
Programming Question 2.02
Programming Question 2.03
Analyzing Data Review Questions
Programming Question 2.04
Programming Question 2.05
Programming Question 2.06
Programming Question 2.07
Programming Question 2.08
Exporting Data Review Questions
Programming Question 2.09
Programming Question 2.10
Programming Question 2.11

Case Study/Programming Assignment: Analyze TSA Claims Data
Case Study Overview
Accessing Data - Solution
Exploring Data - Solution
Preparing Data - Solution
Analyzing Data - Solution
Exporting Reports - Solution
Possible Approaches to Solving this Case Study
TSA Case Study: Data and Report Requirements
TSA Case Study: Assignment Guide
Accessing Data - Hints
Exploring Data - Hints
Preparing Data - Hints
Analyzing Data - Hints
Exporting Reports - Hints
Check Your Code
Test your Case Study Code

Review of Doing More with SAS Programming, Part 1
Understanding DATA Step Processing
Directing DATA Step Output
Summarizing Data
Using Numeric, Character, and Date Functions
Using the INTNX and INTCK Functions
Creating and Using Custom Formats
SAS® Certification Prep Guide Review - Controlling DATA Step Processing
SAS® Certification Prep Guide Review - Summarizing Data
SAS® Certification Prep Guide Review - Manipulating Data with Functions
SAS® Certification Prep Guide Review - Creating & Using Custom Formats
Controlling DATA Step Processing Review Questions
Programming Question 4.01
Programming Question 4.02
Programming Question 4.03
Summarizing Data Review Questions
Programming Question 4.04
Programming Question 4.05
Programming Question 4.06
Manipulating Data with Functions Review Questions
Programming Question 4.07
Programming Question 4.08
Programming Question 4.09
Creating and Using Custom Formats Review Questions
Programming Question 4.10
Programming Question 4.11
Programming Question 4.12

Review of Doing More with SAS Programming, Part 2
Concatenating Tables
Merging Tables
Using Iterative and Conditional DO Loops
Using Nested DO Loops
Using the DATA Step to Restructure Tables
Using PROC TRANSPOSE to Restructure Tables
SAS® Certification Prep Guide Review - Combining Tables
SAS® Certification Prep Guide Review - Processing Repetitive Code
Combining Tables Review Questions
Programming Question 5.01
Programming Question 5.02
Programming Question 5.03
Processing Repetitive Code Review Questions
Programming Question 5.04
Programming Question 5.05
Programming Question 5.06
Restructuring Tables Review Questions
Programming Question 5.07
Programming Question 5.08

Case Study: Preparing World Tourism Data
Case Study Overview: Preparing World Tourism Data
View the Case Study Data
Create the Cleaned_Tourism Table, Part 1
Create the Cleaned_Tourism Table, Part 2
Create the Cleaned_Tourism Table, Part 3
Create the Final_Tourism Table
Create the NoCountryFound Table
Possible Approaches to Solving this Case Study
Tourism Case Study Requirements
Tourism Case Study - Assignment Guide
Create the Cleaned_Tourism Table, Part 1 - Hints
Create the Cleaned_Tourism Table, Part 2 - Hints
Create the Cleaned_Tourism Table, Part 3 - Hints
Create the Final_Tourism Table - Hints
Create the NoCountryFound Table - Hints
Test Your Case Study Output Table

Summary of User Reviews

Learn about SAS programming certification review course on Coursera. Users have rated this course highly for its comprehensive coverage of the SAS programming language. Many users appreciated the interactive sessions and practical exercises that helped them gain a deeper understanding of the concepts.

Key Aspect Users Liked About This Course

Comprehensive coverage of the SAS programming language

Pros from User Reviews

Interactive sessions and practical exercises
Clear and concise explanations
Great for beginners and experienced programmers
Flexible schedule and self-paced learning
Helpful and knowledgeable instructors

Cons from User Reviews

Some users found the course to be too slow-paced
No certification offered upon completion
Not enough hands-on coding exercises
Limited feedback on assignments
Some technical issues with the online platform

Recommended for you

Programming in SAS for beginners

Become an expert SAS analyst. Learn basics of SAS programming and advanced topics like SAS SQL Procedure and SAS Macros SAS Programming - from beginners to advanced users...

Save Course

The Simplest Guide to SAS Programming- SAS Base-SAS Advanced

Learn SAS programming for Data Analysis, Data Science, Data Visualization | SAS Certitication | SAS Base | SAS Advanced A guide to the two SAS certification exams: SAS Base and SAS Advanced...

Save Course

Ultimate Java Development and Certification Guide

Learn to program in java and become a Oracle Java certified developer Learn to program in Java and prepare for the Oracle Java certification exam with one single training program....

Save Course