SAS Programming 2: Data Manipulation Techniques
Course Contents
Introduction
course logistics
course overview
SAS syntax review
navigating the SAS windowing environment (self-study)
Controlling Input and Output
outputting multiple observations
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
additional techniques for list input (self-study)
Data Transformations
manipulating character values
manipulating numeric values
converting variable type
Debugging Techniques
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
Combining SAS Data Sets
using data manipulation techniques with match-merging
Other SAS Languages
an overview of other languages
using the SQL procedure
the SAS macro language
Learning More
SAS resources
beyond this course