Focused business man working at laptop with SAS® Optimization software

SAS Base Programming for SAS 9

Exam Content Guide

Below we provide a list of the objectives that will be tested on the exam.
For more specific details about each objective download the complete exam content guide.

SAS® Visual Statistics cluster on desktop monitors

Accessing Data

  • Use FORMATTED and LIST input to read raw data files.
  • Use INFILE statement options to control processing when reading raw data files.
  • Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
  • Combine SAS data sets.
  • Access an Excel workbook.

Creating Data Structures

  • Create temporary and permanent SAS data sets.
  • Create and manipulate SAS date values.
  • Export data to create standard and comma-delimited raw data files.
  • Control which observations and variables in a SAS data set are processed and output.

Managing Data

  • Investigate SAS data libraries using base SAS utility procedures.
  • Sort observations in a SAS data set.
  • Conditionally execute SAS statements.
  • Use assignment statements in the DATA step.
  • Modify variable attributes using options and statements in the DATA step.
  • Accumulate sub-totals and totals using DATA step statements.
  • Use SAS functions to manipulate character data, numeric data, and SAS date values.
  • Use SAS functions to convert character data to numeric and vice versa.
  • Process data using DO LOOPS.
  • Process data using one-dimensional SAS arrays.
  • Validate and clean data.

Generating Reports

  • Generate list reports using the PRINT procedure.
  • Generate summary reports and frequency tables using base SAS procedures.
  • Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.
  • Generate reports using ODS statements.

Handling Errors

  • Identify and resolve programming logic errors.
  • Recognize and correct syntax errors.
  • Examine and resolve data errors.

Recommended Resources

Catalog

Download Training Catalog

A comprehensive guide to SAS training and certification options.

Directory

Certified Professional Directory

A public registry of SAS certified professionals.

Contact Us

Contact Us

Have a question? Need more information?
We're here to help.

Back to Top