Buy Now AED 344.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Practical SAS Programming and Certification Review
  • Level Professional
  • المدة 21 ساعات hours
  • الطبع بواسطة SAS
  • Offered by

عن

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.

الوحدات

Course Overview

    • 3 Videos
    • 1 Readings
Show info about module content

3 Videos

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

1 Readings

  • Learner Prerequisites

Course Logistics and Data Setup

    • 2 Readings
Show info about module content

2 Readings

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

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

Case Study Introduction and Requirements

    • 1 Videos
    • 3 Readings
Show info about module content

1 Videos

  • Case Study Overview

3 Readings

  • Possible Approaches to Solving this Case Study
  • TSA Case Study: Data and Report Requirements
  • TSA Case Study: Assignment Guide

Case Study Hints

    • 5 Readings
Show info about module content

5 Readings

  • Accessing Data - Hints
  • Exploring Data - Hints
  • Preparing Data - Hints
  • Analyzing Data - Hints
  • Exporting Reports - Hints

Case Study Solutions

    • 5 Videos
    • 1 Readings
Show info about module content

5 Videos

  • Accessing Data - Solution
  • Exploring Data - Solution
  • Preparing Data - Solution
  • Analyzing Data - Solution
  • Exporting Reports - Solution

1 Readings

  • Check Your Code

Test Your Solution

    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your Case Study Code

1 Discussions

  • Your turn - How did you solve this case study?

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

Case Study Introduction and Requirements

    • 2 Videos
    • 3 Readings
Show info about module content

2 Videos

  • Case Study Overview: Preparing World Tourism Data
  • View the Case Study Data

3 Readings

  • Possible Approaches to Solving this Case Study
  • Tourism Case Study Requirements
  • Tourism Case Study - Assignment Guide

Case Study Hints

    • 5 Readings
Show info about module content

5 Readings

  • 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

Case Study Solutions

    • 5 Videos
Show info about module content

5 Videos

  • 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

Test Your Solution

    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Test Your Case Study Output Table

1 Discussions

  • Your Turn - What would you do next to this data?

Auto Summary

Enhance your data science expertise with "Practical SAS Programming and Certification Review" on Coursera. This professional-level course focuses on applying SAS programming skills to solve real-world problems and prepares you for the SAS Certified Specialist: Base Programming Using SAS 9.4 Exam. Ideal for aspiring data scientists, it spans 1260 minutes and is available with a Starter subscription. Join now to elevate your SAS proficiency and advance your career.

Stacey Syphus
Instructor

Stacey Syphus