SAS Data Quality Server Concepts

To access a Quality Knowledge Base, SAS programs reference the value set in the DQSETUPLOC= system option. The value of the system option is the path to the root directory of a Quality Knowledge Base.

Use the DQOPTIONS= system option to configure your SAS session for data quality. Specify the option in your SAS start-up command. SASV9.CFG. DQOPTIONS= enables you to specify one or more option-value pairs that pertain to the operation of the SAS Data Quality Server software.

The DQOPTIONS= system option enables two option-value pairs. The DQSRVPROTOCOL=WIRELINE pair improves the performance of the DMSRVDATASVC and DMSRVPROCESSSVC procedures by streamlining data transfer to and from the DataFlux Data Management Server. It is the default on z/OS, and improves performance on all other platforms. In other operating environments, the default Simple Object Access Protocol (SOAP) is recommended.

TRANSCODE=IGNORE | WARN specifies that transcoding errors between character sets are to be ignored, and SAS processing is allowed to continue. By default, transcoding errors terminate SAS processing.

See DQOPTIONS= System Option for additional information.

To specify definitions in your SAS data cleansing programs, you need to know the names of the definitions that are available in a particular locale. To find out the names of the definitions that are available in a particular local, use the %DQPUTLOC AUTOCALL Macro.

To display information about a locale that is currently loaded into memory, use the DQLOCALEINFOGET Function.

To display a list of definitions in a specified locale, use the DQLOCALEINFOLIST Function to return the name of the locale that best fits your data.

The SAS Data Quality Server software is delivered with a sample Quality Knowledge Base. After you install the SAS Data Quality Server software, download the latest Quality Knowledge Base, including your choice of locales, from the SAS Downloads site.

To maximize performance, download new Quality Knowledge Bases as they are made available on the SAS Downloads site. Check the latest release notes to determine whether definitions used by your jobs have been updated. Decide whether you need any of the new locale support that might have been added. (If you decide that you need new locale support, please contact SAS to revise your license agreement.) For a listing of the latest enhancements to the QKB, refer to the “What’s New in DataFlux Quality Knowledge Base” in the QKB Help.

When you update your Quality Knowledge Base, you might want to install it in a new location rather than overwriting your existing Quality Knowledge Base. This decision is particularly important if you have customized your Quality Knowledge Base in the previous release. Customizations are made with the DataFlux Data Management Studio software. If you install your updated Quality Knowledge Base in a new location, make sure you reference the Quality Knowledge Base by specifying the appropriate value in the DQSETUPLOC= system option.

If you customized your previous Quality Knowledge Base, evaluate those changes and carry them over to your new Quality Knowledge Base as needed.