SAS Tips and Tricks

Create Slowly Changing Dimension (SDC1 and 2) in Data Step

A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. Different SCD strategies could be implemented and this tips and tricks is focused on SCD1 where records are updated no history is kept and SCD2 where history is kept,

Details

In this tips and tricks we will first create a dataset and fresh series of records to update it. We will see how we can add those new records in SAS using Proc Append and set statement.
Then we will see how we can update existing records with new records using merge and update statement. Then we will see how we can detect new records and records to update trough the Data Step. When those building blocks will have been created we will start the SCD methodology sensu stricto:

  • SCD1
  • SCD2

Prerequisites

You have some SAS experience and have knowledge in Datawarehouse. You want to update existing tables using SCD method.

Quick Facts

  • Scheduled date: Course not yet scheduled
  • Duration :6 Hours
  • Fee :480 Euros (VAT Exclusive)
  • Language: French/English
  • Included: Coffees, tips and tricks material

Christophe Kabacinski

click here to get more information about this teacher.

Course Location

This course will be organized at : Lodge.co Boulevard Simon Bolivar 34 1000 Bruxelles


Go back to your selection