SAS Studio for the Data Engineer
DESD : DESDV1
This hands-on course provides training on SAS Studio in SAS Viya. It focuses on creating data engineering flows in SAS Studio.
Learn How To
- 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
Who Should Attend
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.
Prerequisites
Before you attend this course, you should attend
SAS Products Covered
SAS Studio
Course Outline
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
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and coaching may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Coaching Services
Take your training to the next level with personalized coaching. While private training offers structured coursework, coaching provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.