This course demonstrates how to take your point-and-click SAS Studio Flow skills to the next level with SAS Studio Engineer. This advanced SAS Studio license includes steps that enable you to integrate data, improve data quality, and perform specialized data transformation tasks while working with a variety of data types.
Learn How To
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.Who Should Attend
Data engineers who want to use SAS Studio Flows to design data management pipelines
Prerequisites
Before attending this course, you should have completed:;
SAS Programming 1: Essentials or have equivalent basic programming knowledge.Managing and Querying Data Using Flows in SAS Studio. Building SAS Studio Flows in SAS Viya or have equivalent SAS Studio Flows knowledge. SAS Products Covered
SAS Studio;SAS Intelligent Decisioning
Course Outline
SAS Studio Engineer
What is SAS Studio Engineer?Using SAS Studio Engineer steps in SAS Studio flows.Data Integration StepsSAS Data Integration overview.The Load Table step.The Merge Table step.The Implement SCD step.The Execute Decisions step.Data Quality StepsSAS Data Quality overview.The Clean Data step.The Match Codes step.The Parse Data step.Data Transformation StepsSAS Data Transformation overview.The Union Rows step.The Mask Data step.
