Data Types

The table below describes the parameters associated with the data quality methods.
Parameter
Data Type
Description
qkb_def
nvarchar(256)
Quality knowledge base definition as defined in SAS QKB.
value
nvarchar(256)
Primary input string for modification with a data quality method. Data quality methods silently truncates character strings that are larger than 256.
sensitivity
integer
Parameter that controls the sensitivity of the match function. Varies from 0-100.
tokenlist
dqtokens
Data structure used to store multiple strings resulting from using the dq.parse and dq.extract data quality method. The other data quality functions are known as scalar functions.
Last updated: March 6, 2018