SAS Studio for the Data Engineer

• Integrate GIT with SAS Studio
• Create and Execute a SAS Studio Flow
• Deploy SAS Studio jobs to SAS Environment Manager
• Use SAS Studio flows to work with database tables.
• Combine data of various types using multiple loading methods.
• Implement and maintain slowly changing dimensions in database tables.
• Integrate SAS Intelligent Decisioning in existing flows.
• Standardize, profile, and parse data with data quality steps.
• Perform entity resolution.
• Leverage SAS Studio Analyst steps for data management operations.
• Use macro variables in a SAS Studio Flow

Technical resources who want to use SAS Studio Flows to design data management jobs. This course is for new SAS Viya users; however, it is a faster-paced course intended for experienced data engineers, analysts, and programmers. 

Before you attend this course, you should attend

• SAS Viya Overview.

Workshop Overview

• Overview.

Intro to SAS Studio

• Overview
• GIT Integration
• SAS Programs
• Python Programs
• Deploying Jobs

SAS Studio Flows

• Overview
• Flow Components

Data Quality Steps

• SAS Data Quality Overview
• The Clean Data Step
• The Match Codes Step
• The Parse Data Step

Integrating Data Steps

• Integrating Data Overview
• The Load Table Step
• The Merge Table Step
• The Implement SCD Step
• The Execute Decisions Step
• The Lookup Step

Transforming Data Steps

• Data Transformation Overview
• The Union Rows Step
• The Insert Rows Step
• The Branch Rows Step
• The Mask Data Step
• The Transpose Data Step

Macro Variables and SAS Contexts

• Macro Variables
• SAS Contexts
• Execute Jobs

Additional Resources

• SAS Studio Additional Resources