This course provides 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. Learn how to

• read, create, and combine SAS data sets
• read and create raw data files
• create variables using the assignment statement and using conditional processing
• manipulate data using SAS functions
• process data with DO loops and with arrays
• create different types of reports using the PRINT procedure, the REPORT procedure, the FREQ procedure, or the MEANS procedure
• create formats with the FORMAT procedure
• create HTML reports with ODS.

Who should attend 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

Before attending this course, you should

• be an experienced programmer with knowledge of the five exam content areas
• have taken

and or have equivalent experience.

This course addresses SAS/ACCESS, Base SAS software.

This course is appropriate for students who are using SAS 9 software.

Introduction

• specifics about the SAS Base Programming Exam
• spcifics about this review course
• 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 and Microsoft Excel files

• reading raw data files
• controlling when a record loads
• reading Microsoft Excel 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
• directing reports to external files with ODS

Additional Information

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

Practice Exam

• SAS fundamental concepts
• working with SAS data sets
• working with raw data and Microsoft Excel files
• creating variables
• manipulating data
• generating reports

CRB