SAS DI Studio

Standard Course
£700 +VAT
per delegate
Course duration: 2 Days

You will be able to prepare DI Studio transformations and develop 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.

Who is it for?

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.

What you will learn

  • 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

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

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

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

  • 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

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

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

  • 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

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

SAS DI Studio Course Dates

Our courses are live instructor-led and can be attended virtually or at our office.

  • Wednesday 13 March 2024 - Thursday 14 March 2024
    Book now
  • Wednesday 12 June 2024 - Thursday 13 June 2024
    Book now
  • Tuesday 10 September 2024 - Wednesday 11 September 2024
    Book now
  • Monday 09 December 2024 - Tuesday 10 December 2024
    Book now
Back to Training

Talk to us about how we can help