SPD Engine Data Set Options List

ASYNCINDEX=

specifies to create indexes in parallel when creating multiple indexes on an SPD Engine data set.

BYNOEQUALS=

specifies the index output order of data set observations that have identical values for the BY variable.

BYSORT=

specifies for the SPD Engine to perform an automatic sort when it encounters a BY statement.

COMPRESS=

compresses SPD Engine data sets on disk.

Note: Compression and encryption are mutually exclusive in SPD Engine.

ENCRYPT=

Encrypts data files.

Note: Compression and encryption are mutually exclusive in SPD Engine.

ENDOBS=

specifies the end observation number in a user-defined range of observations to be processed.

IDXBY=

specifies whether to use an index when processing BY statements in the SPD Engine.

IDXWHERE=

specifies to use indexes when processing WHERE expressions in the SPD Engine.

IOBLOCKSIZE=

specifies the size of a block of observations to be compressed.

LISTFILES=

specifies whether the CONTENTS procedure lists the complete pathnames of all of the component files in an SPD Engine data set.

PADCOMPRESS=

specifies the number of bytes to add to compressed blocks in a data set opened for OUTPUT or UPDATE.

PARTSIZE=

specifies the maximum partition size of the data component files. PARTSIZE= is also a LIBNAME option.

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 a block of observations at a time.

THREADNUM=

specifies the maximum number of threads to use for the SPD Engine processing.

UNIQUESAVE=

specifies to save (in a separate file) any observations that were rejected because of nonunique key values during an append or insert to a data set with unique indexes when SYNCADD=NO.

WHERENOINDEX=

specifies a list of indexes to exclude when making WHERE expression evaluations.