SAS Data Integration Studio: Essentials

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

Duration 3 Days
Certificate SAS Global
Language English

Fees 2400


Power up your staff’s skills and boost your business

@

or Call us on 732-593-8343


About Program

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.

 

This course can help prepare you for the following certification exam(s): SAS Data Integration Development for SAS 9.

Format of Training

Taught by certified instructors at high-tech facilities across the country

Training Features

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

Course Curriculum

Introduction

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

Working with Change Management

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

Creating Metadata for Source Data

  • setting up the environment
  • registering source data metadata

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

Orion Star Case Study

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

Additional Features for Jobs

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

Working with Transformations

  • 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

Course Fees

Classroom

  

  

2400

Enroll Now