Practical SAS Programming and Certification Review by SAS Institute via Coursera: Fee, Duration, How to Apply

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study	Mode of Delivery Video and Text Based

Course overview

The "Practical SAS Programming and Certification Review" programme by Coursera is offered by SAS. The programme is ideally pursued after the candidates have completed two SAS programming courses prior to enrolling in this programme. By pursuing the previous programmes, the candidates will get an edge and insight into how to solve problems in a real-world or a present business environment. The candidates are imparted skills and abilities to help them pursue SAS Certified Specialist Base Programming Using SAS 9.4 exam. Candidates during their programme tenure will get a comprehensive understanding and knowledge around different areas namely, SAS Programming, TSA Claims Data and many others. The course is spanned across a time duration of 21 hours which will be imparted via different modes of learning such as videos, audio, recordings, pre-recorded content, practice exercises and many others.

Course and certificate fees

Type of course

Free

The fee for purchasing the "SAS Programmer Professional Certificate" programme is Rs 6,486 (after 7 days of a free trial).

Course	Amount in Rupees
Practical SAS Programming and Certification Review	Rs 6,587

certificate availability

Yes

certificate providing authority

Coursera

certificate fees

₹6,587

Who it is for

Data scientist Business analyst Big data analytics engineer

Eligibility criteria

Certification Qualifying Details

Candidates will get a certification of completion for Practical SAS Programming and Certification Review" only after completing the programme properly. In addition to this, the candidates also need to make fee payment for getting the certification of the programme.

What you will learn

Programming skills

After completing this "Practical SAS Programming and Certification Review", which is the third part of the "SAS Programmer Professional Certificate" training series, the candidates will learn to:

Candidates will be able to master a series of skills and tools around SAS software, forums, PROC Export, PROC FREQ, PROC SQL, Syntax Errors, Export Data, INTNX functions, INTCK and others.
Implementation of learnings in solving real-life business complexities
Candidates will learn the skills of transforming and manipulating data sets, formulating basic summary and detailed reports by making use of SAS procedures, programming errors and Syntax.

The syllabus

Week 1: Course Overview and Data Setup

Videos

Welcome to the course
About the Certification Exam
How to Take This Course

Readings

Learner Prerequisites
Access SAS Software and Set Up Practice Files
Using Forums and Getting Help

Week 1: Review of Getting Started with SAS Programming, Part 1

Videos

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

Readings

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

Practice Exercises

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

Week 2: Review of Getting Started with SAS Programming, Part 2

Videos

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

Readings

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

Practice Exercises

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

Week 3: Case Study/Programming Assignment: Analyze TSA Claims Data

Videos

Case Study Overview
Accessing Data - Solution
Exploring Data - Solution
Preparing Data - Solution
Analyzing Data - Solution
Exporting Reports - Solution

Readings

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

Practice Exercises

Test your Case Study Code

Week 4: Review of Doing More with SAS Programming, Part 1

Videos

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

Readings

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

Practice Exercises

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 Question
Programming Question 4.10
Programming Question 4.11
Programming Question 4.12

Week 5: Review of Doing More with SAS Programming, Part 2

Videos

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

Readings

SAS® Certification Prep Guide Review - Combining Tables
SAS® Certification Prep Guide Review - Processing Repetitive Code

Practice Exercises

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

Week 6: Case Study: Preparing World Tourism Data

Videos

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

Readings

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

Practice Exercises

Test Your Case Study Output Table

Admission details

The process of admission for the "SAS Certification Programme" is very simple. Those who wish to earn a certificate and get access to graded assessments are asked to keep their billing details handy. Follow the following steps:

Step 1: Visit the course page. https://www.coursera.org/learn/sas-programming-certification-review

Step 2: Register/ Login into your Coursera account

Step 3: Search for "SAS Programming and Certification Review by SAS Academy".

Step 4: Select the 'enrol now' button on the top left corner of the page.

Step 5: Choose either audit the course for free or purchase the course and earn a certificate.

Step 6: If you have chosen to audit the course for free, you are already enrolled in the course and can start learning!

Step 7: If you have chosen to purchase the course, make the payment and access the course as soon as the payment gets successful.

Scholarship Details

Coursera gives financial aid to those learners who are economically weak and cannot afford their fees. Aspirants need to select the option of financial aid, on the right side of the enrol button and fill the application form that is prompted. Within the next fifteen days, the aspirants will be notified whether or not their application is sanctioned.

How it helps

The Practical SAS Programming and Certification Review" course include a variety of practical, real-time exercises and projects, which are bound to provide an amazing professional experience to the students. The case studies will give the students an opportunity to apply the skills they have learned on real-world databases. This course is perfectly suited for those who want to take up the SAS base examination as it provides students with a thorough review of the past chapters and practical projects to master SAS programming. The programme will give a competitive edge to the candidates in comparison to other professionals present in the corporate world. In addition to this, candidates will also be able to attract better salary packages as well as better job profiles from recruiters.

Instructors

Ms Stacey Syphus
Senior Manager
SAS Institute

M.S

FAQs

Can I appear for the exam without attending this course?

The choice is totally up to you. This course provides revision and expert advice for those who are wanting to appear for the exam. However, it is not a compulsory course. Candidates can appear for the exam without taking this course also.

How are the lessons given?

All the lessons are provided through videos and readings from the top faculties of prime universities and companies.

What is the motto of this course?

This course aims to provide the students appearing for a SAS base exam last-minute guidance and a revision of all the course material in order to gear them up for the exam.

I wish to purchase the course but I'm unable to afford the fees for it. What should I do?

You can fill the application form for financial aid, listing in all your details. The concerned authorities will contact you within 15 days.

Who are the instructors for this course?

Stacy Syphus and Peter Styliadis, who have a long experience in teaching, are the instructors for this training programme.

Who is this course for?

There is no specified category set for the eligibility to apply for this course. Anyone who wants to learn SAS programming/ appear for SAS Base exam can apply for this course.

Will the software we provided?

No, the software is not provided with the course material

Is this course really helpful?

This course provides helpful materials for the preparation of SAS base examination to all its learners. Many students have reported an improvement in their performances after taking up this course.

What will the free trial comprise of?

The seven days free trial of this course comprises of all the course materials and graded assignments. It is basically a demo of what you will get you to purchase the course.

What are the timelines for this course?

This course has flexible timelines and deadlines, which means students can access the course and learn whenever it suits them. This course takes 20 hours on average to finish.