SAS

The SAS Environment

Overview/Description:

There is a variety of SAS environments available to you as a SAS programmer and the one you use will depend on the underlying SAS system. Explore SAS and the various systems including the SAS Studio web interface.

Course Number:

it_dfsapo_01_enus

Introduction to Data Sets

Overview/Description:

Understanding the structure of SAS data sets and their uses is key to grasping the power of Base SAS. Explore the basics of data sets including data libraries SAS data and common functions.

Course Number:

it_dfsapo_02_enus

Creating & Reading Data Sets

Overview/Description:

Before SAS software can process data such as data saved in an Excel worksheet it must be in the form of a SAS data set. Discover how to create data sets from various sources.

Course Number:

it_dfsapo_03_enus

Data Errors & Validation

Overview/Description:

If data values do not correlate to SAS statements data errors will be detected during program execution. Explore data errors and the process of validating and cleaning data.

Course Number:

it_dfsapo_04_enus

Data Manipulation with SAS

Overview/Description:

Depending on the situation you may need to manipulate a SAS data set to generate the desired analytical report. Explore the manipulation of data sets including merging and combining sets.

Course Number:

it_dfsapo_05_enus

Creating Reports

Overview/Description:

Creating reports visualizations and charts from your data adds immediate impact and lets your audience glean information quickly and effectively. Discover how to create impactful reports in SAS.

Course Number:

it_dfsapo_06_enus

Creating Summary Reports & Charts

Overview/Description:

Make your reports more effective by adding visualizations and charts! Here we show you how to include graphics tables and charts when creating reports in SAS.

Course Number:

it_dfsapo_07_enus

Inputs & Outputs

Overview/Description:

Effectively getting data into and out of SAS is key for a SAS programmer and data will come in a variety of formats. Explore inputs and outputs from the SAS system.

Course Number:

it_dfsapo_08_enus

Data Manipulation & Debugging

Overview/Description:

An impressive feature of SAS is the assortment of functions that deal with character and numeric data. Explore various functions for data transformation and some methods for debugging your programs.

Course Number:

it_dfsapo_09_enus

Working with DO Loops & Proc SQL

Overview/Description:

Loops are the key to some of the more powerful features of SAS programming. Discover how to work with DO loops and Proc SQL.

Course Number:

it_dfsapo_10_enus

Working with Arrays & Restructuring and Merging Data Sets

Overview/Description:

Merging data is a fundamental function of data manipution. Combining loops and arrays simplifies processing of repetitive data with minimal coding. Explore arrays and techniques for restructuring and combining data including match merges.

Course Number:

it_dfsapo_11_enus