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-paced e-learning includes:

• Annotatable course notes in PDF format.
• Virtual lab time to practice.

Learn how to

• 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

Data integration developers and data integration architects

Before attending this course, it is recommended that you 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.

Introduction

• Exploring the platform for SAS Business Analytics.
• Introduction to SAS Data Integration Studio.
• Using change management to create new metadata and update metadata.
• Introduction to the classroom environment and the course tasks.

Creating Metadata for Source Data

• Setting up the environment.
• Registering source data metadata.
• Registering SAS table metadata.
• Registering DBMS table metadata.
• Registering ODBC data source table metadata.
• Registering metadata for external files.

Creating Metadata for Target Data

• Registering target data metadata.
• Importing metadata.

Creating Metadata for Jobs

• Introduction to jobs and the job editor.
• Using the Join transformation.

Additional Features for Jobs

• Investigating column propagation, mapping, and updating.
• Establishing status handling.
• Importing SAS code into SAS Data Integration Studio.

Working with Transformations

• Using the Extract and Summary Statistics transformations.
• Using the Data Validation transformation.
• Exploring SQL transformations.
• Using the Transpose, Append, Rank, and List Data transformations.
• Using transformations for basic standardizations.