Leveraging the Power of the Quality Knowledge Base (QKB) in SAS® Technology Components
Available in:
Leveraging the Power of the Quality Knowledge Base (QKB) in SAS® Technology Components
DQPQKB : DQPQKB
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.
SAS Products Covered
SAS Data Integration Studio;SAS Enterprise Guide;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 QKB
- 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
- 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
- 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
- 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 technology components
- create FedSQL views
- use data quality methods in FedSQL
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.