%DQLOAD AUTOCALL Macro

Sets system option values and loads locales into memory.

Syntax

Details

Example

Syntax

%DQLOAD option(s)

Summary of Optional Arguments

status information

DQINFO= 0 | 1

Required Arguments

DQSETUPLOC = "path-specification": specifies the location (root directory) of the Quality Knowledge Base. The Quality Knowledge Base contains the specified locales.

"path-specification" contains a series of selections that the system follows to reach a specified folder.

Windows Specifics:

the path specification identifies the root directory of the Quality Knowledge Base.

UNIX Specifics:

the path specification identifies the root directory of the Quality Knowledge Base.

DQLOCALE = (LOCALE1,...,LOCALEN): specifies an ordered list of locales to load into memory.

Optional Argument

DQINFO= 0 | 1: specifies that when DQINFO=1 the additional information that is generated about the status of the locale load operation is written to the SAS log.

Default:0

Details

Specify the %DQLOAD AUTOCALL macro at the beginning of each data cleansing program. This ensures that the proper list and order of locales is loaded into memory before you cleanse data. This loading prevents the use of an unintended default locale or locale list.

Specify the %DQLOAD macro before data cleansing, instead of at SAS invocation, using an AUTOEXEC or configuration file, to preserve memory and shorten the duration of the SAS invocation. Doing so is particularly beneficial when the SAS session is not used to run data cleansing programs.

It is strongly suggested that you use only the %DQLOAD macro to set the value of the DQLOCALE= system option. Setting the value of this system option by the usual means (such as an OPTIONS statement) does not load the specified locales into memory. Not loading locales into memory can lead to the use of an unintended locale. For the same reason, it is not recommended that you set the DQLOCALE= system option at SAS invocation using a configuration file or AUTOEXEC.

In addition to setting the DQLOCALE= system option, the %DQLOAD macro also sets the DQSETUPLOC= system option (if that value is not set by default at your site). When SAS is installed, the value of the DQSETUPLOC= option is set to point to the default location of the sample Quality Knowledge Base.

Example

The following example uses the DQLOCALE option to specify an ordered list of locales to load into memory. DQSETUPLOC specifies the location of the Quality Knowledge Base.

%DQLOAD(DQLOCALE=(ENUSA DEDEU), DQSETUPLOC='/sas/dqc/QKBLoc');