When does class start/end?
Classes begin promptly at 9:00 am, and typically end at 5:00 pm.
Leveraging the Power of the Quality Knowledge Base (QKB) in SAS(R) Technology Components
This course assists SAS users with accessing the components of the Quality Knowledge Base (QKB) from within a variety of SAS technology components.The self-study e-learning includes:Annotatable...
Read More
This course assists SAS users with accessing the components of the Quality Knowledge Base (QKB) from within a variety of SAS technology components.
The self-study e-learning includes:
- Annotatable course notes in PDF format.
- Virtual Lab time to practice.
Skills Gained
- configure SAS technology components to use the Quality Knowledge Base (QKB)
- access the QKB functionality from within SAS applications and SAS code
- use SAS Data Integration Studio transformations that access Quality Knowledge Base components
- use the Cleanse Data directive in SAS Data Loader for Hadoop to access Quality Knowledge Base components
- use data quality methods in SAS Federation Server queries to access the Quality Knowledge Base components
- execute data quality expressions in SAS Event Stream Processing models to access the Quality Knowledge Base components.
Who Can Benefit
- Any SAS user who wants to leverage the power of the Quality Knowledge Base (QKB) from SAS applications and SAS code
Prerequisites
- Before attending this course, you should
- have some experience with SAS programming techniques, including working with DATA step code
- be familiar with the SQL procedure
- have a general understanding of SAS macro language
- be familiar with one or more of the following: SAS Data Integration Studio, SAS Data Quality Accelerator, SAS Data Loader for Hadoop, SAS Federation Server, or SAS Event Stream Processing.
Course Details
Introduction to the Quality Knowledge Base (QKB)
- describe the functionality that is available in the Quality Knowledge Base (QKB)
- identify some applications that use the QKB definitions for data-cleansing purposes
- identify the installation location of the QKB
- name the types of files in a QKB installation
- understand the structure of the QKB
Configuration Options for Accessing the QKB from within SAS
- describe the SAS Data Quality Server functionality
- identify the requirements for the use of the QKB in SAS applications
- list the ways that SAS applications can be configured to the QKB
- describe the options for configuring the SAS platform to the QKB
- identify the SAS autocall macros for interacting with the QKB
- explore the syntax for working with the macros
- provide code examples for using the macros
SAS Data Quality Server Procedures, Functions, and CALL Routines
- identify the code options available in SAS Data Quality Server
- identify the functions available for listing locales
- describe the use of the DQLOCLST procedure
- review the concept of standardization
- identify the CALL routine available for standardizing data values
- describe the use of the DQSCHEME procedure
- describe the use of the DQMATCH procedure
- identify the parsing and extraction functions that are available from SAS Data Quality Server
- identify the identification analysis and gender analysis functions that are available from SAS Data Quality Server
- identify the casing functions and pattern analysis functions that are available from SAS Data Quality Server
SAS Data Integration Studio Transformations That Access the QKB
- configure SAS Data Integration Studio to use the QKB
- identify the data quality transformations available in SAS Data Integration Studio
- demonstrate the use of the User Written Code transformation to set data quality options
SAS Data Quality Accelerators for In‑Database Access to the QKB
- identify the required SAS Data Quality Accelerator components
- identify the purpose of SAS Data Loader for Hadoop
- define the use of directives
- describe the five steps in the data preparation methodology
SAS Federation Server Functions That Access the QKB
- SAS Federation Server technology components
- create FedSQL views
- use data quality methods in FedSQL