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

  • Tuition USD $1,600
  • Reviews star_rate star_rate star_rate star_rate star_half 1110 Ratings
  • Course Code DQPQKB
  • Duration 2 days
  • Available Formats Classroom
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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

The courses are very in-depth and useful to get a good idea of everything and get going from there.

ExitCertified education was extremely helpful for preparing me for the AWS certifications.

One of the best organized and thoughtful learning sessions I've attended, thank you!

Doing a very good job and courses offered are industry relevant.
The way courses are designed will give ample hands on exercises so that learner will be confident on implementing what he learned during the course.

Your team appears to be VERY experienced and can present and discuss ALL topics. I am very pleased with my learning experience with ExitCertified. Thank you!

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward