Monthly Subscription Starting at AED 99 + VAT

Preparing for the SAS Programming Certification Exam
  • Level Professional
  • Duration 16 hours
  • Course by SAS
  • Offered by

About

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.

Modules

Course Overview

    • 2 Videos
    • 3 Readings
Show info about module content

2 Videos

  • Welcome to the Course
  • About the Certification Exams

3 Readings

  • Certification Resources
  • Learner Prerequisites
  • Using Forums and Getting Help

Course Data Setup

    • 1 Readings
Show info about module content

1 Readings

  • Access SAS Software and Set Up Practice Files (Required)

Essentials Review

    • 3 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Essentials Review Questions
  • Programming Question 1.01
  • Programming Question 1.02

3 Videos

  • Program Structure and Syntax
  • Required SAS Column Attributes
  • Finding and Resolving Syntax Errors

1 Readings

  • SAS® Certification Prep Guide Review: Essentials

Accessing Data Review

    • 4 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Accessing Data Review Questions
  • Programming Question 1.03
  • Programming Question 1.04
  • Programming Question 1.05

4 Videos

  • Overview
  • Directly Accessing Structured Data
  • Importing Unstructured Data
  • Viewing Table Properties with PROC CONTENTS

1 Readings

  • SAS® Certification Prep Guide Review - Access

Exploring Data Review

    • 2 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Exploring Data Review Questions
  • Programming Question 1.06
  • Programming Question 1.07
  • Programming Question 1.08

2 Videos

  • Overview
  • Using SAS Procedures to Explore and Validate Data

1 Readings

  • SAS® Certification Prep Guide Review - Explore

Preparing Data Review

    • 3 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Preparing Data Review Questions
  • Programming Question 2.01
  • Programming Question 2.02
  • Programming Question 2.03

3 Videos

  • Overview
  • Using the DATA Step to Prepare Data
  • Using PROC SQL to Join Tables

1 Readings

  • SAS® Certification Prep Guide Review - Prepare

Analyzing Data Review

    • 2 Videos
    • 1 Readings
    • 6 Assignment
Show info about module content

6 Assignment

  • Analyzing Data Review Questions
  • Programming Question 2.04
  • Programming Question 2.05
  • Programming Question 2.06
  • Programming Question 2.07
  • Programming Question 2.08

2 Videos

  • Using PROC FREQ
  • Using PROC MEANS

1 Readings

  • SAS® Certification Prep Guide Review - Analyze

Exporting Data Review

    • 3 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Exporting Data Review Questions
  • Programming Question 2.09
  • Programming Question 2.10
  • Programming Question 2.11

3 Videos

  • Overview
  • Using PROC EXPORT
  • Using the Output Delivery System

1 Readings

  • SAS® Certification Prep Guide Review - Export

Controlling DATA Step Processing Review

    • 2 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Controlling DATA Step Processing Review Questions
  • Programming Question 4.01
  • Programming Question 4.02
  • Programming Question 4.03

2 Videos

  • Understanding DATA Step Processing
  • Directing DATA Step Output

1 Readings

  • SAS® Certification Prep Guide Review - Controlling DATA Step Processing

Summarizing Data Review

    • 1 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Summarizing Data Review Questions
  • Programming Question 4.04
  • Programming Question 4.05
  • Programming Question 4.06

1 Videos

  • Summarizing Data

1 Readings

  • SAS® Certification Prep Guide Review - Summarizing Data

Manipulating Data with Functions Review

    • 2 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Manipulating Data with Functions Review Questions
  • Programming Question 4.07
  • Programming Question 4.08
  • Programming Question 4.09

2 Videos

  • Using Numeric, Character, and Date Functions
  • Using the INTNX and INTCK Functions

1 Readings

  • SAS® Certification Prep Guide Review - Manipulating Data with Functions

Creating and Using Custom Formats Review

    • 1 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Creating and Using Custom Formats Review Questions
  • Programming Question 4.10
  • Programming Question 4.11
  • Programming Question 4.12

1 Videos

  • Creating and Using Custom Formats

1 Readings

  • SAS® Certification Prep Guide Review - Creating & Using Custom Formats

Combining Tables Review

    • 2 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Combining Tables Review Questions
  • Programming Question 5.01
  • Programming Question 5.02
  • Programming Question 5.03

2 Videos

  • Concatenating Tables
  • Merging Tables

1 Readings

  • SAS® Certification Prep Guide Review - Combining Tables

Processing Repetitive Code Review

    • 2 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Processing Repetitive Code Review Questions
  • Programming Question 5.04
  • Programming Question 5.05
  • Programming Question 5.06

2 Videos

  • Using Iterative and Conditional DO Loops
  • Using Nested DO Loops

1 Readings

  • SAS® Certification Prep Guide Review - Processing Repetitive Code

Restructuring Tables Review

    • 2 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Restructuring Tables Review Questions
  • Programming Question 5.07
  • Programming Question 5.08

2 Videos

  • Using the DATA Step to Restructure Tables
  • Using PROC TRANSPOSE to Restructure Tables

Auto Summary

Enhance your data science expertise with the "Preparing for the SAS Programming Certification Exam" course, an in-depth program tailored for professionals in the Data Science & AI domain. Crafted by Coursera, this course provides a robust review of SAS programming principles, reinforced through practical problem-solving exercises. Over an intensive 960-hour duration, learners will solidify their knowledge and readiness for the SAS Certified Specialist: Base Programming Using SAS 9.4 Exam. Ideal for those who have completed prior SAS programming courses, this course ensures a comprehensive understanding of key concepts, making it an invaluable resource for advancing your career. Flexible subscription options, including Starter and Professional tiers, cater to various learning needs and schedules. Whether you're looking to validate your skills or deepen your programming acumen, this course offers the tools and preparation needed for certification success.

Stacey Syphus
Instructor

Stacey Syphus