This course introduces and expands the knowledge of SAS Enterprise Guide and SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations. This course also covers information on working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.

Learn how to

• Using tasks, queries and report in SAS Enterprise Guide
• register source data and target tables
• create jobs and explore the functionality of the job editor
• work with many of the various transformations
• work with slowly changing dimensions
• work with Loop transformations
• create new transformations
• examine impact analysis
• examine exporting and importing of metadata
• establish checkpoints in job flow
• deploy jobs for scheduling
• deploy jobs as SAS Stored Processes.

Who should attend

Data integration developers and data integration architects

Formats available	Duration
Classroom:	5.00 days

No SAS knowledge is required. Before attending this course, you should be familiar with Windows and other software, such as Microsoft Office or spreadsheet programs.

Getting Started

• introducing SAS Enterprise Guide
• course scenarios

Working with Data in a Project

• understanding SAS data structure
• accessing SAS and DBMS data
• importing data files

Getting Started with Tasks

• introduction to tasks and wizards
• creating a frequency report
• generating HTML, PDF, and RTF output
• creating a listing report
• filtering data in a task
• creating a graph

Creating Simple Queries

• introduction to querying data
• filtering and sorting data
• creating new columns with an expression
• grouping and summarizing data in a query
• joining tables

Creating Summarized Output

• generating summary statistics
• creating a summary report with the Summary Tables task
• generating summary statistics
• creating a summary report with the Summary Tables task

Using Prompts in Tasks and Queries

• prompting in projects
• creating and using prompts in tasks
• creating and using prompts in queries

Customizing and Organizing Project Results

Customizing and Organizing Project Results
• combining results
• updating results

Writing and Submitting SAS Programs

• writing and sumitting SAS programs

Introduction in DI Studio

• exploring the platform for SAS Business Analytics
• introducing the data integration applications
• introducing change management
• exploring the platform for SAS Business Analytics
• introducing the data integration applications
• introducing change management

Introduction to the Course Data and Course Scenario

• exploring the classroom environment and course data
• exploring the course tasks

Creating Metadata for Source Data

• setting up the environment
• registering metadata for SAS source tables
• registering metadata for Oracle source tables
• registering metadata for an ODBC data source
• registering metadata for external files

Creating Metadata for Target Data

• registering target data metadata
• importing metadata

Creating Metadata for Jobs

Creating Metadata for Jobs
• introduction to jobs and the job editor
• using the Join transformation

Orion Star Case Study

• define and load several dimension tables
• define calculated columns
• work with join types and the Join transformation
• work with the Table Loader transformation
• work with the User Written Code transformation

Additional Features for Jobs

• importing SAS code
• mapping and propagation
• chaining jobs
• examining performance statistics
• exploring pre-defined metadata reports (self-study)

Working with Transformations

• 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
• using the Apply Lookup Standardization, Standardize with Definition and One-Way Frequency transformations(self-study)

Working with Loop Transformations

• introducing the Loop transformations
• using the Loop transformations to iterate a job
• using the Loop transformations to iterate a single transformation (self-study)

Working with Slowly Changing Dimensions

• defining slowly changing dimensions
• using the SCD Type 2 Loader and Lookup transformations
• using the SCD Type 1 Loader transformations
• introducing the Change Data Capture transformations (self-study)

Defining Generated Transformations (self-study)

• exploring SAS code transformation templates
• using the new transformation wizard

Working with the Table Loader Transformations

• exploring the basics of the Table Loader transformations
• exploring the load styles of the Table Loader transformation
• managing indexes and constraints during loading
• exploring bulk loading for DBMS tables

Working with Databases (self-study)

• introducing In-Database processing
• using In-Database processing
• exploring ELT processing
• using Oracle functions

Additional Topics for SAS Data Integration Studio Users

• analyzing metadata using impact analysis
• comparing tables
• exploring metadata promotion
• exploring version control
• establishing checkpoints

Deploying Jobs

• introduction
• deploying jobs for scheduling
• deploying jobs in batch(self-study)
• deploying jobs as stored processes

Implementing Data Quality Techniques (self-study)

• exploring SAS and data quality opportunities
• exploring some basics of DataFlux Data Management Studio profiles and data jobs
• using the DataFlux Batch Job transformation
• using the DataFlux Data Service transformation