SAS(R) Data Quality Server 9.2: Reference

Product	Release
SAS Enterprise BI Server	4.2
SAS Data Quality Server	9.2
SAS Enterprise Data Integration Server
SAS BI Server
SAS Data Integration Studio	4.2
DataFlux dfPower Studio
DataFlux Enterprise Integration Server

Using the SAS Data Quality Server Software

Load and Unload Locales

You need to load and unload locales in order to run data-cleansing programs in SAS. Conversely, you do not need to load locales if your SAS programs run jobs and services on Integration Servers from DataFlux (a SAS company).

Before you run data-cleansing programs in SAS, you load locales into memory using the AUTOCALL macro %DQLOAD (see %DQLOAD AUTOCALL Macro). The macro sets the value of the system options DQSETUPLOC= and DQLOCALE= and loads the specified locales into local memory. DQSETUPLOC= specifies the location of the setup file, and DQLOAD= specifies an ordered list of locales.

The order of locales in the locale list is pertinent only when one of the following conditions is true:

A locale is not specified by name.
The specified locale is not loaded into memory.
Input data is insufficient for the DQLOCALEGUESS function (seeDQLOCALEGUESS Function) to determine the best locale for that data.

If a locale cannot be established, SAS searches the list of locales and references the first definition it finds that has the specified name.

Note that you can change the values of the system options DQSETUPLOC= and DQLOCALE=, but doing so does not load different locales into memory. For this reason, it is recommended that you use %DQLOAD to change the values of the two data quality system options.

If you change locale files in the Quality Knowledge Base using the dfPower Customize software from DataFlux, make sure that you reload macros into memory with %DQLOAD before cleansing data.

After you submit your data-cleansing programs, you can restore the memory by unloading locales using the AUTOCALL macro %DQUNLOAD (see %DQUNLOAD AUTOCALL Macro).

New locales, and updates to existing locales, are provided periodically by DataFlux in the form of a new Quality Knowledge Base, which you can download from the following Web address:

www.dataflux.com/QKB

Top of Page