Table Options Listed Alphabetically
|
Name
|
Syntax and Description
|
|---|---|
|
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 Reference for SAS Viya Workbench
| |
|
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: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_ACCOUNTNAME=
account-name
Specifies the name of the account to use on the external storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_APPLICATIONID=
"string"
Specifies the application ID (a GUID string) for accessing the external storage
system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_AZURE_SAS=
value
Specifies the Azure shared access signature token value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_AZURE_TENANTID=
tenant-id
Specifies the tenant ID for connecting to a Microsoft Azure storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_COMPRESS=
YES | NO
Specifies whether to compress data files using the gzip format.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_DEFAULT_DIR=
host-specific-directory-path
Specifies the location where the bulk load facility creates intermediate files.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_DELETE_DATAFILE=
YES | NO
Specifies whether to delete intermediate files created by the bulk loading
facility.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
BL_DELETE_DATAFILE=
YES | NO
Specifies whether to delete intermediate files created by the bulk loading
facility.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_DELIMITER=
'single-ascii-character | octal-representation'
Overrides the default delimiter character for separating columns of data during
bulk loading.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_ERRORS=
number
Specifies that, after the indicated number of errors is received, the load should
stop.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_FILESYSTEM=
file-system-name
Specifies the name of the file system within the external storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_FOLDER=
file-path-and-folder
Specifies the folder or file path for the data in the external storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_INTERNAL_STAGE=stage-and-path
Specifies the internal stage and path for bulk loading to Snowflake.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_LOAD=
number-of-rows
Specifies that, after the indicated number of rows is loaded, the load should
stop.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_LOGFILE=
'log-file-name'
Specifies the filename for the bulk load log file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_NUM_DATAFILES=
value
Specifies the number of data files to create to contain the source data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_PARALLEL=
YES | NO
Specifies whether to perform a parallel bulk load.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_RECOVERABLE=
YES | NO
Specifies whether the LOAD process is recoverable.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_SKIP=
number-of-rows
Specifies to skip the indicated number of rows before starting the bulk
load.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_SKIP_INDEX_MAINTENANCE=
YES | NO
Specifies whether to perform index maintenance on the bulk
load.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_TIMEOUT=
value
Specifies the maximum completion time in seconds for a storage
task.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BL_USE_ESCAPE=
YES | NO
Specifies whether to escape a predefined set of special characters during bulk
loading or bulk retrieval.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
BUFNO=
n | nK | hexX | MIN | MAX
Specifies the number of buffers to be allocated
for processing a SAS data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
BUFSIZE=n | nK | nM | nG | hexX | MIN | MAX
Specifies the size of a permanent buffer page for
an output SAS data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BULKLOAD=
YES | NO
Determines whether SAS uses a DBMS facility to insert data into a DBMS table.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
BULKLOAD=
YES | NO
Determines whether SAS uses a DBMS facility to insert data into a DBMS table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
BULKOPTS=
(option< ...option>)
Provides a container for bulk-load options.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
COMPRESS=
NO | YES | CHAR | BINARY
Specifies how rows are compressed in a new output
data set or table.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
COMPRESS=
NO | YES | CHAR | BINARY
Specifies how rows are compressed in a new output
data set or table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses'
Allows DBMS-specific options to be added to the
CREATE INDEX statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses'
Allows DBMS-specific options to be added to the
CREATE INDEX statement.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
DBCREATE_TABLE_OPTS= 'DBMS-options'
Specifies DBMS-specific options to be added to the
DATA statement.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
DBCREATE_TABLE_OPTS= 'DBMS-SQL-clauses'
Allows database-specific options to be placed after
the CREATE TABLE statement in generated SQL code.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
ENCODING=encoding-value
Specifies the encoding to use when creating a SAS
data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
ENCRYPT==AES | AES2 | NO | YES
Specifies whether to encrypt an output SAS data
set.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
ENCRYPT= AES | AES2 | NO | YES
Specifies whether to encrypt an output SAS data
set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
ENCRYPTKEY=key-value
Specifies a key value for AES encryption.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
ENCRYPTKEY= <' | ">key-value <' | ">
Specifies a key value for AES and AES2 encryption.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
EXTENDOBSCOUNTER=YES | NO
Specifies whether to extend the maximum observation
count in a new output SAS data set.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
FETCH_NUMERIC_TYPE=FLOAT64 | NUMERIC
Specifies how to handle NUMERIC data from Google BigQuery.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
IDXNAME= index-name
Directs SAS to use a specific index to match the
conditions of a WHERE clause.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
IDXNAME= index-name
Directs SAS to use a specific index to match the
conditions of a WHERE clause.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
IDXWHERE=
YES | NO
Specifies whether SAS uses an index search or a
sequential search to match the conditions of a WHERE clause.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
IN=variable
Creates an integer variable that indicates whether
the table contributed data to the current row.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
KMS_PATH=”path-and-filename"
Specifies the location of a key file resource within
a project.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
LABEL='label'
Specifies a label for a table.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
LABEL= 'label '
Specifies a label for a table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
LOCATION='value'
Specifies the location of the data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
LOCKTABLE=SHARE | EXCLUSIVE
Places shared or exclusive locks on tables.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
LOCKTABLE= EXCLUSIVE | SHARE
Places shared or exclusive locks on tables.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
ORNUMERIC=YES | NO
Specifies how numbers read from or inserted into the Oracle NUMBER column are
treated.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
ORNUMERIC=YES | NO
Specifies how numbers read from or inserted into the Oracle NUMBER column are
treated.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
POINTOBS=
YES | NO
Specifies whether SAS creates compressed data sets
whose observations can be randomly accessed or sequentially accessed.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
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: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
READ= read-password
Assigns a READ password to a SAS file that prevents
users from reading the file, unless they enter the password.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
READMODE=STANDARD | STORAGE
Specifies the method to use when moving data from
Google BigQuery into SAS.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
READMODE=STANDARD | STORAGE
Specifies the method to use when moving data from
Google BigQuery into SAS.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RENAME=(old-name {
= | AS } new-name <...old-name {
= | AS } new-name>)
Changes the name of a column.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
REUSE=
NO | YES
Specifies whether new rows can be written to freed
space in a compressed SAS data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_AWS_CONFIG='path-and-file-name'
Specifies the location of the Amazon Web Services (AWS) configuration
file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_BUCKET='bucket-name'
Specifies the name of the AWS bucket to use when bulk loading data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_CREDENTIALS_FILE='path-and-file-name'
Specifies the AWS credentials file to use when bulk loading
data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_DEFAULT_DIR='directory-path'
Specifies where intermediate bulk-load files are created.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_DELETE_DATAFILE=TRUE | FALSE
Specifies whether to delete the data file or all files created by the
bulk-loading facility.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_KEY='key-value'
Specifies the Amazon Web Services access key that is used with key-based
access control. If you are using temporary token credentials, this is the temporary
access
key ID.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_REGION='region'
Specifies the AWS region for Amazon S3 data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_SECRET='secret-access-key'
Specifies the secret access key that is used to bulk load
data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
RS_TOKEN='token'
Specifies a temporary token that is associated with the temporary credentials
that you specify with the RS_KEY= and RS_SECRET= table options.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
SCANSTRINGCOLUMNS=NO | YES
Specifies whether to determine the maximum length
of character columns in a database table or a query.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
TYPE=data-set-type
Specifies the data set type for a specially structured SAS data
set.
Product: Base SAS
Document: SAS DS2 Reference for SAS Viya Workbench
| |
|
TYPE= data-set-type
Specifies the data set type for a specially structured
SAS data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
| |
|
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 Reference for SAS Viya Workbench
| |
|
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: SAS Federation Server
Document: SAS FedSQL Language Reference for SAS Viya Workbench
|
Last updated: June 5, 2026