SAS Institute Of Management Studies - Practical SAS Programming and Certification Review
- Offered byCoursera
Practical SAS Programming and Certification Review at Coursera Overview
Duration | 21 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Practical SAS Programming and Certification Review at Coursera Highlights
- Earn a shareable certificate upon completion.
- Flexible deadlines according to your schedule.
Practical SAS Programming and Certification Review at Coursera Course details
- 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.
Practical SAS Programming and Certification Review at Coursera Curriculum
Course Overview and Data Setup
Welcome to the Course
About the Certification Exam
How to Take This Course
Learner Prerequisites
Choosing and Setting Up SAS Software for this Course
Follow These Instructions to Set Up Data for This Course (REQUIRED)
Using Forums and Getting Help
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
Practical SAS Programming and Certification Review at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?