SAS - Certified Base Programmer: Fast Track

Curriculum

Introduction

• Information about the SAS®9 Base Programming Exam
• Course logistics
• Overview of Foundation SAS

Getting Started with SAS

• Introduction to SAS programs
• Submitting a SAS program

Working with SAS Syntax

• Mastering fundamental concepts
• Diagnosing and correcting syntax errors

Getting Familiar with SAS Data Sets

• Examining descriptor and data portions
• Accessing SAS data libraries

Reading SAS Data Sets

• Introduction to reading data
• Using SAS data as input
• Subsetting observations and variables
• Adding permanent attributes

Reading Spreadsheet and Database Data

• Reading spreadsheet data
• Reading database data

Reading Delimited Raw Data Files

• Using standard delimited data as input
• Using nonstandard delimited data as input

Manipulating Data

• Creating variables
• Creating variables conditionally
• Subsetting observations

Combining SAS Data Sets

• Introduction to combining data sets
• Appending a data set (self-study)
• Concatenating data sets
• Merging data sets one-to-one
• Merging data sets one-to-many
• Merging data sets with nonmatches

Producing Summary Reports

• Using the FREQ procedure
• Using the MEANS procedure
• Using the TABULATE procedure (self-study)

Enhancing Reports

• Using global statements
• Adding labels and formats
• Creating user-defined formats
• Subsetting and grouping observations
• Directing output to external files

Controlling Input and Output

• Outputting multiple observations
• Writing to multiple SAS data sets
• Selecting variables and observations

Summarising 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
• Additional techniques for list input (self-study)
• Creating raw data files (self-study)

Data Transformations

• Manipulating character values
• Manipulating numeric values
• Converting variable type

Debugging Techniques (optional)

• Using the PUTLOG statement
• Using the DEBUG option

Processing Data Iteratively

• DO-loop processing
• SAS array processing
• Using SAS arrays

Restructuring a Data Set

• Rotating with the DATA step
• Using the TRANSPOSE procedure

Creating Reports with the REPORT Procedure (Self-study)

• Creating reports with the REPORT procedure

Learning More

• SAS resources
• Beyond this course