SPD Engine Data Set Options List :: SAS® 9.4 Scalable Performance Data Engine: Reference, Fourth Edition

ALIGN=

specifies variable alignment.

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 the SPD Engine to perform an automatic sort when it encounters a BY statement. BYSORT= is also a LIBNAME statement option.

COMPRESS=

specifies to compress SPD Engine data sets on disk as they are being created. COMPRESS= is also a LIBNAME statement option.

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

ENCRYPT=

specifies whether to encrypt an output SPD Engine data set.

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

ENCRYPTKEY=

specifies the key value for AES encryption.

ENDOBS=

specifies the end observation number in a user-defined range of observations to be processed. ENDOBS= is also a LIBNAME statement option.

IDXBY=

specifies whether to use an index when processing a BY statement in the SPD Engine. IDXBY= is also a LIBNAME statement option.

IDXWHERE=

specifies whether to use an index when processing a WHERE expression in the SPD Engine.

IOBLOCKSIZE=

specifies the size in bytes of a block of observations to be compressed. IOBLOCKSIZE= is also a LIBNAME statement option.

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 size that the data component partitions can be. PARTSIZE= is also a LIBNAME statement option.

STARTOBS=

specifies the starting observation number in a user-defined range of observations to be processed. STARTOBS= is also a LIBNAME statement option.

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 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.