Accessing Data

Use FORMATTED, LIST and COLUMN input
Use INFILE statement options to control processing
Use various components of an INPUT statement
Combine SAS data sets using the DATA step

Creating Data Structures
Create temporary and permanent SAS data sets
Create and manipulate SAS date values
Use DATA Step statements to export data
Control observations and variables

Managing Data
Investigate SAS data libraries using base SAS utility procedures
Sort observations in a SAS data set
Conditionally execute SAS statements
Use assignment statements in the DATA step
Modify variable attributes using options and statements in the DATA step
Accumulate sub-totals and totals using DATA step statements
Use SAS functions to manipulate character data, numeric data, and SAS date values
Use SAS functions to convert character data to numeric and vice versa
Process data using DO LOOPS
Process data using SAS arrays

Generating Reports
Generate list reports using the PRINT and REPORT procedures
Generate summary reports and frequency tables using base SAS procedures
Enhance reports through the use of labels, formats, titles, footnotes
Generate HTML reports using ODS statements

Handling Errors
Identify and resolve programming logic errors
Recognize and correct syntax errors
Examine and resolve data errors.



Accessing Data Using SQL

Generate detail reports by working with a single table or joining tables
Generate summary reports by working with a single table or joining tables
Construct subqueries within a PROC SQL step
Compare using the SQL procedure versus traditional SAS programming
Access Dictionary Tables using the SQL procedure
Demonstrate advanced PROC SQL skills

Macro Processing

Creating and using user-defined and automatic macro variables
Automate programs by defining and calling macros
Understand the use of macro functions
Recognize various system options

Advanced Programming Techniques

Demonstrate advanced data set processing techniques
Reduce the space required to store SAS data sets and numeric variables
Develop efficient programs by using advanced programming techniques
Use SAS System options and SAS data set options
Control the processing of variables and observations in the DATA step
Create sorted or indexed data
Use PROC DATASETS