4.9
stars
354 ratings

Stacey Syphus

14,252 already enrolled

Offered By

Practical SAS Programming and Certification Review

SAS

About this Course

3,658 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Intermediate Level

Approx. 20 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Intermediate Level

Approx. 20 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.86/5 (48 Ratings)

Stacey Syphus

Offered by

SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Content Rating93%(1,049 ratings)

Week1

Week 1

1 hour to complete

Course Overview and Data Setup

1 hour to complete

3 videos (Total 9 min), 3 readings

3 hours to complete

Review of Getting Started with SAS Programming, Part 1

3 hours to complete

9 videos (Total 26 min), 3 readings, 11 quizzes

9 videos

Program Structure and Syntax2mRequired SAS Column Attributes3mFinding and Resolving Syntax Errors2mOverview38sDirectly Accessing Structured Data3mImporting Unstructured Data2mViewing Table Properties with PROC CONTENTS2mOverview45sUsing SAS Procedures to Explore and Validate Data6m

3 readings

SAS® Certification Prep Guide Review: Essentials10mSAS® Certification Prep Guide Review - Access10mSAS® Certification Prep Guide Review - Explore10m

11 practice exercises

Essentials Review Questions20mProgramming Question 1.0110mProgramming Question 1.0210mAccessing Data Review Questions20mProgramming Question 1.0310mProgramming Question 1.0410mProgramming Question 1.0510mExploring Data Review Questions20mProgramming Question 1.0610mProgramming Question 1.0710mProgramming Question 1.0810m

Week2

Week 2

4 hours to complete

Review of Getting Started with SAS Programming, Part 2

4 hours to complete

8 videos (Total 31 min), 3 readings, 14 quizzes

8 videos

Overview1mUsing the DATA Step to Prepare Data6mUsing PROC SQL to Join Tables3mUsing PROC FREQ3mUsing PROC MEANS6mOverview48sUsing PROC EXPORT3mUsing the Output Delivery System5m

3 readings

SAS® Certification Prep Guide Review - Prepare10mSAS® Certification Prep Guide Review - Analyze10mSAS® Certification Prep Guide Review - Export10m

14 practice exercises

Preparing Data Review Questions20mProgramming Question 2.0110mProgramming Question 2.0210mProgramming Question 2.0310mAnalyzing Data Review Questions20mProgramming Question 2.0410mProgramming Question 2.0510mProgramming Question 2.0610mProgramming Question 2.0710mProgramming Question 2.0810mExporting Data Review Questions20mProgramming Question 2.0910mProgramming Question 2.1010mProgramming Question 2.1110m

Week3

Week 3

3 hours to complete

Case Study/Programming Assignment: Analyze TSA Claims Data

3 hours to complete

6 videos (Total 35 min), 9 readings, 1 quiz

6 videos

Case Study Overview5mAccessing Data - Solution3mExploring Data - Solution5mPreparing Data - Solution7mAnalyzing Data - Solution9mExporting Reports - Solution3m

9 readings

Possible Approaches to Solving this Case Study10mTSA Case Study: Data and Report Requirements10mTSA Case Study: Assignment Guide10mAccessing Data - Hints10mExploring Data - Hints10mPreparing Data - Hints10mAnalyzing Data - Hints10mExporting Reports - Hints10mCheck Your Code10m

1 practice exercise

Test your Case Study Code20m

Week4

Week 4

5 hours to complete

Review of Doing More with SAS Programming, Part 1

5 hours to complete

6 videos (Total 34 min), 4 readings, 16 quizzes

6 videos

Understanding DATA Step Processing7mDirecting DATA Step Output2mSummarizing Data7mUsing Numeric, Character, and Date Functions7mUsing the INTNX and INTCK Functions3mCreating and Using Custom Formats6m

4 readings

SAS® Certification Prep Guide Review - Controlling DATA Step Processing10mSAS® Certification Prep Guide Review - Summarizing Data10mSAS® Certification Prep Guide Review - Manipulating Data with Functions10mSAS® Certification Prep Guide Review - Creating & Using Custom Formats10m

16 practice exercises

Controlling DATA Step Processing Review Questions20mProgramming Question 4.0110mProgramming Question 4.0210mProgramming Question 4.0310mSummarizing Data Review Questions20mProgramming Question 4.0410mProgramming Question 4.0510mProgramming Question 4.0610mManipulating Data with Functions Review Questions20mProgramming Question 4.0710mProgramming Question 4.0810mProgramming Question 4.0910mCreating and Using Custom Formats Review Questions30mProgramming Question 4.1010mProgramming Question 4.1110mProgramming Question 4.1210m

Week5

Week 5

3 hours to complete

Review of Doing More with SAS Programming, Part 2

3 hours to complete

6 videos (Total 26 min), 2 readings, 11 quizzes

6 videos

Concatenating Tables3mMerging Tables4mUsing Iterative and Conditional DO Loops4mUsing Nested DO Loops4mUsing the DATA Step to Restructure Tables4mUsing PROC TRANSPOSE to Restructure Tables3m

2 readings

SAS® Certification Prep Guide Review - Combining Tables10mSAS® Certification Prep Guide Review - Processing Repetitive Code10m

11 practice exercises

Combining Tables Review Questions20mProgramming Question 5.0110mProgramming Question 5.0210mProgramming Question 5.0310mProcessing Repetitive Code Review Questions30mProgramming Question 5.0410mProgramming Question 5.0510mProgramming Question 5.0610mRestructuring Tables Review Questions30mProgramming Question 5.0710mProgramming Question 5.0810m

Week6

Week 6

2 hours to complete

Case Study: Preparing World Tourism Data

2 hours to complete

7 videos (Total 38 min), 8 readings, 1 quiz

7 videos

Case Study Overview: Preparing World Tourism Data6mView the Case Study Data43sCreate the Cleaned_Tourism Table, Part 16mCreate the Cleaned_Tourism Table, Part 26mCreate the Cleaned_Tourism Table, Part 39mCreate the Final_Tourism Table5mCreate the NoCountryFound Table3m

8 readings

Possible Approaches to Solving this Case Study10mTourism Case Study Requirements10mTourism Case Study - Assignment Guide10mCreate the Cleaned_Tourism Table, Part 1 - Hints10mCreate the Cleaned_Tourism Table, Part 2 - Hints10mCreate the Cleaned_Tourism Table, Part 3 - Hints10mCreate the Final_Tourism Table - Hints10mCreate the NoCountryFound Table - Hints10m

1 practice exercise

Test Your Case Study Output Table15m

Reviews

4.9

63 reviews

5 stars
88.70%
4 stars
9.60%
3 stars
1.12%
2 stars
0.56%

TOP REVIEWS FROM PRACTICAL SAS PROGRAMMING AND CERTIFICATION REVIEW

by JSNov 9, 2020

This course shows me what I need to go over for the certification exam. I like the explanations for the quiz answers. Also, both instructors have pleasant voices.

by LJSep 17, 2020

An excellent course taught by an excellent professor from an excellent university. I highly recommend it!

by ARJun 16, 2019

This is by far the best course I have come across in coursera. The structure of the program is excellent. The exercises are very good

by EGSep 25, 2019

Thanks to this course (and the entire specialization) I feel very confident in my ability to use SAS.

View all reviews

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this 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. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Practical SAS Programming and Certification Review

Practical SAS Programming and Certification Review

About this Course