|
Introduction
- course logistics
- overview of Foundation SAS
- SAS syntax review
- navigating the SAS windowing environment (self-study)
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
- accessing relational databases (self-study)
Reading SAS Data Sets
- introduction to reading data
- using SAS data as input
- subsetting observations and variables
- adding permanent attributes
Reading Excel Worksheets
- using Excel data as input
- doing more with Excel worksheets (self-study)
Reading Delimited Raw Data Files
- using standard delimited data as input
- using nonstandard delimited data as input
Validating and Cleaning Data
- introduction to validating and cleaning data
- examining data errors when reading raw data files
- validating data with the PRINT and FREQ procedures
- validating data with the MEANS and UNIVARIATE procedures
- cleaning invalid data
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
Enhancing Reports
- using global statements
- adding labels and formats
- creating user-defined formats
- subsetting and grouping observations
- directing output to external files
Producing Summary Reports
- using the FREQ procedure
- using the MEANS procedure
- using the TABULATE procedure (self-study)
Introduction to Graphics Using SAS/GRAPH (Self-Study)
- creating bar and pie charts
- creating plots
- enhancing output
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
|
