This course introduces SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations.

The self-study version of this course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.

The e-learning includes:

• digital course notes for self-study
• Virtual Lab: 30 hours of hands-on software practice.

• register source data and target tables
• create jobs and explore the functionality of the job editor
• work with many of the various transformations.

Who should attend

Formats available	Duration
Classroom:	3.0 days
e-Learning:	21 hours/180 day license	System Requirements

Before attending this course, you should have experience with SAS programming basics. You can gain this experience by completing the SAS Programming 1: Essentials course.

This course addresses SAS Data Integration Studio, SAS Analytics Platform software.

• exploring the platform for SAS Business Analytics
• introduction to the data management applications
• introduction to the classroom environment and the course tasks

• introduction to change management
• establishing a change management environment (self-study)

• setting up the environment
• registering source data metadata

• registering target data metadata
• importing metadata

• introduction to jobs and the job editor
• using the Join transformation

• defining and loading the customer dimension table
• defining and loading the organization dimension table
• defining and loading the time dimension table

• importing SAS code
• propagation and mapping
• chaining jobs
• performance statistics
• metadata reports

• introduction
• using the Extract and Summary Statistics transformations
• exploring SQL transformations
• establishing status handling
• using the Data Validation transformation
• using the Transpose, Sort, Append, Rank, and List Data transformations
• basic standardizations