SAS Programming 1: Essentials
1. Introduction
- An overview of SAS foundation
- Course logistics
- Course data files
2. SAS Programs
- Introduction to SAS programs
- Submitting a SAS program
- Working with SAS program syntax
3. Accessing Data
- Examining SAS data sets
- Accessing SAS libraries
4. Producing Detail Reports
- Submitting report data
- Sorting and grouping report data
- Enhancing reports
5. Formatting Data Values
- Using SAS formats
- Creating user-defined formats
6. Reading SAS Data Sets
- Reading a SAS data set
- Customizing a SAS data set
7. Reading Spreadsheet and Database Data
- Reading spreadsheet data
- Reading database data
8. Reading Raw Data Files
- Introduction to reading raw data files
- Reading standard delimited data
- Reading nonstandard delimited data
- Handling missing data
9. Manipulating Data
- Using SAS functions
- Conditional processing
10. Combining SAS Data Sets
- Concatenating data sets
- Merging data sets one-to-one
- Merging data sets one-to-many
- Merging data sets with nonmatches
11. Creating Summary Reports
- Using the FREQ procedure
- Using the MEANS and UNIVARIATE procedures
- Using the Output Delivery System
12. Learning More
- SAS resources
- Next steps
SAS Programming 2: Data Manipulation Techniques
1. Introduction
- An overview of SAS foundation
- Course logistics
- Course data files
2. Controlling Input and Output
- Writing observations explicitly
- Writing to multiple SAS data sets
- Selecting variables and observations
3. Summarizing Data
- Creating an accumulating total variable
- Accumulating totals for a group of data
4.Reading Raw Data Files
- Reading raw data files with formatted input
- Controlling when a record loads
5. Data Transformations
- Manipulating character values
- Manipulating numeric values
- Converting variable type
6. Debugging Techniques
- Using the PUTLOG statement
7. Processing Data Iteratively
- DO loop processing
- Conditional DO loop processing
- SAS array processing
- Using SAS arrays
8. Restructuring a Data Set
- Rotating with the DATA step
9. Combining SAS Data Sets
- Using data manipulation techniques with match-merging
10. Creating and Maintaining Permanent Formats
- Creating permanent formats
11. Other SAS Languages
- An overview of other languages
- Using the SQL procedure
- The SAS macro language
12. Learning More
- SAS resources
- Next steps