Understand the Setup File

To access a Quality Knowledge Base, your SAS programs refer to path specifications in the setup file dqsetup.txt. The location of the setup file is specified by the system option DQSETUPLOC=. The value of the system option can be the path to dqsetup.txt, or a path to the root directory of your Quality Knowledge Base.

In the z/OS operating environment, the setup file DQSETUP is a member of a SAS Data Quality Configuration PDS.

Note:   SAS programs that run jobs and services on DataFlux Integration Servers do not reference the setup file. Nor do they directly access a Quality Knowledge Base.   

If you move your Quality Knowledge Base, make sure that you change the value of DQSETUPLOC= accordingly.

If your site uses multiple Quality Knowledge Bases, make sure that your programs set DQSETUPLOC= to point to the intended setup file.

The data quality setup file consists of a table with two columns. The first column lists file access methods. The second column provides fully-qualified paths to the contents of the Quality Knowledge Base.

If you edit the setup file, always be sure to do these tasks:

• Include a semicolon at the end of each fully-qualified path.

• Specify the DISK access method.

• In the Windows and UNIX operating environments, do not change the last directory or filename in any path. For the z/OS operating environment, do not change the PDS names, and don't change the names of their contents. For example, in the following entry in the setup file, you would retain the GRAMMAR PDS name and not change any member names inside that PDS:

  DISK SAS91.DQ.GRAMMAR;

If you would like to add comment lines to your setup file, specify an exclamation point (!) as the first non-blank character in each line that contains comments. When an exclamation point is detected in this position, the software ignores any other text on that line.

You can insert blank lines into the setup file.

In the setup file, the maximum record (line) length is 1024 characters.

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.