Domain Naming Syntax for Libnames.parm

To define an SPD Server domain in the libnames.parm file, you must define the domain as a LIBNAME and define the path that points to the directory where data files for the domain are stored.

LIBNAME=domain-name PATHNAME=primary-metadata-path
<optional specifications>
   OPTIONS="option-1 <...option-n>"
   ROPTIONS="option-1 <...option-n>"
   OWNER=owner-id
   LIBACLINHERIT=<YES/NO>
   DYNLOCK=<YES/NO> ;

The domain name that is associated with the LIBNAME must follow standard SAS LIBNAME nomenclature rules. The PATHNAME= specification defines the computing path that will contain the metadata tables that are associated with the domain. By default, the PATHNAME= specification also will contain the data tables, index tables, and intermediate tables that the domain creates. SPD Server administrators and users can use Domain Path Options to enhance computational performance by specifying separate paths for domain data, index, and work tables. All SPD Server domain names must be unique. Different SPD Server domains should never share the same domain path.

Examples of simple libnames.parm file domain declarations follow:

LIBNAME=spds123 PATHNAME=c:\data\spds123;

LIBNAME=123spds PATHNAME=c:\data\123spds;

LIBNAME=_under PATHNAME=c:\data\_under;

LIBNAME=under_ PATHNAME=c:\data\under_;

The libnames.parm file is the preferred method to declare domains for use in SPD Server. Users can connect to domains by submitting SAS code to SPD Server after a session has started. The example SAS code below connects to the first domain that was declared previously:

LIBNAME spds123 sasspds 'spds123'
  server=d8488.5200
  user='anonymous';