SAS(R) 9.2 Language Reference: Dictionary

Product	Release
Base SAS	9.2

SAS Data Set Options

Data Set Options Documented in Other SAS Publications

In addition to data set options documented in SAS Language Reference: Dictionary, data set options are also documented in the following publications:

	SAS Companion for the Microsoft Windows Environment
	SAS Companion for the OpenVMS Environment
	SAS Companion for UNIX Environments
	SAS Companion for z/OS
	SAS National Language Support Reference Guide
	SAS Scalable Performance Data Engine: Reference
	SAS/ACCESS for Relational Databases: References

SAS Companion for the Microsoft Windows Environment

Data Set Option	Description
SGIO=	Activates the Scatter/Gather I/O feature for a dataset.

SAS Companion for the OpenVMS Environment

The data set options listed here are documented only in SAS Companion for OpenVMS. Other data set options in SAS Companion for OpenVMS contain information specific to the OpenVMS operating environment, where the main documentation is in SAS Language Reference: Dictionary. These latter data set options are not listed here.

Data Set Option	Description
ALQ=	Specifies how many disk blocks to initially allocate to a new SAS data set.
ALQMULT=	Specifies the number of pages that are preallocated to a file.
BKS=	Specifies the bucket size for a new data set.
CACHENUM=	Specifies the number of I/O data caches used per SAS file.
CACHESIZE=	Controls the size of the I/O data cache that is allocated for a SAS file.
DEQ=	Specifies how many disk blocks to add when OpenVMS automatically extends a SAS data set during a write operation.
DEQMULT=	Specifies the number of pages to extend a SAS file.
LOCKREAD	Specifies whether to read a record if a lock cannot be obtained for the record.
LOCKWAIT	Indicates whether SAS should wait for a locked record.
MBF	Specifies the multibuffer count for a data set.
WORKCACHE	Specifies the size of the I/O data cache allocated for a file in the WORK library.

SAS Companion for UNIX Environments

The data set options listed here are documented only in SAS Companion for UNIX Environments. Other data set options in SAS Companion for UNIX Environments contain information specific to the UNIX operating environment, where the main documentation is in SAS Language Reference: Dictionary. These latter data set options are not listed here.

Data Set Option	Description
ALTER=	Specifies a password for a SAS file that prevents users from replacing or deleting the file, but permits read and write access.
BUFNO=	Specifies the number of buffers to be allocated for processing a SAS data set.
BUFSIZE=	Specifies the size of a permanent buffer page for an output SAS data set.
FILECLOSE=	Specifies how a tape is positioned when a SAS data set is closed.
PW=	Assigns a READ, WRITE, or ALTER password to a SAS file, and enables access to a password-protected SAS file.
USEDIRECTIO	Turns on direct I/O for a library that contains the file to which the ENABLEDIRECTIO option has been applied.

SAS Companion for z/OS

The data set options listed here are documented only in SAS Companion for z/OS. Other data set options in SAS Companion for z/OS contain information specific to the z/OS operating environment, where the main documentation is in SAS Language Reference: Dictionary. These latter data set options are not listed here.

Data Set Option	Description
ALTER=	Assigns an alter password to a SAS file and enables access to a password-protected SAS file.
BUFSIZE=	Specifies the permanent buffer page size for an output SAS data set.
FILEDISP=	Specifies the initial disposition for a sequential access bound SAS data library.

SAS National Language Support Reference Guide

Data Set Option	Description
ENCODING=	Overrides the encoding to use for reading or writing a SAS data set.

SAS Scalable Performance Data Engine: Reference

