Home / Advanced


Section #: 01 – Accessing Data
1- Use FORMATTED and LIST input to read raw data files.
2- Use INFILE statement options to control processing when reading raw data files.
3- Use various components of an INPUT statement to process raw data files
4- Combine SAS data sets.
5- Access an Excel workbook.
6- Creating Data Structures
7- Create temporary and permanent SAS data sets.
8- Create and manipulate SAS date values.
9- Export data to create standard and comma-delimited raw data files.
10- Control which observations and variables in a SAS data set are processed and output.

Section #: 02 – Managing Data

1- Investigate SAS data libraries using base SAS utility procedures.
2- Sort observations in a SAS data set.
3- Conditionally execute SAS statements.
4- Use assignment statements in the DATA step.
5- Modify variable attributes using options and statements in the DATA step.
6- Accumulate sub-totals and totals using DATA step statements.
7- Use SAS functions to manipulate character data, numeric data, and SAS date values.
8- Use SAS functions to convert character data to numeric and vice versa.
9- Process data using DO LOOPS.
10- Process data using one-dimensional SAS arrays.
11- Validate and clean data

Section #: 03 – Generating Reports

1- Static Techniques and the Test Process
2- Generate list reports using the PRINT procedure.
3- Generate summary reports and frequency tables using base SAS procedures.
4- Enhance reports through use of formats, titles, footnotes & SAS System reporting.
5- Generate reports using ODS statements.
6- Handling Errors
7- Identify and resolve programming logic errors.
8- Recognize and correct syntax errors.
9- Examine and resolve data errors.