Practical SAS Programming and Certification Review

BY
SAS Institute via Coursera

Test your knowledge and skills in SAS programming by enrolling in "Practical SAS Programming and Certification Review" programme by Coursera.

Lavel

Intermediate

Mode

Online

Duration

7 Weeks

Fees

Free

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 20 hours which will be imparted via different modes of learning such as videos, audio, recordings, pre-recorded content, practice exercises and many others. 

The highlights

  • Offered by SAS
  • The course duration of approximately 20 hours 
  • E-certificates are awarded to participants 
  • Certification by Coursera
  • Intermediate level

Program offerings

  • Reading
  • Videos
  • Assessments
  • Assignments
  • Pre recorded content.

Course and certificate fees

Type of course

Free

The fees for the course Practical SAS Programming and Certification Review is -

HeadAmount in INR
Programme feesRs. 6,634

 

certificate availability

Yes

certificate providing authority

Coursera

certificate fees

₹6,634

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

Module 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

Module 2: 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

Module 3: 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

Module 4: 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

Module 5: 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

Module 6: 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

Module 7: 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

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.

Similar Courses

SAS Macro Language

SAS Macro Language

SAS Institute via Coursera

Online
Intermediate

Advanced SAS Programming Techniques

SAS Institute via Coursera

3 Weeks Online
Intermediate

Doing More with SAS Programming

SAS Institute via Coursera

8 Weeks Online
Intermediate

Courses of your Interest

Build AI Apps with ChatGPT Dall E and GPT 4

Build AI Apps with ChatGPT Dall E and GPT 4

Scrimba via Coursera

3 Weeks Online
Intermediate
Free

Artificial Intelligence Ethics in Action

LearnQuest via Coursera

Online
Intermediate

Artificial Creativity

Parsons School of Design, The New Sch... via Coursera

Online
Intermediate
Data Science on Microsoft Azure Using Python Progr...

Data Science on Microsoft Azure Using Python Progr...

CloudSwyft Global Systems, Inc via Futurelearn

15 Weeks Online
Intermediate

Angular7 for Intermediate Level

Great Learning

Online
Intermediate
Free

Hashing in Java

Great Learning

Online
Intermediate
Free

Binary Trees

Great Learning

Online
Intermediate
Free
Fullstack Enterprise Mongo Express Vue And Node

Fullstack Enterprise Mongo Express Vue And Node

Simpliv Learning

Online
Intermediate
$199 $999
Visual Design for Web Designers UI Designers and D...

Visual Design for Web Designers UI Designers and D...

Simpliv Learning

Online
Intermediate
$199 $999
Learning Algorithms in JavaScript from Scratch

Learning Algorithms in JavaScript from Scratch

Simpliv Learning

Online
Intermediate
$199 $999

More Courses by SAS Institute

Statistics with SAS

SAS Institute via Coursera

3 Weeks Online
Intermediate
Free

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books