BeOptimized - 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,


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


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

Go back to your selection

This site uses cookies. .

By continuing to browse the site you are agreeing to our use of cookies. Review our cookies information for more details.