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

Preview mode

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

Duration: 14 hours

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.

Learn How To

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 Should Attend

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.;Knowledge of the platform for SAS Business Analytics is helpful but not required.

SAS Products Covered

SAS Enterprise Guide;SAS Data Integration Studio;SAS Federation Server

Course Outline

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 QKBConfiguration 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 macrosSAS 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 ServerSAS 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 optionsSAS 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 methodologySAS Federation Server Functions That Access the QKB

SAS Federation Server technology components

create FedSQL views

use data quality methods in FedSQL

The hands-on lab is preconfigured to support this course and will not support hands-on practice for all your enrolled courses.