SAS Certification Review: Base Programming for SAS 9

Classroom duration: 2.0 days Live Web duration: 4 half-day sessions CEU: 1.2

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 date 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

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.

Course Contents

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

Software Addressed

This course addresses the following software product(s): Base SAS.

Classroom Course Materials

Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Live Web Course Materials

Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials, including the exercise files. Students need to download and print the course materials prior to class.

System Requirements

For Live Web, you must review and follow the general system requirements. Note that although most SAS Live Web courses require that you be able to connect to a virtual lab session in order to complete the exercises, this class uses pen and paper exercises, so no virtual lab connection is required.

U.S. Schedule

17NOV2008 Cary, NC
18MAY2009 Cary, NC

20JAN2009 New York, NY

06APR2009 Atlanta, GA

Check for additional and updated schedule information online at support.sas.com/courses/crb.html.

Registration

To register for this course in the US, call 800-333-7660 or visit support.sas.com/training. This course is also available for on-site training, or you can create a custom course by combining material from several courses. For more details, contact SAS Education in Cary, NC at 919-531-7321 or send e-mail to training@sas.com.