Table Options Listed by Product

Base SAS

Name	Syntax and Description
ALTER= Table Option	ALTER==alter-password Assigns an ALTER password to a data set that prevents users from replacing or deleting the file, and enables access to a Read- and Write-protected file. Product: Base SAS Document: SAS DS2 Language Reference
ALTER= Table Option	ALTER= alter-password Assigns an ALTER password to a data set that prevents users from replacing or deleting the file, and enables access to a Read- or Write-protected file. Product: Base SAS Document: SAS FedSQL Language Reference
ASYNCINDEX= Table Option	ASYNCINDEX= YES \| NO Specifies to create indexes in parallel when creating multiple indexes on an SPD Engine data set. Product: Base SAS Document: SAS DS2 Language Reference
ASYNCINDEX= Table Option	ASYNCINDEX= YES \| NO Specifies to create indexes in parallel when creating multiple indexes on an SPD Engine data set. Product: Base SAS Document: SAS FedSQL Language Reference
BL_ALLOW_READ_ACCESS= Table Option	BL_ALLOW_READ_ACCESS= YES \| NO Specifies that the original table data is still visible to readers during bulk load. Product: Base SAS Document: SAS DS2 Language Reference
BL_ALLOW_READ_ACCESS= Table Option	BL_ALLOW_READ_ACCESS= YES \| NO Specifies that the original table data is still visible to readers during bulk load. Product: Base SAS Document: SAS FedSQL Language Reference
BL_COPY_LOCATION= Table Option	BL_COPY_LOCATION= pathname Specifies the directory to which DB2 saves a copy of the loaded data. Product: Base SAS Document: SAS DS2 Language Reference
BL_COPY_LOCATION= Table Option	BL_COPY_LOCATION= pathname Specifies the directory to which DB2 saves a copy of the loaded data. Product: Base SAS Document: SAS FedSQL Language Reference
BL_CPU_PARALLELISM= Table Option	BL_CPU_PARALLELISM= number-of-processes-or-threads Specifies the number of processes or threads to use when building table objects. Product: Base SAS Document: SAS DS2 Language Reference
BL_CPU_PARALLELISM= Table Option	BL_CPU_PARALLELISM= number-of-processes-or-threads Specifies the number of processes or threads to use when building table objects. Product: Base SAS Document: SAS FedSQL Language Reference
BL_DATA_BUFFER_SIZE= Table Option	BL_DATA_BUFFER_SIZE= buffer-size Specifies the total amount of memory to allocate for the bulk load utility to use as a buffer for transferring data. Product: Base SAS Document: SAS DS2 Language Reference
BL_DATA_BUFFER_SIZE= Table Option	BL_DATA_BUFFER_SIZE= buffer-size Specifies the total amount of memory to allocate for the bulk load utility to use as a buffer for transferring data. Product: Base SAS Document: SAS FedSQL Language Reference
BL_DEFAULT_DIR= Table Option	BL_DEFAULT_DIR= host-specific-directory-path Specifies the location where bulk load creates all intermediate files. Product: Base SAS Document: SAS DS2 Language Reference
BL_DEFAULT_DIR= Table Option	BL_DEFAULT_DIR= host-specific-directory-path Specifies the location where bulk load creates all intermediate files. Product: Base SAS Document: SAS FedSQL Language Reference
BL_DISK_PARALLELISM= Table Option	BL_DISK_PARALLELISM= number-of-processes-or-threads Specifies the number of processes or threads to use when writing data to disk. Product: Base SAS Document: SAS DS2 Language Reference
BL_DISK_PARALLELISM= Table Option	BL_DISK_PARALLELISM= number-of-processes-or-threads Specifies the number of processes or threads to use when writing data to disk. Product: Base SAS Document: SAS FedSQL Language Reference
BL_ERRORS= Table Option	BL_ERRORS= number Specifies that, after the indicated number of errors is received, the load should stop. Product: Base SAS Document: SAS DS2 Language Reference
BL_ERRORS= Table Option	BL_ERRORS= number Specifies that, after the indicated number of errors is received, the load should stop. Product: Base SAS Document: SAS FedSQL Language Reference
BL_EXCEPTION= Table Option	BL_EXCEPTION= exception-table-name Specifies the exception table into which rows in error are copied. Product: Base SAS Document: SAS DS2 Language Reference
BL_EXCEPTION= Table Option	BL_EXCEPTION= exception-table-name Specifies the exception table into which rows in error are copied. Product: Base SAS Document: SAS FedSQL Language Reference
BL_INDEXING_MODE= Table Option	BL_INDEXING_MODE= AUTOSELECT \| REBUILD \| INCREMENTAL \| DEFERRED Specifies which scheme the DB2 load utility should use for index maintenance. Product: Base SAS Document: SAS DS2 Language Reference
BL_INDEXING_MODE= Table Option	BL_INDEXING_MODE= AUTOSELECT \| REBUILD \| INCREMENTAL \| DEFERRED Specifies which scheme the DB2 load utility should use for index maintenance. Product: Base SAS Document: SAS FedSQL Language Reference
BL_LOAD= Table Option	BL_LOAD= number-of-rows Specifies that, after the indicated number of rows is loaded, the load should stop. Product: Base SAS Document: SAS DS2 Language Reference
BL_LOAD= Table Option	BL_LOAD= number-of-rows Specifies that, after the indicated number of rows is loaded, the load should stop. Product: Base SAS Document: SAS FedSQL Language Reference
BL_LOAD_REPLACE= Table Option	BL_LOAD_REPLACE= NO \| YES Specifies whether DB2 appends or replaces rows during bulk loading. Product: Base SAS Document: SAS DS2 Language Reference
BL_LOAD_REPLACE= Table Option	BL_LOAD_REPLACE= NO \| YES Specifies whether DB2 appends or replaces rows during bulk loading. Product: Base SAS Document: SAS FedSQL Language Reference
BL_LOG= Table Option	BL_LOG= "path-and-log-file-name" Identifies a log file that contains information such as statistics and error information for a bulk load. Product: Base SAS Document: SAS DS2 Language Reference
BL_LOG= Table Option	BL_LOG= "path-and-log-file-name" Identifies a log file that contains information such as statistics and error information for a bulk load. Product: Base SAS Document: SAS FedSQL Language Reference
BL_LOGFILE= Table Option	BL_LOGFILE= 'log-file-name' Specifies the filename for the bulk load log file. Product: Base SAS Document: SAS DS2 Language Reference
BL_LOGFILE= Table Option	BL_LOGFILE= 'log-file-name' Specifies the filename for the bulk load log file. Product: Base SAS Document: SAS FedSQL Language Reference
BL_OPTIONS= Table Option	BL_OPTIONS= 'option [, …option ] ' Passes options to the DBMS bulk load facility, affecting how it loads and processes data. Product: Base SAS Document: SAS DS2 Language Reference
BL_OPTIONS= Table Option	BL_OPTIONS= 'option [, …option ] ' Passes options to the DBMS bulk load facility, affecting how it loads and processes data. Product: Base SAS Document: SAS FedSQL Language Reference
BL_PARALLEL Table Option	BL_PARALLEL= YES \| NO Specifies whether to perform a parallel bulk load. Product: Base SAS Document: SAS DS2 Language Reference
BL_PARALLEL Table Option	BL_PARALLEL= YES \| NO Specifies whether to perform a parallel bulk load. Product: Base SAS Document: SAS FedSQL Language Reference
BL_PORT_MAX= Table Option	BL_PORT_MAX= integer Sets the highest available port number for concurrent uploads. Product: Base SAS Document: SAS DS2 Language Reference
BL_PORT_MAX= Table Option	BL_PORT_MAX= integer Sets the highest available port number for concurrent uploads. Product: Base SAS Document: SAS FedSQL Language Reference
BL_PORT_MIN= Table Option	BL_PORT_MIN= integer Sets the lowest available port number for concurrent uploads. Product: Base SAS Document: SAS DS2 Language Reference
BL_PORT_MIN= Table Option	BL_PORT_MIN= integer Sets the lowest available port number for concurrent uploads. Product: Base SAS Document: SAS FedSQL Language Reference
BL_RECOVERABLE= Table Option	BL_RECOVERABLE= YES \| NO Specifies whether the LOAD process is recoverable. Product: Base SAS Document: SAS DS2 Language Reference
BL_RECOVERABLE= Table Option	BL_RECOVERABLE= YES \| NO Specifies whether the LOAD process is recoverable. Product: Base SAS Document: SAS FedSQL Language Reference
BL_REMOTE_FILE= Table Option	BL_REMOTE_FILE= pathname-and-base-filename Specifies the base filename and location of DB2 LOAD temporary files. Product: Base SAS Document: SAS DS2 Language Reference
BL_REMOTE_FILE= Table Option	BL_REMOTE_FILE= pathname-and-base-filename Specifies the base filename and location of DB2 LOAD temporary files. Product: Base SAS Document: SAS FedSQL Language Reference
BL_SKIP= Table Option	BL_SKIP= number-of-rows Specifies to skip the indicated number of rows before starting the bulk load. Product: Base SAS Document: SAS DS2 Language Reference
BL_SKIP= Table Option	BL_SKIP= number-of-rows Specifies to skip the indicated number of rows before starting the bulk load. Product: Base SAS Document: SAS FedSQL Language Reference
BL_SKIP_INDEX_MAINTENANCE= Table Option	BL_SKIP_INDEX_MAINTENANCE= YES \| NO Specifies whether to perform index maintenance on the bulk load. Product: Base SAS Document: SAS DS2 Language Reference
BL_SKIP_INDEX_MAINTENANCE= Table Option	BL_SKIP_INDEX_MAINTENANCE= YES \| NO Specifies whether to perform index maintenance on the bulk load. Product: Base SAS Document: SAS FedSQL Language Reference
BL_SKIP_UNUSABLE_INDEXES= Table Option	BL_SKIP_UNUSABLE_INDEXES= YES \| NO Specifies whether to skip index entries that are in an unusable state and continue with the bulk load. Product: Base SAS Document: SAS DS2 Language Reference
BL_SKIP_UNUSABLE_INDEXES= Table Option	BL_SKIP_UNUSABLE_INDEXES= YES \| NO Specifies whether to skip index entries that are in an unusable state and continue with the bulk load. Product: Base SAS Document: SAS FedSQL Language Reference
BL_WARNING_COUNT= Table Option	BL_WARNING_COUNT= number-of-warnings Specifies the maximum number of row warnings to allow before the load fails. Product: Base SAS Document: SAS DS2 Language Reference
BL_WARNING_COUNT= Table Option	BL_WARNING_COUNT= number-of-warnings Specifies the maximum number of row warnings to allow before the load fails. Product: Base SAS Document: SAS FedSQL Language Reference
BUFNO= Table Option	BUFNO= n \| nK \| hexX \| MIN \| MAX Specifies the number of buffers to be allocated for processing a SAS data set. Product: Base SAS Document: SAS DS2 Language Reference
BUFNO= Table Option	BUFNO= n \| nK \| hexX \| MIN \| MAX Specifies the number of buffers to be allocated for processing a SAS data set. Product: Base SAS Document: SAS FedSQL Language Reference
BUFSIZE= Table Option	BUFSIZE=n \| nK \| nM \| nG \| hexX \| MIN \| MAX Specifies the size of a permanent buffer page for an output SAS data set. Product: Base SAS Document: SAS DS2 Language Reference
BUFSIZE= Table Option	BUFSIZE=n \| nK \| nM \| nG \| hexX \| MIN \| MAX Specifies the size of a permanent buffer page for an output SAS data set. Product: Base SAS Document: SAS FedSQL Language Reference
BULKLOAD= Table Option	BULKLOAD= YES \| NO Determines whether SAS uses a DBMS facility to insert data into a DBMS table. Product: Base SAS Document: SAS DS2 Language Reference
BULKLOAD= Table Option	BULKLOAD= YES \| NO Determines whether SAS uses a DBMS facility to insert data into a DBMS table. Product: Base SAS Document: SAS FedSQL Language Reference
BULKOPTS= Table Option	BULKOPTS= (option[ ...option]) Provides a container for bulk-loading options. Product: Base SAS Document: SAS DS2 Language Reference
BULKOPTS= Table Option	BULKOPTS= (option[ ...option]) Provides a container for bulk-loading options. Product: Base SAS Document: SAS FedSQL Language Reference
COMPRESS= Table Option	COMPRESS= NO \| YES \| CHAR \| BINARY Specifies how rows are compressed in a new output data set or table. Product: Base SAS Document: SAS DS2 Language Reference
COMPRESS= Table Option	COMPRESS= NO \| YES \| CHAR \| BINARY Specifies how rows are compressed in a new output data set or table. Product: Base SAS Document: SAS FedSQL Language Reference
CONFIG= Table Option	CONFIG="configuration-path" Specifies a file or pathname for Hadoop configuration path resolution. Product: Base SAS Document: SAS DS2 Language Reference
CONFIG= Table Option	CONFIG="configuration-path" Specifies a file or pathname for Hadoop configuration path resolution. Product: Base SAS Document: SAS FedSQL Language Reference
DATAFILE= Table Option	DATAFILE= "filename" Specifies an alternate name and location for the temporary HDFS file. Product: Base SAS Document: SAS DS2 Language Reference
DATAFILE= Table Option	DATAFILE= "filename" Specifies an alternate name and location for the temporary HDFS file. Product: Base SAS Document: SAS FedSQL Language Reference
DBCREATE_INDEX_OPTS= Table Option	DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses' Allows DBMS-specific options to be added to the CREATE INDEX statement. Product: Base SAS Document: SAS DS2 Language Reference
DBCREATE_INDEX_OPTS= Table Option	DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses' Allows DBMS-specific options to be added to the CREATE INDEX statement. Product: Base SAS Document: SAS FedSQL Language Reference
DBCREATE_TABLE_OPTS= Table Option	DBCREATE_TABLE_OPTS= 'DBMS-options' Specifies DBMS-specific options to be added to the DATA statement. Product: Base SAS Document: SAS DS2 Language Reference
DBCREATE_TABLE_OPTS= Table Option	DBCREATE_TABLE_OPTS= 'DBMS-SQL-clauses' Allows database-specific options to be placed after the CREATE TABLE statement in generated SQL code. Product: Base SAS Document: SAS FedSQL Language Reference
DROP= Table Option	DROP= (column-list) For an input table, excludes the specified columns from processing; for an output table, excludes the specified columns from being written to the table. Product: Base SAS Document: SAS DS2 Language Reference
ENCODING= Table Option	ENCODING=encoding-value Specifies the encoding to use when creating a SAS data set. Product: Base SAS Document: SAS FedSQL Language Reference
ENCRYPT= Table Option	ENCRYPT==AES \| AES2 \| NO \| YES Specifies whether to encrypt an output SAS data set. Product: Base SAS Document: SAS DS2 Language Reference
ENCRYPT= Table Option	ENCRYPT= AES \| AES2 \| NO \| YES Specifies whether to encrypt an output SAS data set. Product: Base SAS Document: SAS FedSQL Language Reference
ENCRYPTKEY= Table Option	ENCRYPTKEY=key-value Specifies a key value for AES encryption. Product: Base SAS Document: SAS DS2 Language Reference
ENCRYPTKEY= Table Option	ENCRYPTKEY= [' \| "]key-value [' \| "] Specifies a key value for AES and AES2 encryption. Product: Base SAS Document: SAS FedSQL Language Reference
ENDOBS= Table Option	ENDOBS= n Specifies the end observation number in a user-defined range of observations to be processed. Product: Base SAS Document: SAS DS2 Language Reference
ENDOBS= Table Option	ENDOBS= n Specifies the end observation number in a user-defined range of observations to be processed. Product: Base SAS Document: SAS FedSQL Language Reference
EXTENDOBSCOUNTER= Table Option	EXTENDOBSCOUNTER=YES \| NO Specifies whether to extend the maximum observation count in a new output SAS data set. Product: Base SAS Document: SAS DS2 Language Reference
GP_DISTRIBUTED_BY= Table Option	GP_DISTRIBUTED_BY= 'DISTRIBUTED BY (column [, ...column]) \| DISTRIBUTED RANDOMLY' Specifies the distribution key for the table being created. Product: Base SAS Document: SAS DS2 Language Reference
GP_DISTRIBUTED_BY= Table Option	GP_DISTRIBUTED_BY= 'DISTRIBUTED BY (column [, ...column]) \| DISTRIBUTED RANDOMLY' Specifies the distribution key for the table being created. Product: Base SAS Document: SAS FedSQL Language Reference
IDXNAME= Table Option	IDXNAME= index-name Directs SAS to use a specific index to match the conditions of a WHERE clause. Product: Base SAS Document: SAS DS2 Language Reference
IDXNAME= Table Option	IDXNAME= index-name Directs SAS to use a specific index to match the conditions of a WHERE clause. Product: Base SAS Document: SAS FedSQL Language Reference
IDXWHERE= Table Option	IDXWHERE= YES \| NO Specifies whether SAS uses an index search or a sequential search to match the conditions of a WHERE clause. Product: Base SAS Document: SAS DS2 Language Reference
IDXWHERE= Table Option	IDXWHERE= YES \| NO Specifies whether SAS uses an index search or a sequential search to match the conditions of a WHERE clause. Product: Base SAS Document: SAS FedSQL Language Reference
IN= Table Option	IN=variable Creates an integer variable that indicates whether the table contributed data to the current row. Product: Base SAS Document: SAS DS2 Language Reference
INLINE Table Option	INLINE Specifies that the package or thread source code is not saved to a table for reuse and is validated and compiled only when loaded by a data program. Product: Base SAS Document: SAS DS2 Language Reference
IOBLOCKSIZE= Table Option	IOBLOCKSIZE= n Specifies the number of rows in a block to be used in an I/O operation. Product: Base SAS Document: SAS DS2 Language Reference
IOBLOCKSIZE= Table Option	IOBLOCKSIZE= n Specifies the number of rows in a block to be used in an I/O operation. Product: Base SAS Document: SAS FedSQL Language Reference
KEEP= Table Option	KEEP=(column-list) For an input table, specifies the columns to process; for an output table, specifies the columns to write to the table. Product: Base SAS Document: SAS DS2 Language Reference
KMS_PATH= Table Option	KMS_PATH=”path-and-filename" Specifies the location of a key file resource within a project. Product: Base SAS Document: SAS FedSQL Language Reference
LABEL= Table Option	LABEL='label' Specifies a label for a table. Product: Base SAS Document: SAS DS2 Language Reference
LABEL= Table Option	LABEL= 'label ' Specifies a label for a table. Product: Base SAS Document: SAS FedSQL Language Reference
LOCATION= Table Option	LOCATION='value' Specifies the location of the data set. Product: Base SAS Document: SAS FedSQL Language Reference
LOCKTABLE= Table Option	LOCKTABLE=SHARE \| EXCLUSIVE Places shared or exclusive locks on tables. Product: Base SAS Document: SAS DS2 Language Reference
LOCKTABLE= Table Option	LOCKTABLE= EXCLUSIVE \| SHARE Places shared or exclusive locks on tables. Product: Base SAS Document: SAS FedSQL Language Reference
ORHINTS= Table Option	ORHINTS='/* Oracle-hint */' Specifies Oracle hints to pass to Oracle from FedSQL. Product: Base SAS Document: SAS DS2 Language Reference
ORHINTS= Table Option	ORHINTS='/* Oracle-hint */' Specifies Oracle hints to pass to Oracle from FedSQL. Product: Base SAS Document: SAS FedSQL Language Reference
ORNUMERIC= Table Option	ORNUMERIC=YES \| NO Specifies how numbers read from or inserted into the Oracle NUMBER column are treated. Product: Base SAS Document: SAS DS2 Language Reference
ORNUMERIC= Table Option	ORNUMERIC=YES \| NO Specifies how numbers read from or inserted into the Oracle NUMBER column are treated. Product: Base SAS Document: SAS FedSQL Language Reference
OVERWRITE= Table Option	OVERWRITE=YES \| NO For a table, drops the output table before the replacement output table is populated with rows; for packages and threads, drops the existing package or thread if a package or thread by the same name exists. Product: Base SAS Document: SAS DS2 Language Reference
PADCOMPRESS= Table Option	PADCOMPRESS= n Specifies the number of bytes to add to compressed blocks in an SPD Engine data set that is opened for OUTPUT or UPDATE. Product: Base SAS Document: SAS DS2 Language Reference
PADCOMPRESS= Table Option	PADCOMPRESS= n Specifies the number of bytes to add to compressed blocks in an SPD Engine data set that is opened for OUTPUT or UPDATE. Product: Base SAS Document: SAS FedSQL Language Reference
PARTSIZE= Table Option	PARTSIZE= n Specifies the size of the table partitions. Product: Base SAS Document: SAS DS2 Language Reference
PARTSIZE= Table Option	PARTSIZE= n Specifies the size of the table partitions. Product: Base SAS Document: SAS FedSQL Language Reference
PASSWORD= Table Option	PASSWORD="value" Specifies the password for the HDFS user. Product: Base SAS Document: SAS DS2 Language Reference
PASSWORD= Table Option	PASSWORD="value" Specifies the password for the HDFS user. Product: Base SAS Document: SAS FedSQL Language Reference
PICKLIST= Table Option	PICKLIST="filename" Specifies the picklist to use for the bulk-loading operation. Product: Base SAS Document: SAS DS2 Language Reference
PICKLIST= Table Option	PICKLIST="filename" Specifies the picklist to use for the bulk-loading operation. Product: Base SAS Document: SAS FedSQL Language Reference
POINTOBS= Table Option	POINTOBS= YES \| NO Specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed. Product: Base SAS Document: SAS DS2 Language Reference
POINTOBS= Table Option	POINTOBS= YES \| NO Specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed. Product: Base SAS Document: SAS FedSQL Language Reference
POST_TABLE_OPTS= Table Option	POST_TABLE_OPTS="DBMS-SQL-options" Allows database-specific options to be placed after the table name in the DATA statement. Product: Base SAS Document: SAS DS2 Language Reference
POST_TABLE_OPTS= Table Option	POST_TABLE_OPTS="DBMS-SQL-options" Allows database-specific options to be placed after the table name in the CREATE TABLE statement. Product: Base SAS Document: SAS FedSQL Language Reference
PRE_TABLE_OPTS= Table Option	PRE_TABLE_OPTS="DBMS-SQL-options" Allows database-specific options to be placed before the table name in the DATA statement. Product: Base SAS Document: SAS DS2 Language Reference
PRE_TABLE_OPTS= Table Option	PRE_TABLE_OPTS="DBMS-SQL-options" Allows database-specific options to be placed before the table name in the CREATE TABLE statement. Product: Base SAS Document: SAS FedSQL Language Reference
PW= Table Option	PW= password \| key-value Assigns a READ, WRITE, and ALTER password to a SAS data set or an SPD Engine data set and enables access to the password-protected file. Specifies a key value for accessing an encrypted SPD Server table. Product: Base SAS Document: SAS DS2 Language Reference
PW= Table Option	PW= password \| key-value Assigns a READ, WRITE, and ALTER password to a SAS data set or an SPD Engine data set and enables access to the password-protected file. Specifies a key value for accessing an encrypted SPD Server table. Product: Base SAS Document: SAS FedSQL Language Reference
READ= Table Option	READ=read-password Assigns a READ password to a SAS file that prevents users from reading the file, unless they enter the password. Product: Base SAS Document: SAS DS2 Language Reference
READ= Table Option Table Option	READ= read-password Assigns a READ password to a SAS file that prevents users from reading the file, unless they enter the password. Product: Base SAS Document: SAS FedSQL Language Reference
READMODE= Table Option	READMODE=STANDARD \| STORAGE Specifies the method to use when moving data from Google BigQuery into SAS. Product: Base SAS Document: SAS DS2 Language Reference
READMODE= Table Option	READMODE=STANDARD \| STORAGE Specifies the method to use when moving data from Google BigQuery into SAS. Product: Base SAS Document: SAS FedSQL Language Reference
RENAME= Table Option	RENAME=(old-name { = \| AS } new-name [...old-name { = \| AS } new-name]) Changes the name of a column. Product: Base SAS Document: SAS DS2 Language Reference
REUSE= Table Option	REUSE= NO \| YES Specifies whether new rows can be written to freed space in a compressed SAS data set. Product: Base SAS Document: SAS DS2 Language Reference
REUSE= Table Option	REUSE= NO \| YES Specifies whether new rows can be written to freed space in a compressed SAS data set. Product: Base SAS Document: SAS FedSQL Language Reference
SCANSTRINGCOLUMNS= Table Option	SCANSTRINGCOLUMNS=NO \| YES Specifies whether to determine the maximum length of character columns in a database table or a query. Product: Base SAS Document: SAS DS2 Language Reference
SCANSTRINGCOLUMNS= Table Option	SCANSTRINGCOLUMNS=NO \| YES Specifies whether to determine the maximum length of character columns in a database table or a query. Product: Base SAS Document: SAS FedSQL Language Reference
STARTOBS= Table Option	STARTOBS= n Specifies the starting row number in a user-defined range of rows to be processed. Product: Base SAS Document: SAS DS2 Language Reference
STARTOBS= Table Option	STARTOBS= n Specifies the starting row number in a user-defined range of rows to be processed. Product: Base SAS Document: SAS FedSQL Language Reference
TABLE_TYPE= Table Option	TABLE_TYPE= [COLUMN \| GLOBAL \| GLOBAL TEMPORARY \| LOCAL \| LOCAL TEMPORARY \| ROW] Specifies the type of table storage FedSQL will use when creating tables in SAP HANA. Product: Base SAS Document: SAS DS2 Language Reference
TABLE_TYPE= Table Option	TABLE_TYPE= [COLUMN \| GLOBAL \| GLOBAL TEMPORARY \| LOCAL \| LOCAL TEMPORARY \| ROW] Specifies the type of table storage FedSQL will use when creating tables in SAP HANA. Product: Base SAS Document: SAS FedSQL Language Reference
TD_BUFFER_MODE= Table Option	TD_BUFFER_MODE= YES \| NO Specifies whether the LOAD method is used. Product: Base SAS Document: SAS DS2 Language Reference
TD_BUFFER_MODE= Table Option	TD_BUFFER_MODE= YES \| NO Specifies whether the LOAD method is used. Product: Base SAS Document: SAS FedSQL Language Reference
TD_CHECKPOINT= Table Option	TD_CHECKPOINT= number Specifies when the TPT operation issues a checkpoint or savepoint to the database. Product: Base SAS Document: SAS DS2 Language Reference
TD_CHECKPOINT= Table Option	TD_CHECKPOINT= number Specifies when the TPT operation issues a checkpoint or savepoint to the database. Product: Base SAS Document: SAS FedSQL Language Reference
TD_DATA_ENCRYPTION= Table Option	TD_DATA_ENCRYPTION= YES \| NO Activates data encryption. Product: Base SAS Document: SAS DS2 Language Reference
TD_DATA_ENCRYPTION= Table Option	TD_DATA_ENCRYPTION= YES \| NO Activates data encryption. Product: Base SAS Document: SAS FedSQL Language Reference
TD_DROP_ERROR_TABLE= Table Option	TD_DROP_ERROR_TABLE= YES \| NO Drops the log table at the end of the job, whether the job was completed successfully or not. Product: Base SAS Document: SAS DS2 Language Reference
TD_DROP_ERROR_TABLE= Table Option	TD_DROP_ERROR_TABLE= YES \| NO Drops the log table at the end of the job, whether the job was completed successfully or not. Product: Base SAS Document: SAS FedSQL Language Reference
TD_DROP_LOG_TABLE= Table Option	TD_DROP_LOG_TABLE= YES \| NO Drops the log table at the end of the job, whether the job completed successfully or not. Product: Base SAS Document: SAS DS2 Language Reference
TD_DROP_LOG_TABLE= Table Option	TD_DROP_LOG_TABLE= YES \| NO Drops the log table at the end of the job, whether the job completed successfully or not. Product: Base SAS Document: SAS FedSQL Language Reference
TD_DROP_WORK_TABLE= Table Option	TD_DROP_WORK_TABLE= YES \| NO Drops the work table at the end of the job, whether the job was completed successfully or not. Product: Base SAS Document: SAS DS2 Language Reference
TD_DROP_WORK_TABLE= Table Option	TD_DROP_WORK_TABLE= YES \| NO Drops the work table at the end of the job, whether the job was completed successfully or not. Product: Base SAS Document: SAS FedSQL Language Reference
TD_ERROR_LIMIT= Table Option	TD_ERROR_LIMIT= number-of-records Specifies the maximum number of records that can be stored in an error table. Product: Base SAS Document: SAS DS2 Language Reference
TD_ERROR_LIMIT= Table Option	TD_ERROR_LIMIT= number-of-records Specifies the maximum number of records that can be stored in an error table. Product: Base SAS Document: SAS FedSQL Language Reference
TD_ERROR_TABLE_1= Table Option	TD_ERROR_TABLE_1= name-of-table Specifies a name for the first error table. Product: Base SAS Document: SAS DS2 Language Reference
TD_ERROR_TABLE_1= Table Option	TD_ERROR_TABLE_1= name-of-table Specifies a name for the first error table. Product: Base SAS Document: SAS FedSQL Language Reference
TD_ERROR_TABLE_2= Table Option	TD_ERROR_TABLE_2= name-of-table Specifies a name for the second error table. Product: Base SAS Document: SAS DS2 Language Reference
TD_ERROR_TABLE_2= Table Option	TD_ERROR_TABLE_2= name-of-table Specifies a name for the second error table. Product: Base SAS Document: SAS FedSQL Language Reference
TD_LOG_MECH_DATA= Table Option	TD_LOG_MECH_DATA="string" Specifies additional data for the logon mechanism. Product: Base SAS Document: SAS DS2 Language Reference
TD_LOG_MECH_DATA= Table Option	TD_LOG_MECH_DATA="string" Specifies additional data for the logon mechanism. Product: Base SAS Document: SAS FedSQL Language Reference
TD_LOG_MECH_TYPE= Table Option	TD_LOG_MECH_TYPE= mechanism Specifies the logon mechanism for a bulk load. Product: Base SAS Document: SAS DS2 Language Reference
TD_LOG_MECH_TYPE= Table Option	TD_LOG_MECH_TYPE= mechanism Specifies the logon mechanism for a bulk load. Product: Base SAS Document: SAS FedSQL Language Reference
TD_LOG_TABLE= Table Option	TD_LOG_TABLE= name-of-table Specifies the name of the restart log table. Product: Base SAS Document: SAS DS2 Language Reference
TD_LOG_TABLE= Table Option	TD_LOG_TABLE= name-of-table Specifies the name of the restart log table. Product: Base SAS Document: SAS FedSQL Language Reference
TD_LOGDB= Table Option	TD_LOGDB= database-name Specifies the database where the TPT utility tables are created. Product: Base SAS Document: SAS DS2 Language Reference
TD_LOGDB= Table Option	TD_LOGDB= database-name Specifies the database where the TPT utility tables are created. Product: Base SAS Document: SAS FedSQL Language Reference
TD_MAX_SESSIONS= Table Option	TD_MAX_SESSIONS= integer Specifies the maximum number of logon sessions that TPT can acquire for a job. Product: Base SAS Document: SAS DS2 Language Reference
TD_MAX_SESSIONS= Table Option	TD_MAX_SESSIONS= integer Specifies the maximum number of logon sessions that TPT can acquire for a job. Product: Base SAS Document: SAS FedSQL Language Reference
TD_MIN_SESSIONS= Table Option	TD_MIN_SESSIONS= integer Specifies the minimum number of sessions for TPT to acquire before a job starts. Product: Base SAS Document: SAS DS2 Language Reference
TD_MIN_SESSIONS= Table Option	TD_MIN_SESSIONS= integer Specifies the minimum number of sessions for TPT to acquire before a job starts. Product: Base SAS Document: SAS FedSQL Language Reference
TD_NOTIFY_LEVEL= Table Option	TD_NOTIFY_LEVEL= level Specifies the level at which log events are recorded. Product: Base SAS Document: SAS DS2 Language Reference
TD_NOTIFY_LEVEL= Table Option	TD_NOTIFY_LEVEL= level Specifies the level at which log events are recorded. Product: Base SAS Document: SAS FedSQL Language Reference
TD_NOTIFY_METHOD= Table Option	TD_NOTIFY_METHOD= method Specifies the method for reporting events. Product: Base SAS Document: SAS DS2 Language Reference
TD_NOTIFY_METHOD= Table Option	TD_NOTIFY_METHOD= method Specifies the method for reporting events. Product: Base SAS Document: SAS FedSQL Language Reference
TD_NOTIFY_STRING= Table Option	TD_NOTIFY_STRING= string Defines a string that precedes all messages sent to the system log. Product: Base SAS Document: SAS DS2 Language Reference
TD_NOTIFY_STRING= Table Option	TD_NOTIFY_STRING= string Defines a string that precedes all messages sent to the system log. Product: Base SAS Document: SAS FedSQL Language Reference
TD_PACK= Table Option	TD_PACK= number Specifies the number of statements to pack into a multistatement request. Product: Base SAS Document: SAS DS2 Language Reference
TD_PACK= Table Option	TD_PACK= number Specifies the number of statements to pack into a multistatement request. Product: Base SAS Document: SAS FedSQL Language Reference
TD_PACK_MAXIMUM= Table Option	TD_PACK_MAXIMUM= YES \| NO Lets the Stream operator determine the pack factor for the current Stream job. Product: Base SAS Document: SAS DS2 Language Reference
TD_PACK_MAXIMUM= Table Option	TD_PACK_MAXIMUM= YES \| NO Lets the Stream operator determine the pack factor for the current Stream job. Product: Base SAS Document: SAS FedSQL Language Reference
TD_PAUSE_ACQ= Table Option	TD_PAUSE_ACQ= YES \| NO Forces a pause between the acquisition phase and the application phase of a load job. Product: Base SAS Document: SAS DS2 Language Reference
TD_PAUSE_ACQ= Table Option	TD_PAUSE_ACQ= YES \| NO Forces a pause between the acquisition phase and the application phase of a load job. Product: Base SAS Document: SAS FedSQL Language Reference
TD_SESSION_QUERY_BAND= Table Option	TD_SESSION_QUERY_BAND= string Passes a string of user-specified name=value pairs for use by the TPT session. Product: Base SAS Document: SAS DS2 Language Reference
TD_SESSION_QUERY_BAND= Table Option	TD_SESSION_QUERY_BAND= string Passes a string of user-specified name=value pairs for use by the TPT session. Product: Base SAS Document: SAS FedSQL Language Reference
TD_TENACITY_HOURS= Table Option	TD_TENACITY_HOURS= integer Specifies the amount of time the TPT operator continues trying to log on to the Teradata database. Product: Base SAS Document: SAS DS2 Language Reference
TD_TENACITY_HOURS= Table Option	TD_TENACITY_HOURS= integer Specifies the amount of time the TPT operator continues trying to log on to the Teradata database. Product: Base SAS Document: SAS FedSQL Language Reference
TD_TENACITY_SLEEP= Table Option	TD_TENACITY_SLEEP= integer Specifies the amount of time the TPT operator pauses, before retrying to log on to the Teradata database. Product: Base SAS Document: SAS DS2 Language Reference
TD_TENACITY_SLEEP= Table Option	TD_TENACITY_SLEEP= integer Specifies the amount of time the TPT operator pauses, before retrying to log on to the Teradata database. Product: Base SAS Document: SAS FedSQL Language Reference
TD_TPT_OPER= Table Option	TD_TPT_OPER= operator Specifies the load operator that is used by the Teradata Parallel Transporter. Product: Base SAS Document: SAS DS2 Language Reference
TD_TPT_OPER= Table Option	TD_TPT_OPER= operator Specifies the load operator that is used by the Teradata Parallel Transporter. Product: Base SAS Document: SAS FedSQL Language Reference
TD_TRACE_LEVEL=, TD_TRACE_LEVEL_INF= Table Options	TD_TRACE_LEVEL= trace-level Specifies the trace levels for driver tracing. TD_TRACE_LEVEL sets the primary trace level. TD_TRACE_LEVEL_INF sets the secondary trace level. Product: Base SAS Document: SAS DS2 Language Reference
TD_TRACE_LEVEL=, TD_TRACE_LEVEL_INF= Table Options	TD_TRACE_LEVEL= trace-level Specifies the trace levels for driver tracing. TD_TRACE_LEVEL sets the primary trace level. TD_TRACE_LEVEL_INF sets the secondary trace level. Product: Base SAS Document: SAS FedSQL Language Reference
TD_TRACE_OUTPUT= Table Option	TD_TRACE_OUTPUT= filename Specifies the name of the external file used for trace messages. Product: Base SAS Document: SAS DS2 Language Reference
TD_TRACE_OUTPUT= Table Option	TD_TRACE_OUTPUT= filename Specifies the name of the external file used for trace messages. Product: Base SAS Document: SAS FedSQL Language Reference
TD_UNICODE_PASSTHRU= Table Option	TD_UNICODE_PASSTHRU= YES \| NO Allows pass-through characters (PTCs) to be imported into and exported from Teradata. Product: Base SAS Document: SAS DS2 Language Reference
TD_UNICODE_PASSTHRU= Table Option	TD_UNICODE_PASSTHRU= YES \| NO Allows pass-through characters (PTCs) to be imported into and exported from Teradata. Product: Base SAS Document: SAS FedSQL Language Reference
TD_WORK_TABLE= Table Option	TD_WORK_TABLE= name-of-table Specifies a name for the TPT Work table. Product: Base SAS Document: SAS DS2 Language Reference
TD_WORK_TABLE= Table Option	TD_WORK_TABLE= name-of-table Specifies a name for the TPT Work table. Product: Base SAS Document: SAS FedSQL Language Reference
TD_WORKING_DB= Table Option	TD_WORKING_DB= database-name Specifies the database where the insert table is to be created. Product: Base SAS Document: SAS DS2 Language Reference
TD_WORKING_DB= Table Option	TD_WORKING_DB= database-name Specifies the database where the insert table is to be created. Product: Base SAS Document: SAS FedSQL Language Reference
THREADNUM= Table Option	THREADNUM= n Specifies the maximum number of I/O threads the SPD Engine can spawn for processing an SPD Engine data set. Product: Base SAS Document: SAS DS2 Language Reference
THREADNUM= Table Option	THREADNUM= n Specifies the maximum number of I/O threads the SPD Engine can spawn for processing an SPD Engine data set. Product: Base SAS Document: SAS FedSQL Language Reference
TYPE= Table Option	TYPE=data-set-type Specifies the data set type for a specially structured SAS data set. Product: Base SAS Document: SAS DS2 Language Reference
TYPE= Table Option	TYPE= data-set-type Specifies the data set type for a specially structured SAS data set. Product: Base SAS Document: SAS FedSQL Language Reference
UNIQUESAVE= Table Option	UNIQUESAVE= YES \| NO Specifies to save observations with nonunique key values (the rejected observations) to a separate data set when inserting observations into data sets with unique indexes. Product: Base SAS Document: SAS DS2 Language Reference
UNIQUESAVE= Table Option	UNIQUESAVE= YES \| NO Specifies to save observations with nonunique key values (the rejected observations) to a separate data set when inserting observations into data sets with unique indexes. Product: Base SAS Document: SAS FedSQL Language Reference
USER= Table Option	USER=HDFS-user Specifies the HDFS user name. Product: Base SAS Document: SAS DS2 Language Reference
USER= Table Option	USER=HDFS-user Specifies the HDFS user name. Product: Base SAS Document: SAS FedSQL Language Reference
WHERENOINDEX= Table Option	WHERENOINDEX= (name1 name2...) Specifies a list of indexes to exclude when making WHERE expression evaluations. Product: Base SAS Document: SAS DS2 Language Reference
WHERENOINDEX= Table Option	WHERENOINDEX= (name1 name2...) Specifies a list of indexes to exclude when making WHERE expression evaluations. Product: Base SAS Document: SAS FedSQL Language Reference
WRITE= Table Option	WRITE=write-password Assigns a WRITE password to a SAS file that prevents users from writing to a file, unless they enter the password. Product: Base SAS Document: SAS DS2 Language Reference
WRITE= Table Option Table Option	WRITE= write-password Assigns a WRITE password to a SAS file that prevents users from writing to the file or that enables access to a Write-protected file. Product: Base SAS Document: SAS FedSQL Language Reference

SAS Cloud Analytic Services

C L R

Name	Syntax and Description
COMPRESS= Table Option	COMPRESS=[TRUE \| FALSE] Specifies whether rows are compressed in a new output CAS table. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
LABEL= Table Option	LABEL=[ ' \| "]string[ ' \| "] Specifies a label for an output table. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
REPLACE= Table Option	REPLACE=[TRUE \| FALSE] Specifies to internally delete an existing table of the same name and create a replacement output table. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
REPLICATION= Table Option	REPLICATION= number specifies the number of copies of the table to make for fault tolerance. Product: SAS Cloud Analytic Services Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services

SAS Scalable Performance Data Server

A B C E I M N P S T U V W

Name	Syntax and Description
ASYNCINDEX= Table Option	ASYNCINDEX=NO \| YES When you are creating multiple indexes on an SPD Server table, specifies whether to create the indexes in parallel. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
BYNOEQUALS= Table Option	BYNOEQUALS=NO \| YES Specifies the output order of table rows with identical values for the BY column. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
BYSORT= Table Option	BYSORT=NO \| YES Specifies to perform an implicit automatic sort when SPD Server encounters a BY clause for a given table. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
COMPRESS= Table Option	COMPRESS=CHAR \| YES \| BINARY \| NO Compresses SPD Server tables on disk. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
ENCRYPT= Table Option	ENCRYPT=AES \| NO \| YES Encrypts SPD Server tables on disk. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
ENCRYPTKEY= Table Option	ENCRYPTKEY=key-value Specifies a key value to enable AES encryption and decryption. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
ENDOBS= Table Option	ENDOBS=n Specifies the end row number in a user-defined range for the processing of a given table. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
IOBLOCKSIZE= Table Option	IOBLOCKSIZE=n Specifies the number of rows in a block to be stored in or read from an SPD Server table. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
MINMAXVARLIST= Table Option	MINMAXVARLIST=(variable-name(s) ) Creates a list that documents the minimum and maximum values of specified columns. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
NETPACKSIZE= Table Option	NETPACKSIZE=size-of-packet Specifies the size of the SPD Server network data packet. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
NOINDEX= Table Option	NOINDEX=NO \| YES Specifies whether to use the table's indexes when processing WHERE clauses. NOINDEX= can also be used to disable index use for BY order determination. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
PARTSIZE= Table Option	PARTSIZE=n Specifies the size of an SPD Server table partition. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
SEGSIZE= Table Option	SEGSIZE=n Specifies the size of the segment for an index file associated with an SPD Server table. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
STARTOBS= Table Option	STARTOBS=n Specifies the start row number in a user-defined range for the processing of a given table. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
SYNCADD= Table Option	SYNCADD=NO \| YES Specifies to process one row at a time or multiple rows at a time when adding rows. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
THREADNUM= Table Option	THREADNUM=n Specifies the number of threads to be used for WHERE clause evaluations. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
UNIQUESAVE= Table Option	UNIQUESAVE=NO \| REP \| YES Specifies to save rows that contain duplicate values (which would be rejected) when appending or inserting data in tables with unique indexes. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
VERBOSE= Table Option	VERBOSE=NO \| YES Specifies whether the CONTENTS procedure output includes details about compressed blocks, data partition size, and indexes. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide
WHERENOINDEX= Table Option	WHERENOINDEX=(name(s) ) Specifies a list of indexes to exclude when making WHERE clause evaluations. Product: SAS Scalable Performance Data Server Document: SAS Scalable Performance Data Server: User’s Guide

Last updated: May 16, 2023