Table of Contents
Introduction to SAS
SAS Program and Language
Reading DATA into SAS
Creating and Modifying Variables
Base SAS Procedures
Subsetting Data by Selecting Variables
Changing the Appearance of Data
Creating Variables Conditionally
The IF-THEN/ELSE Statement
Executing One of Several Statements
Modifying the IF-THEN/ELSE Statement with the Assignment Statement
Understanding How the DATA Step Works
DATA Step Processing Overview
Retaining the Value of Newly Created Variables
Conditional Processing in the DATA Step
Debugging Techniques
BY-Group Processing in the DATA Step
Introduction to BY-Group Processing
Applications Utilizing BY-Group Processing
Writing Loops in the DATA Step
Implicit and Explicit Loops
Utilizing Loops to Create Samples
Using Looping to Read a List of External Files
Array Processing
Introduction to Array Processing
Functions and Operators Related to Array Processing
Some Array Applications
Applications That Use Multi-Dimensional Arrays
Combining Data Sets
Vertically Combining Data Sets
Horizontally Combining Data Sets
Data Input and Output
Introduction to Reading and Writing Text Files
Reading Text Files
Creating Text Files
Data Step Functions
Introduction to Functions and CALL Routines
Date and Time Functions
Character Variables
Functions for Converting Variable Types
Useful SAS Procedures
Using the SORT Procedure to Eliminate Duplicate Observations
Using the COMPARE Procedure to Compare the Contents of Two Data Sets
Restructuring Data Sets Using the TRANSPOSE Procedure
Creating the User-Defined Format Using the FORMAT Procedure
Using the OPTIONS Procedure to Modify SAS System Options
References
Exercises appear at the end of each chapter.