SAS Programming Certification Fast Track

Target group

Course structure

Essentials

• The SAS programming process.
• Using SAS programming tools.
• Understanding SAS syntax.

Accessing Data

• Understanding SAS data.
• Accessing data through libraries.
• Importing data into SAS.

Exploring and Validating Data

• Exploring data.
• Filtering rows.
• Formatting columns.
• Sorting data and removing duplicates.

Preparing Data

• Reading and filtering data.
• Computing new columns.
• Conditional processing.

Analyzing and Reporting on Data

• Enhancing reports with titles, footnotes, and labels.
• Creating frequency reports.
• Creating summary statistics reports.

Exporting Results

• Exporting data.
• Exporting reports.

Using SQL in SAS

• Using Structured Query Language in SAS.
• Joining tables using SQL in SAS.

Restructuring Tables

• Restructuring data with the DATA step.
• Restructuring data with the TRANSPOSE procedure.

Controlling DATA Step Processing

• Setting up for this course.
• Understanding DATA step processing.
• Directing DATA step output.

Summarizing Data

• Creating an accumulating column.
• Processing data in groups.

Manipulating Data with Functions

• Understanding SAS functions and CALL routines.
• Using numeric and date functions.
• Using character functions.
• Using special functions to convert column type.

Creating Custom Formats

• Creating and using custom formats.
• Creating custom formats from tables.

Combining Tables

• Concatenating tables.
• Merging tables.
• Identifying matching and nonmatching rows.

Processing Repetitive Code

• Using iterative DO loops.
• Using conditional DO loops.