SAS Certification Review:
Base Programming for SAS 9

Audience

This course is designed for SAS users who are interested in a review course before taking the SAS Base Programming Exam for SAS 9, part of the SAS Global Certification Program.

Description

This course is a review of the majority of topics in the SAS Base Programming Exam for SAS®9. It addresses the five exam content areas: Accessing Data, Creating Data Structures, Managing Data, Generating Reports, and Handling Errors. This course not only ensures that you review most of the topics on the exam but also prepares you for the exam's question-and-answer format.

Prerequisites

Before attending this course, you should

• be an experienced programmer with knowledge of the five exam content areas
• have taken SAS Programming I: Essentials and SAS Programming II: Manipulating Data with the DATA Step or have equivalent experience.

SAS Modules Used

This course addresses Base SAS

Course Topics

Getting Started

• specifics about the SAS Base programming exam
• SAS fundamental concepts

Working with SAS Data Sets

• reading and creating data sets
• selecting observations
• sorting observations with the SORT procedure
• combining data sets

Working with Raw Data Files

• reading raw data files
• controlling when a record loads
• creating raw data files

Creating Variables

• creating variables with the assignment statement
• creating variables conditionally
• creating accumulator variables

Manipulating Data

• using functions to manipulate data
• converting character and numeric data
• processing data with DO loops
• processing data with arrays

Generating Reports

• creating detail reports with the PRINT procedure
• creating formats with the FORMAT procedure
• creating reports with the REPORT procedure
• creating frequency tables with the FREQ procedure
• creating summary reports with the MEANS procedure
• creating HTML reports with ODS

Additional Information

• specifics about the SAS Base programming exam
• additional preparation resources
• test-taking strategies

Practice Exam