Data Set Option	Description
ASYNCINDEX=	Specifies to create the indexes in parallel when creating multiple indexes on an SPD Engine data set.
BYNOEQUALS=	Specifies whether the output order of data set observations with identical values for the BY variable are guaranteed to be in data set order.
BYSORT=	Specifies for the SPD Engine to perform an automatic sort when it encounters a BY statement.
COMPRESS=	Specifies to compress SPD Engine data sets on disk as they are being created.
ENCRYPT	Specifies whether to encrypt an output SPD Engine data set.
ENDOBS=	Specifies the end observation number in a user-defined range of observations to be processed.
IDXWHERE=	Specifies to use indexes when processing WHERE expressions in the SPD Engine.
IOBLOCKSIZE=	Specifies the number of observations in a block to be stored in or read from an SPD Engine data component file that is compressed.
LISTFILES=	Specifies whether the CONTENTS procedure lists the complete pathnames of all the component files.
PADCOMPRESS=	Specifies a number of bytes to add to compression blocks in a data set opened for UPDATE.
PARTSIZE=	When an SPD Engine data set is created, specifies the largest size (in megabytes) that the data component partitions can be. This is a fixed size. This specification applies only to the data component files.
STARTOBS=	Specifies the starting observation number in a user-defined range of observations to be processed.
SYNCADD=	Specifies to process one observation at a time or multiple observations at a time.
THREADNUM=	Specifies the number of I/O threads the SPD Engine can spawn for processing an SPD Engine data set.
UNIQUESAVE=	Specifies to save observations with non-unique key values (the rejected observations) to a separate data set when appending or inserting observations to data sets with unique indexes.
WHERENOINDEX=	Specifies, when making WHERE expression evaluations, a list of indexes to exclude.

SAS/ACCESS for Relational Databases: References

Data Set Option	Description
AUTHID=	Enables you to qualify the specified table with an authorization ID, user ID, or group ID.
AUTOCOMMIT=	Specifies whether to enable the DBMS autocommit capability.
BL_ALLOW_READ_ACCESS=	Specifies that the original table data is still visible to readers during bulk load.
BL_ALLOWWRITE_ACCESS=	Specifies that table data is still accessible to readers and writers while import is in progress.
BL_BADFILE=	Identifies a file that contains records that were rejected during a bulk load.
BL_CODEPAGE=	Identifies the codepage that the DBMS engine uses to convert SAS character data to the current database codepage during a bulk load.
BL_CONTROL=	Identifies a file containing SQLLDR control statements that describe the data to be included in a bulk load.
BL_COPY_LOCATION=	Specifies the directory to which DB2 saves a copy of the loaded data. This option is valid only when used in conjunction with BL_RECOVERABLE=YES.
BL_CPU_PARALLELISM=	Specifies the number of processes or threads that are used when building table objects.
BL_DATA_BUFFER_SIZE=	Specifies the total amount of memory that is allocated for the bulk load utility to use as a buffer for transferring data.
BL_DATAFILE=	Identifies the file that contains the data that is loaded or appended into a DBMS table during a bulk load.
BL_DB2CURSOR=	Specifies a string that contains a valid DB2 SELECT statement that points to either local or remote objects (tables or views).
BL_DB2DEVT_PERM=	Specifies the unit address or generic device type that is used for the permanent data sets created by the LOAD utility, as well as SYSIN, SYSREC, and SYSPRINT when they are allocated by SAS.
BL_DB2DEVT_TEMP=	Specifies the unit address or generic device type that is used for the temporary data sets created by the LOAD utility (PNCH, COPY1, COPY2, RCPY1, RCPY2, WORK1, WORK2).
BL_DB2DISC=	Specifies the SYSDISC data set name for the LOAD utility.
BL_DB2ERR=	Specifies the SYSERR data set name for the LOAD utility.
BL_DB2IN=	Specifies the SYSIN data set name for the LOAD utility
BL_DB2LDCT1=	Specifies a string in the LOAD utility control statement, between LOAD DATA and INTO TABLE.
BL_DB2LDCT2=	Specifies a string in the LOAD utility control statement, between INTO TABLE table-name and (field-specification).
BL_DB2LDCT3=	Specifies a string in the LOAD utility control statement, after (field-specification)
BL_DB2LDEXT=	Specifies the mode of execution for the DB2 LOAD utility.
BL_DB2MAP=	Specifies the SYSMAP data set name for the LOAD utility.
BL_DB2PRINT=	Specifies the SYSPRINT data set name for the LOAD utility.
BL_DB2PRNLOG=	Determines whether the SYSPRINT output is written to the SAS log.
BL_DB2REC=	Specifies the SYSREC data set name for the LOAD utility
BL_DB2RECSP=	Determines the number of cylinders to specify as the primary allocation for the SYSREC data set when it is created.
BL_DB2RSTRT=	Tells the LOAD utility whether the current load is a restart and, for a restart, indicates where to begin.
BL_DB2SPC_PERM=	Determines the number of cylinders to specify as the primary allocation for the permanent data sets that are created by the LOAD utility.
BL_DB2SPC_TEMP=	Determines the number of cylinders to specify as the primary allocation for the temporary data sets that are created by the LOAD utility.