SAS - Certified Base Programmer: Fast Track

Lehrplan

Introduction

• Overview of the Foundation of SAS

Getting Started with SAS

• Introduction to SAS programs

Working with SAS Syntax

• Master fundamental concepts and diagnosing and correcting syntax errors

Understanding SAS Data Sets

• Examining descriptor and data portions
• Accessing SAS data libraries

Reading SAS Data Sets

• How to read data
• How to use SAS data as input
• Subsetting observations and variables and adding permanent attributes

Reading Spreadsheet and Database Data

Reading Delimited Raw Data Files

• Using standard and non standard delimited data as input

Manipulating Data

• Creating variables conditionally
• Subsetting observations

Combining SAS Data Sets

• Introduction to combining data sets
• appending a data set (self-study)
• Linking data sets
• Merging data sets one-to-one, one-to-many and with nonmatches

Producing Summary Reports

• using the FREQ MEANS and TABULATE procedure

Enhancing Reports

• Using global statements
• Adding labels and 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 for a group data

Reading Raw Data Files

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

Data Transformations

• Manipulating character and numeric values
• Converting variable type

Debugging Techniques

• using the PUTLOG statement and DEBUG option

Iterative Data Processing

• Understanding how to use DO-loop SAS array processing

Data Set Restructuring

• Rotating with the DATA step and using the TRANSPOSE procedure

Creating Reports with the REPORT Procedure