This course introduces and expands the knowledge of SAS Enterprise Guide and SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations. This course also covers information on working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.
Learn how to
- Using tasks, queries and report in SAS Enterprise Guide
- register source data and target tables
- create jobs and explore the functionality of the job editor
- work with many of the various transformations
- work with slowly changing dimensions
- work with Loop transformations
- create new transformations
- examine impact analysis
- examine exporting and importing of metadata
- establish checkpoints in job flow
- deploy jobs for scheduling
- deploy jobs as SAS Stored Processes.
Who should attend
Data integration developers and data integration architects
Formats available | Duration | | |
Classroom: |
5.00 days | | |
|
No SAS knowledge is required. Before attending this course, you should be familiar with Windows and other software, such as Microsoft Office or spreadsheet programs.
Getting Started
- introducing SAS Enterprise Guide
- course scenarios
Working with Data in a Project
- understanding SAS data structure
- accessing SAS and DBMS data
- importing data files
Getting Started with Tasks
- introduction to tasks and wizards
- creating a frequency report
- generating HTML, PDF, and RTF output
- creating a listing report
- filtering data in a task
- creating a graph
Creating Simple Queries
- introduction to querying data
- filtering and sorting data
- creating new columns with an expression
- grouping and summarizing data in a query
- joining tables
Creating Summarized Output
- generating summary statistics
- creating a summary report with the Summary Tables task
- generating summary statistics
- creating a summary report with the Summary Tables task
Using Prompts in Tasks and Queries
- prompting in projects
- creating and using prompts in tasks
- creating and using prompts in queries
Customizing and Organizing Project Results
Customizing and Organizing Project Results - combining results
- updating results
Writing and Submitting SAS Programs
- writing and sumitting SAS programs
Introduction in DI Studio
- exploring the platform for SAS Business Analytics
- introducing the data integration applications
- introducing change management
- exploring the platform for SAS Business Analytics
- introducing the data integration applications
- introducing change management
Introduction to the Course Data and Course Scenario
- exploring the classroom environment and course data
- exploring the course tasks
Creating Metadata for Source Data
- setting up the environment
- registering metadata for SAS source tables
- registering metadata for Oracle source tables
- registering metadata for an ODBC data source
- registering metadata for external files
Creating Metadata for Target Data
- registering target data metadata
- importing metadata
Creating Metadata for Jobs
Creating Metadata for Jobs - introduction to jobs and the job editor
- using the Join transformation
Orion Star Case Study
- define and load several dimension tables
- define calculated columns
- work with join types and the Join transformation
- work with the Table Loader transformation
- work with the User Written Code transformation
Additional Features for Jobs
- importing SAS code
- mapping and propagation
- chaining jobs
- examining performance statistics
- exploring pre-defined metadata reports (self-study)
Working with Transformations
- using the Extract and Summary Statistics transformations
- exploring SQL transformations
- establishing status handling
- using the Data Validation transformation
- using the Transpose, Sort, Append, Rank, and List Data transformations
- using the Apply Lookup Standardization, Standardize with Definition and One-Way Frequency transformations(self-study)
Working with Loop Transformations
- introducing the Loop transformations
- using the Loop transformations to iterate a job
- using the Loop transformations to iterate a single transformation (self-study)
Working with Slowly Changing Dimensions
- defining slowly changing dimensions
- using the SCD Type 2 Loader and Lookup transformations
- using the SCD Type 1 Loader transformations
- introducing the Change Data Capture transformations (self-study)
Defining Generated Transformations (self-study)
- exploring SAS code transformation templates
- using the new transformation wizard
Working with the Table Loader Transformations
- exploring the basics of the Table Loader transformations
- exploring the load styles of the Table Loader transformation
- managing indexes and constraints during loading
- exploring bulk loading for DBMS tables
Working with Databases (self-study)
- introducing In-Database processing
- using In-Database processing
- exploring ELT processing
- using Oracle functions
Additional Topics for SAS Data Integration Studio Users
- analyzing metadata using impact analysis
- comparing tables
- exploring metadata promotion
- exploring version control
- establishing checkpoints
Deploying Jobs
- introduction
- deploying jobs for scheduling
- deploying jobs in batch(self-study)
- deploying jobs as stored processes
Implementing Data Quality Techniques (self-study)
- exploring SAS and data quality opportunities
- exploring some basics of DataFlux Data Management Studio profiles and data jobs
- using the DataFlux Batch Job transformation
- using the DataFlux Data Service transformation
