Base SAS® Programmer Certification

Introduction

• overview of SAS Foundation
• course logistics
• course data files

SAS Programs

• introduction to SAS programs
• submitting a SAS program
• working with SAS program syntax

Accessing Data

• examining SAS data sets
• accessing SAS libraries

Producing Detail Reports

• submitting report data
• sorting and grouping report data
• enhancing reports

Formatting Data Values

• using SAS formats
• creating user-defined formats

Reading SAS Data Sets

• reading a SAS data set
• customizing a SAS data set

Reading Spreadsheet and Database Data

• reading spreadsheet data
• reading database data

Reading Raw Data Files

• introduction to reading raw data files
• reading standard delimited data
• reading nonstandard delimited data
• handling missing data

Manipulating Data

• using SAS functions
• conditional processing

Combining SAS Data Sets

• concatenating data sets
• merging data sets one-to-one
• merging data sets one-to-many
• merging data sets with nonmatches

Creating Summary Reports

• using the FREQ procedure
• using the MEANS and UNIVARIATE procedures
• using the Output Delivery System

Learning More

• SAS resources
• next steps

Introduction

• course logistics
• creating course data file

Controlling Input and Output

• writing observations explicitly
• writing to multiple SAS data sets
• selecting variables and observations

Summarizing Data

• creating an accumulating total variable
• accumulating totals for a group of data

Reading Raw Data Files

• reading raw data files with formatted input
• controlling when a record loads

Data Transformations

• manipulating character values
• manipulating numeric values
• converting variable type

Debugging Techniques

• using the PUTLOG statement

Processing Data Iteratively

• DO loop processing
• conditional DO loop processing
• SAS array processing
• using SAS arrays

Restructuring a Data Set

• rotating with the DATA step

Combining SAS Data Sets

• using data manipulation techniques with match-merging

Creating and Maintaining Permanent Formats

• creating permanent formats

Other SAS Languages

• an overview of other languages
• using the SQL procedure
• the SAS macro language

Learning More

• SAS resources
• next steps

The perfect starting point for those interested in a career as a SAS® professional

Successful candidates should have experience in programming and data management using SAS®9 and should be able to:

• Import and export raw data files.
• Manipulate and transform data.
• Combine SAS data sets.
• Create basic detail and summary reports using SAS procedures.
• Identify and correct data, syntax and programming logic errors.

Candidates who earn this credential will have earned a passing score on the SAS® Base Programming for SAS®9 exam.

Exam Content & Pricing

This exam is administered by SAS and Pearson VUE.

• 60-65 multiple-choice and short-answer questions.
  (Must achieve score of 70 percent correct to pass)
• 110 minutes to complete exam.
• Use exam ID A00-211; required when registering with Pearson VUE.
• This exam is based on SAS 9.4.

Candidates who earn this credential will have earned a passing score on the SAS® Base Programming for SAS®9 exam.

This exam is administered by SAS and Pearson VUE.

• 60-65 multiple-choice and short-answer questions.
  (Must achieve score of 70 percent correct to pass)
• 110 minutes to complete exam.
• Use exam ID A00-211; required when registering with Pearson VUE.
• This exam is based on SAS 9.4.

Epoch has three faclities approved for conducting exam.