Concepts

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 a DataFlux Integration Server.

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

See: %DQLOAD AUTOCALL Macro.

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.

If a locale cannot be established, SAS searches the list of locales. SAS references the first definition it finds that has the specified name. Use the DQLOCALEGUESS Function, to determine the best locale for that data.

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

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

After you submit your data-cleansing programs, you can unload the locale from memory by using the %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