SPDEUTILLOC= System Option

Specifies one or more file system locations in which the SPD Engine can temporarily store utility files.

Valid in:	configuration file, SAS invocation
Engine:	SPD Engine only
See:	The SAS Companion for your operating system details how to specify system options.

Syntax

Details

Syntax

SPDEUTILLOC=location | (location-1 ...location-n)

Required Arguments

location: is an existing directory where the utility files are created.

(location-1 ...location-n): a series of existing directories where the utility files are created.

Note:Location can be enclosed in single or double quotation marks. Quotation marks are required if location contains embedded blanks.

Details

Operating Environment Information: The SAS Companion for your operating system details how to specify system options.

The SPD Engine creates temporary utility files during certain processing, such as automatic sorting and creating indexes. To successfully complete the process, you must have enough space to store the utility files. The SPDEUTILLOC= system option enables you to specify an adequate amount of space for processing. However, for OpenVMS on HP Integrity Servers, the libraries must be ODS-5 files. When multiple directories are specified in the SPDEUTILLOC= system option, the directory for the first utility file is randomly selected when processing starts. The selection continues in a cyclical fashion to the other directories. Utility files are temporary and are removed after processing is completed.

Note: To avoid syntax errors, specify multiple directories in the configuration file.

SAS recommends that you always specify the SPDEUTILLOC= option or the UTILLOC= option to ensure that you have enough space for processes that create utility files. If the SPDEUTILLOC= system option or the UTILLOC= SAS system option is not specified, and the SPD Engine cannot locate the SAS WORK directory (or does not have Write permission to it), the location for temporary utility file storage is defined by each operating environment. The following table shows the default utility file locations:

Default Utility File Locations

Operating Environment	Default Location 1	Default Location 2	Default Location 3

UNIX	UTILLOC= SAS system option, if specified	SAS Work library	/tmp
Windows	UTILLOC= SAS system option, if specified	SAS Work library	location specified by the TEMP= environment variable
z/OS	UTILLOC= SAS system option, if specified	SAS Work library	/tmp
OpenVMS on HP Integrity Servers	UTILLOC= SAS system option, if specified	WORK= SAS system option, if specified, and ODS-5 directory (If the WORK= SAS system option does not specify an ODS-5 directory, and if the SAS session was started with the ODS-5 file specification of SASROOT, the utility files will be created in the SASROOT directory. Otherwise, there will be no default location, and the LIBNAME assignment will fail.)	sys$scratch: