Course structure
SAS/ACCESS Technology Overview
- SAS/ACCESS technology overview.
SAS Data Integration Studio: Essentials
- Exploring the SAS platform and SAS Data Integration Studio.
- Exploring SAS Data Integration Studio basics.
- Examining SAS Data Integration Studio jobs and options.
SAS Data Integration Studio: Defining Source Data Metadata
- Setting up the environment.
- Defining metadata for a library.
- Registering metadata for data sources.
- Registering SAS table metadata.
- Registering DBMS table metadata.
- Registering ODBC data source table metadata.
- Registering metadata for external files.
SAS Data Integration Studio: Defining Target Data Metadata
- Registering metadata for target tables.
- Importing metadata.
SAS Data Integration Studio: Working with Jobs
- Creating metadata for jobs.
- Working with the Join transformation.
SAS Data Integration Studio: Working with Transformations
- Working with the Extract and Summary Statistics transformations.
- Exploring the SQL transformations.
- Creating custom transformations.
Introduction to Data Quality and the SAS Quality Knowledge Base
- Introduction to data quality.
- SAS Quality Knowledge Base overview.
DataFlux Data Management Studio: Essentials
- Overview of Data Management Studio.
- DataFlux Repositories.
- Quality Knowledge Bases and reference data sources.
- Data connections.
DataFlux Data Management Studio: Understanding Data
- Methodology review.
- Creating data collections.
- Designing data explorations.
- Creating data profiles.
- Profiling other input types.
- Designing data standardization schemes.
DataFlux Data Management Studio: Building Data Jobs to Improve Data
- Introduction to data jobs.
- Standardization, parsing, and casing.
- Identification analysis and right fielding.
- Branching and gender analysis.
- Data enrichment.
DataFlux Data Management Studio: Building Data Jobs for Entity Resolution
- Creating match codes.
- Clustering records.
- Survivorship.
Understanding the SAS Quality Knowledge Base (QKB)
- Working with QKB component files.
- Working with QKB definitions.
Using SAS Code to Access QKB Components
- SAS configuration options for accessing the QKB.
- SAS Data Quality Server overview.
