This course is for programmers who want to learn how to leverage the power of the SAS Quality Knowledge Base, or QKB. The QKB and the associated SAS Data Quality functions, routines, procedures, and CAS actions enable data cleansing, transformation, deduplication, and fuzzy matching using simplified code in DATA step, SQL, and CASL. The course builds on concepts presented in the SAS(R) Programming I: Essentials, SAS(R) Programming II: Manipulating Data with the DATA Step, and SAS(R) SQL 1: Essentials courses, and is not recommended for beginning SAS software users.
Learn How To
Understand the structure of the SAS Quality Knowledge Base (QKB)Configure the QKB in SAS 9.4 and in SAS ViyaWork with QKBs and Locales in SAS 9, the Viya Compute Server, and Cloud Analytic Services (CAS) to:Parse data from complex textStandardize data valuesConduct a fuzzy join for tables that do not share primary keysDeduplicate data Who Should Attend
Data scientists, data engineers, data analysts, and SAS programmers.
Prerequisites
Before attending this course, you should be able to do the following:;
write DATA step code to subset rows and columns, compute new columns, perform conditional processing, and use a BY statement for merging and processing data in groups with FIRST./LAST. logic.write SQL queries, including inner and outer joins and creating computed columns.apply SAS formats to data values using the PUT function.execute basic SAS procedures, like PROC PRINT and PROC MEANS.SAS Products Covered
SAS Viya
Course Outline
Introduction to the SAS Quality Knowledge Base (QKB)
Introduction to the SAS Quality Knowledge BaseQuality Knowledge Base Data Types and TokensQuality Knowledge Base Definition TypesConfiguring the QKB in SAS 9Overview of SAS 9 System OperationsSetting System Options for Accessing the QKB Interacting with the QKB ProgrammaticallyConfiguring the QKB in SAS Viya Overview of SAS Viya Data Quality System OptionsSetting Session Options for Accessing the QKBInteracting with the QKB on the SAS Compute ServerWorking with QKBs and LocalesOverview of QKBs and LocalesUsing the QKB ProcedureUsing the DQLOCLIST ProcedureUsing Locale FunctionsData Quality in SAS Programming Introduction to SAS Data QualitySAS Data Quality ProceduresSAS Data Quality FunctionsSAS Data Quality CALL RoutinesStandardizing DataData Standardization OverviewUsing PROC DQSCHEMEUsing Standardization FunctionsUsing the Standardization CALL RoutineEntity Resolution with Match CodesOverview of Entity ResolutionUsing PROC DQMATCHUsing Match Code FunctionsParsing and Extracting Data ValuesParsing Text and Working with TokensExtracting Values from TextUsing Other Types of DefinitionsIdentification Analysis and Gender AnalysisCasing and Pattern AnalysisWorking with the QKB in CASSAS Data Quality Functions in CASSAS Data Quality CAS Action SetsThe QKB Action SetThe Data Discovery Action SetThe Entity Resolution Action Set
