Leveraging the Power of the Quality Knowledge Base (QKB) in SAS(R) Technology Components

Course Details
Code: DQPQKB
Tuition (USD): $1,600.00 • Classroom (2 days)

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
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward