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
• sort observations with the SORT procedure
• read raw data and Microsoft Excel files
• create variables using assignment, conditional, and sum statements
• manipulate data using SAS functions
• process data with DO loops and arrays
• create reports using the PRINT procedure, the FREQ procedure, and the MEANS procedure
• create formats with the FORMAT procedure
• create external files 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

Formats available	Duration
Classroom:	2.0 days
e-Learning:	14 hours/180 day license

Before attending this course, you should

• be an experienced programmer with knowledge of the five exam content areas
• have taken SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques or have equivalent experience.

This course addresses SAS/ACCESS, Base SAS software.

This course is appropriate for students who are using SAS 9 software. In addition to Base SAS software, this course addresses SAS/ACCESS Interface to PC Files 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 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