Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

Workshop: SAS Data Integration Studio

Course Length - 2 Days

This workshop is delivered over two days. To begin with the focus is on registering data and organising the metadata environment. The workshop then moves on to cover the most important DI Studio transformations; and then the development of jobs using those transformations, in some cases in conjunction with user-written SAS code. Efficiency, maintenance, impact analysis, change management and job scheduling are also covered.

Public Course price:
£820.00 plus VAT per delegate

Workshop: SAS Data Integration Studio Public Course Dates

Due to Covid-19 all Amadeus training will be delivered via live web classes. Our live Web classes are as interactive as our classroom training, there are also some benefits - no travelling time and costs!

Audience

This workshop is designed for Computer Users familiar with the SAS® System and who wish to learn how to build and maintain jobs using SAS Data Integration Studio.



Prerequisites

Attendees will be expected to have some knowledge of SAS programming, including the SAS macro language.

Topics

DI 1 Introduction to Data Integration Studio

  • Overview
  • Metadata
  • Metadata in SAS Management Console
  • Metadata-based software development in DI Studio
  • The DI Studio Interface
  • Metadata folder structure
  • A quick look at a job

DI 2 Registering Data

  • Introduction
  • Registering a library
  • Registering existing tables
  • Registering target tables
  • Naming conventions for tables
  • Table metadata and the physical table
  • Registering external files

DI 3 DI Studio Transformations

  • Transformations available
  • Extract
  • SQL Join
  • Table Loader
  • Sort
  • Append
  • Splitter
  • List Data
  • Lookup
  • Data Validation

DI 4 DI Studio Jobs

  •  Job generalities
  •  Naming conventions
  •  Job Editor options
  •  Details Panel
  •  Running jobs

DI 5 Further Transformations

  • The SCD Type 1 Loader
  • The Loop and Loop End transforms, and looping jobs
  • The SCD Type 2 Loader
  • The Conditional Start and Conditional End transforms, and conditional jobs

DI 6 Including User Code

  •    Ways of including user code in a job
  •    User-Written Code Node
  •    Precode and Postcode
  •    Custom Transforms

DI 7 Change Management

  •    Why use Change Management?
  •    Creating a Project Repository
  •    Using a Project Repository
  •    Change Management Hints and Tips

DI 8 Program Development and Maintenance

  • Making jobs easy to promote between environments
  • Making jobs easy to modify and maintain
  • Modifying a job to use different tables
  • Modifying a job in other ways
  • Running parts of a job
  • The Code Editor
  • Tables or Views?
  • Macros and formats
  • Impact Analysis and Reverse Impact Analysis

DI 9 Deployment and Scheduling

  • Deployment and Scheduling Basics
  • Deploying jobs
  • Re-deploying jobs
  • Building job flows
  • Scheduling flows