Course Description

Duration

5 Days

Description

This course teaches the fundamentals of SAS - data access, manipulation, analysis and reporting - and has been designed to prepare students for the SAS Certified Base Programmer exam.

Prerequisites

Before attending this course, you should have: An understanding of your operating system. Some experience of programming in other languages or packages would be advantageous.

SAS Modules Used

Base SAS

Course Topics

Getting Started with SAS:

• Introduction to SAS programs
• Mastering fundamental programming concepts.

Accessing Existing SAS Data Sets:

• Introduction to SAS data sets
• Accessing existing SAS data sets.

Reading Raw Data Files:

• Introduction
• Reading fixed-width files
• DATA step processing
• Reading delimited Raw data files
• Testing a DATA step (Self-study)

Reading SAS Data Sets and Creating New Variables:

• Reading SAS data sets
• Creating new variables

Controlling the Output of Variables and Observations:

• Controlling the output of variables
• Controlling the output of observations
• Conditional Processing Using IF.THEN.ELSE Logic
• Sorting SAS Data Sets

Combining SAS Data Sets:

• Concatenating SAS Data Sets
• Interleaving SAS Data Sets
• Match-Merging SAS Data Sets
• Eliminating Non-Matches and Identifying Data Set Contributors

Recoding Data Values:

• Applying Formats
• Creating User-Defined Formats
• Creating Frequency Reports
• Generating Summary Statistics

Exporting Data using the Output Delivery System (ODS):

• Overview of the Output Delivery System
• Generating HTML Output

Titles, Footnotes and SAS System Options:

Generating Reports using the Print Procedure:

• Overview of the PRINT Procedure
• Proc PRINT Additional Features (Self-study)

Controlling Input and Output:

• Outputting Multiple Observations
• Writing to Multiple SAS Data Sets
• Selecting Variables and Observations
• Writing to an External File

Summarising Data:

• Creating an Accumulating Total Variable
• Accumulating Totals for a Group of Data

Reading and Writing Different Types of Data:

• Controlling When a Record Loads
• Reading Hierarchical Raw Data Files
• Proc REPORT:
• Proc REPORT Overview
• Additional Features of Proc REPORT (Self-study)

Processing Data Iteratively:

• DO Loop Processing
• SAS Array Processing
• Using SAS Arrays

Data Transformations:

• Manipulating Character Values
• Manipulating Numeric Values
• Manipulating Numeric Values Based on Dates
• Converting Variable Types

Debugging Techniques:

• Using the PUT Statement
• Using the DEBUG Option

Objectives

After attending this course you will be able to:

• Understand file structure and write system commands to create and access files.
• Understand programming logic concepts (IF/THEN logic).
• Understand the compilation and execution process of the DATA step.
• Use different kinds of input to create SAS data sets from external files.
• Use SAS software to access SAS data libraries.
• Create and use SAS date values.
• Read, concatenate, merge, match-merge and interleave SAS data sets.
• Use the data set options DROP=, KEEP= and RENAME=.
• Create multiple output data sets.
• Use array processing and DO loops to process data iteratively.
• Use SAS functions to perform data manipulation and transformations.