This course is part of the SAS Programmer Professional Certificate

4.8
stars
97 ratings

Stacey Syphus

4,106 already enrolled

Offered By

SAS Programmer Professional CertificateSAS

About this Course

25,459 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.

Course 3 of 4 in the

SAS Programmer Professional Certificate

Intermediate Level

Approx. 16 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.

Course 3 of 4 in the

SAS Programmer Professional Certificate

Intermediate Level

Approx. 16 hours to complete

English

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

Try Coursera for Business

Instructor

Instructor rating

4.75/5 (33 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

Week

Week 1

1 hour to complete

Course Overview and Data Setup

1 hour to complete

2 videos (Total 6 min), 4 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 Syntax2m

Required SAS Column Attributes3m

Finding and Resolving Syntax Errors2m

Overview38s

Directly Accessing Structured Data3m

Importing Unstructured Data2m

Viewing Table Properties with PROC CONTENTS2m

Overview45s

Using SAS Procedures to Explore and Validate Data6m

3 readings

SAS® Certification Prep Guide Review: Essentials10m

SAS® Certification Prep Guide Review - Access10m

SAS® Certification Prep Guide Review - Explore10m

11 practice exercises

Essentials Review Questions20m

Programming Question 1.0110m

Programming Question 1.0210m

Accessing Data Review Questions20m

Programming Question 1.0310m

Programming Question 1.0410m

Programming Question 1.0510m

Exploring Data Review Questions20m

Programming Question 1.0610m

Programming Question 1.0710m

Programming Question 1.0810m

Week

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

Overview1m

Using the DATA Step to Prepare Data6m

Using PROC SQL to Join Tables3m

Using PROC FREQ3m

Using PROC MEANS6m

Overview48s

Using PROC EXPORT3m

Using the Output Delivery System5m

3 readings

SAS® Certification Prep Guide Review - Prepare10m

SAS® Certification Prep Guide Review - Analyze10m

SAS® Certification Prep Guide Review - Export10m

14 practice exercises

Preparing Data Review Questions20m

Programming Question 2.0110m

Programming Question 2.0210m

Programming Question 2.0310m

Analyzing Data Review Questions20m

Programming Question 2.0410m

Programming Question 2.0510m

Programming Question 2.0610m

Programming Question 2.0710m

Programming Question 2.0810m

Exporting Data Review Questions20m

Programming Question 2.0910m

Programming Question 2.1010m

Programming Question 2.1110m

Week

Week 3

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 Processing7m

Directing DATA Step Output2m

Summarizing Data7m

Using Numeric, Character, and Date Functions7m

Using the INTNX and INTCK Functions3m

Creating and Using Custom Formats6m

4 readings

SAS® Certification Prep Guide Review - Controlling DATA Step Processing10m

SAS® Certification Prep Guide Review - Summarizing Data10m

SAS® Certification Prep Guide Review - Manipulating Data with Functions10m

SAS® Certification Prep Guide Review - Creating & Using Custom Formats10m

16 practice exercises

Controlling DATA Step Processing Review Questions20m

Programming Question 4.0110m

Programming Question 4.0210m

Programming Question 4.0310m

Summarizing Data Review Questions20m

Programming Question 4.0410m

Programming Question 4.0510m

Programming Question 4.0610m

Manipulating Data with Functions Review Questions20m

Programming Question 4.0710m

Programming Question 4.0810m

Programming Question 4.0910m

Creating and Using Custom Formats Review Questions30m

Programming Question 4.1010m

Programming Question 4.1110m

Programming Question 4.1210m

Week

Week 4

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 Tables3m

Merging Tables4m

Using Iterative and Conditional DO Loops4m

Using Nested DO Loops4m

Using the DATA Step to Restructure Tables4m

Using PROC TRANSPOSE to Restructure Tables3m

2 readings

SAS® Certification Prep Guide Review - Combining Tables10m

SAS® Certification Prep Guide Review - Processing Repetitive Code10m

11 practice exercises

Combining Tables Review Questions20m

Programming Question 5.0110m

Programming Question 5.0210m

Programming Question 5.0310m

Processing Repetitive Code Review Questions30m

Programming Question 5.0410m

Programming Question 5.0510m

Programming Question 5.0610m

Restructuring Tables Review Questions30m

Programming Question 5.0710m

Programming Question 5.0810m

Reviews

4.8

19 reviews

5 stars
86.59%
4 stars
10.30%
3 stars
2.06%
1 star
1.03%

TOP REVIEWS FROM PREPARING FOR THE SAS PROGRAMMING CERTIFICATION EXAM

by JDJul 29, 2021

This is definitely a very well-organized programming course that will let you be fully prepared for the real-world problem. It would be better if more explanations can be provided to the quiz.

by SHAug 18, 2021

Well-designed content, meticulously articulated lectures, perfect practice questions... Learned a lot. Thankful.

by LPAug 27, 2022

THANK YOU VERY MUCH for this excellent course.

You have been an amazing teacher.

by YFJul 13, 2021

Stacey Syphus is a great professor. I enjoyed every minute of her course. Thank you

View all reviews

About the SAS Programmer Professional Certificate

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

Preparing for the SAS Programming Certification Exam

About this Course

Instructor

Stacey Syphus

Offered by

SAS

Syllabus - What you will learn from this course

Course Overview and Data Setup

Review of Getting Started with SAS Programming, Part 1

Review of Getting Started with SAS Programming, Part 2

Review of Doing More with SAS Programming, Part 1

Review of Doing More with SAS Programming, Part 2

Reviews

TOP REVIEWS FROM PREPARING FOR THE SAS PROGRAMMING CERTIFICATION EXAM

About the SAS Programmer Professional Certificate

Frequently Asked Questions

Start or advance your career

Popular Courses and Certifications

Popular collections and articles

Earn a degree or certificate online

Coursera

Community

More

Preparing for the SAS Programming Certification Exam

About this Course

Instructor

Stacey Syphus

Offered by

SAS

Syllabus - What you will learn from this course

Course Overview and Data Setup

Review of Getting Started with SAS Programming, Part 1

Review of Getting Started with SAS Programming, Part 2

Review of Doing More with SAS Programming, Part 1

Review of Doing More with SAS Programming, Part 2

Reviews

TOP REVIEWS FROM PREPARING FOR THE SAS PROGRAMMING CERTIFICATION EXAM

About the SAS Programmer Professional Certificate

Frequently Asked Questions

Coursera Footer

Start or advance your career

Popular Courses and Certifications

Popular collections and articles

Earn a degree or certificate online

Coursera

Community

More