Using SAS® Studio Engineer Steps in SAS® Studio Flows

Preview mode

Not attempted Using SAS® Studio Engineer Steps in SAS® Studio Flows

Duration: 7 hours

This course shows how to use Table Loader steps in SAS Studio flows to perform Insert and Update operations for database tables, including how to implement slowly changing dimensions. This course also covers how to execute SAS Intelligent Decisioning decisions with a SAS Studio flow step.

Learn How To

Use SAS Studio flow steps to perform a variety of operations to load source data into database tables.

Configure the load steps to either replace existing data in the target database table with the data in source tables or perform Insert and Update operations based on a key value.

Implement slowly changing dimensions in database tables so that historical records are retained when records in the dimension tables are updated.

Use SAS Studio flows to send data to decisions created by SAS Intelligent Decisioning and capture the decision results in a table within the flow.

Who Should Attend

Data engineers who want to use SAS Studio flows to design data management operations

Prerequisites

Before attending this course, you should have completed the SAS Programming 1: Essentials course and the Building SAS Studio Flows in SAS Viya course or have equivalent knowledge.

SAS Products Covered

SAS Studio

Course Outline

SAS Studio Flows and the SAS Studio Engineer Steps

Overview of SAS Studio flows.

SAS Studio Engineer flow steps.

Tips and tricks for Using the virtual lab to complete practices.

The Table Loader Step

Table loader capabilities and specifications.

Using the Table Loader step for existing target tables.

Using the Table Loader step when the target table does not yet exist.

The Merge Table Step

Merge table capabilities and specifications.

Using the Merge Table step.

The Implement SCD Step

Key concepts for slowly changing dimensions.

Adding the SCD generated key to the fact table.

Implement SCD capabilities and specifications.

Using the Implement SCD step.

The Execute Decisions Step

What decisions are and how they are implemented in SAS Studio flows.

Exploring decisions and using the Execute Decisions step.

THIS COURSE IS PART OF

SAS Data Engineering Learning Subscription

Skip Earn this badge

Earn this badge