Data Set Options Listed Alphabetically
|
Name
|
Syntax and Description
|
|---|---|
|
ACL=(column-name-1=(user-name-1... user-name-n)... column-name-n=(user-name-1... user-name-n))
Creates an Access Control List (ACL) for Read access to one or more columns in
a new output table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
ALTER=alter-password
Assigns an ALTER= password to a SAS file that prevents
users from replacing or deleting the file, and enables access to a
read- and write-protected file.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
AUTOCOMMIT=YES | NO
Determines whether the engine commits (saves) updates
as soon as you submit them.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
BINARY_BYTE_LIMIT=n
Specifies the maximum length for binary columns
that do not have a defined length.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_ACCOUNTNAME="account-name"
Specifies the name of the account to use on the
external storage system.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_API_BULKLOAD=YES | NO
Specifies to perform bulk loading using the Oracle Direct Path API instead of
the Oracle SQL*Loader utility.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_APPLICATIONID="value"
Specifies the application ID (a GUID string) for
accessing the external storage system.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_AWS_CONFIG_FILE=path-and-file-name
Specifies the location of the AWS configuration
file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_AWS_CREDENTIALS_FILE=path-and-file-name
Specifies the path to the credentials file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_AWS_PROFILE_NAME=profile-name
Specifies the AWS profile to use when there is more
than one profile in the AWS configuration file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_AZURE_SAS=value
Specifies the Azure shared access signature token value.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_BADFILE=path-and-file-name
Identifies a file that contains records that were rejected during bulk
loading.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_BUCKET='<bucket-name>'
Specifies the bucket name to use when bulk loading
or bulk unloading data files. The bucket name that you specify must
already exist.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_COMPRESS=YES | NO
Specifies whether to compress data files using the
gzip format.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_CONFIG='<path-and-file-name>'
Specifies the location of the optional configuration
file that the SAS communication layer uses to interact with the Amazon
S3 tool.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_CONTROL=path-and-control-file-name
Identifies the file that contains control statements.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DATAFILE=path-and-data-file-name
Identifies the file that contains DBMS data for
bulk loading.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DEFAULT_DIR='host-specific-directory-path'
Specifies where bulk loading creates all intermediate
files.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DELETE_DATAFILE=YES | NO
Specifies whether to delete only the data file (NO) or all files (YES) that the
SAS/ACCESS engine creates for the data source bulk-load utilty.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DELETE_ONLY_DATAFILE=YES | NO
Specifies whether to delete the data file that the SAS/ACCESS engine creates for
the DBMS bulk-load facility.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DELIMITER='any-single-character'
Specifies override of the default delimiter character
for separating columns of data during data transfer or retrieval during
bulk loading or unloading.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DIRECT_PATH=YES | NO
Specifies the Oracle SQL*Loader DIRECT option.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DISCARDFILE=path-and-discard-file-name
Identifies the file that contains records that were filtered from bulk loading
because they did not match the criteria as specified in the CONTROL file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_DNSSUFFIX="network-storage-host-name"
Specifies the network host name where the storage
system resides.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_ESCAPE='any-single-character' | 'OFF'
Specifies the single character to use for C escape
sequences.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_FILESYSTEM="file-system-name"
Specifies the name of the file system within the
external storage system.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_FOLDER="file-path-and-folder"
Specifies the folder or file path for the data in
the external storage system.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_FORMAT= CSV | TEXT
Specifies the format of the external or web table data, or interim staging
file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_FORMAT_OPT="option" | "option=value"
Specifies format options for loading CSV files.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_IAM_ASSUME_ROLE_ARN="value"
Specifies an Amazon Resource Name (ARN) that identifies
an IAM role.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_IAM_ASSUME_ROLE_NAME="value"
Specifies an AWS IAM role name that enables you to connect to an Amazon S3
environment.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_IAM_ROLE='role-value'
Specifies an optional Amazon Web Services IAM role to use for the COPY
command.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_IDENTITY="identity-value"
Specifies the authentication method for the COPY
command.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_INDEX_OPTIONS='any valid SQL*Loader Index option'
segment-name
Enables you to specify SQL*Loader Index options with bulk
loading.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_INTERNAL_STAGE=stage-and-path
Specifies the internal stage and path.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_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: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_LOAD_METHOD=INSERT
| APPEND
| REPLACE
| TRUNCATE
BL_LOAD_METHOD=APPEND
| REPLACE
| TRUNCATE
Specifies the method by which data is loaded into a table during bulk
loading.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_LOG="path-and-log-file-name"
Identifies a log file that contains information
for bulk loading, such as statistics and errors.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_LOGFILE=path-and-log-file-name
Identifies a log file that contains information
for bulk loading, such as statistics and errors.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_MAXERRORS=value
Specifies the maximum number of rejected rows that
are allowed in the load before the COPY command is canceled.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_NULL='/N' | empty-value
Specifies the string that represents a null value.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_NUM_DATAFILES=value
Specifies the number of data files to create for storing source data during bulk
loading or unloading operations.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_NUM_READ_THREADS=value
Specifies the number of threads to use for bulk
unloading from the DBMS into SAS.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_OPTIONS='option-1<, option-2<,..., option-N>>'
BL_OPTIONS='option-1=value-1 <,option-2=value-2 <... option-N=value-N>>'
BL_OPTIONS='option-1<, option-2<,..., option-N>>'
Passes options to the DBMS bulk-load facility, which
affects how it loads and processes data.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_PARFILE=<parameter-file>
Specifies a file that contains the SQL*Loader command-line
options.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_PRESERVE_BLANKS=YES | NO
Determines how the SQL*Loader handles requests to insert blank spaces into
CHAR/VARCHAR2 columns with the NOT NULL constraint.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_PSQL_PATH=path-name
Specifies the location of the PSQL executable file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_QUOTE='single 1-byte character'
Specifies the quotation character for CSV mode.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_RECOVERABLE=YES | NO
Determines whether the LOAD process is recoverable.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_REGION=region
Specifies the Amazon Web Services (AWS) region from
which data is being loaded.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_RETURN_WARNINGS_AS_ERRORS=YES | NO
Specifies whether SQL*Loader (bulk-load) warnings should be displayed in SAS
through the SYSERR macro as warnings or errors.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_SECRET=secret-access-key
Specifies the secret access key that is used to
bulk load data.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_SQLLDR_PATH=path-name
Specifies the location of the SQLLDR executable
file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_SUPPRESS_NULLIF=(_ALL_=YES | NO)
BL_SUPPRESS_NULLIF=(column-name-1=YES | NO)< ... column-name-N=YES | NO>)
Indicates whether to suppress the NULLIF clause for the specified columns to
increase performance when a table is created.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_TIMEOUT=value
Specifies the maximum completion time in seconds for a storage
task.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_TOKEN=temporary-token
Specifies a temporary token that is associated with
the temporary credentials that you specify with the BL_KEY= and BL_SECRET=
data set options.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_USE_ESCAPE=YES | NO
Specifies whether to escape a predefined set of
special characters during bulk loading.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_USE_LOG=YES | NO
Specifies whether to get reports on rejected rows
and the corresponding error file.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_USE_MANIFEST=YES | NO
Specifies whether to create a manifest file for S3.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_USE_PIPE=YES
| NO
Specifies whether to use a named pipe for data transfer.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BL_WRITEBUFF=value
Specifies the number of rows to buffer in memory before writing to your data
source.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BUFNO= n | nK | nM | nG | hexX | MIN | MAX
Specifies the number of buffers to be allocated
for processing a SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
BUFSIZE=n | nK | nM | nG | hexX | MAX
Specifies the size of a permanent buffer page for
an output SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
BULKLOAD=YES | NO
Loads rows of data as one unit.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
BULKUNLOAD=YES | NO
Rapidly retrieves (fetches) large number of rows from a data
set.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
CACHE_SIZE=n | nK | nM | nG
Specifies the buffer size in memory before writing data during table creation
(output).
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
CHAR_COLUMN_LIMIT=n
Specifies the maximum length for character columns
that do not have a defined length.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
CNTLLEV=LIB | MEM | REC
Specifies the level of shared access to a SAS data
set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
COLUMN_COMPRESS=(column-name-1=compression-type-1...column-name-n=compression-type-n)
Controls the compression for one or more columns in a new output table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
COMPRESS=NO | BROTLI | GZIP | LZ4 | LZ4_HADP | SNAPPY | YES | ZSTD
Controls the compression for a new output table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
COMPRESS=NO | YES | BINARY
Specifies whether observations are compressed or the compression method to use for
an output data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
CURSOR_TYPE=DYNAMIC | FORWARD_ONLY | KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only and updatable
cursors.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
CURSOR_TYPE=KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only cursors
and for cursors to be updated.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DATETIME2=YES | NO
Specifies the scale for the timestamp literal for
Microsoft SQL Server 2008 and the native Microsoft driver.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DB_ONE_CONNECT_PER_THREAD=YES | NO
Specifies whether to limit the number of connections
to the DBMS server for a threaded Read.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBCOMMIT=n
Causes an automatic COMMIT (a permanent writing
of data to the DBMS) after a specified number of rows are processed.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBCOMMIT=number-of-rows
Enables you to issue a commit statement automatically
after a specified number of rows have been processed.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBCONDITION="DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBCONDITION=SQL-query-clause
Specifies criteria for subsetting and ordering data.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBCREATE_TABLE_OPTS='DBMS-SQL-clauses'
Specifies DBMS-specific syntax to add to the end
of the CREATE TABLE statement.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBCREATE_TABLE_OPTS='SQL-clauses'
Specifies data source-specific syntax to add to
the CREATE TABLE statement.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBENCODING=12–byte
SAS encoding-value
Specifies the encoding character set to use in the
Microsoft Access database or in the Microsoft Excel workbook.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBFORCE=YES | NO
Specifies whether to force data truncation during table
creation.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBFORCE= YES | NO
Specifies whether to force the truncation of data
during insert processing.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBGEN_NAME=DBMS | SAS
Specifies how SAS automatically renames columns
(when they contain characters that SAS does not allow, such as $)
to valid SAS variable names.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBGEN_NAME=DBMS | SAS
Specifies whether to rename columns automatically
when they contain disallowed characters.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBINDEX=YES | NO | <’>index-name<’>
Detects and verifies that indexes exist on a DBMS
table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBINDEX=YES | NO | <’>index-name<’>
Detects and verifies that indexes exist on a DBMS
table.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBKEY=(<'> column-1<'> <... <'> column-n<'> > )
Specifies a key column to optimize DBMS retrieval.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBKEY=<('column-1' ... 'column-n')>
Improves performance for a join with a large source
table and a small SAS data set (specifies a column to use as an index).
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBLABEL=YES | NO
Specifies whether to use SAS variable labels or
SAS variable names as the DBMS column names during output processing.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBLABEL=YES | NO
Specifies whether to use SAS variable labels as
data source column names during output processing.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBLARGETABLE=YES
Designates which table is the larger table when
you are processing a join that involves tables from two different
types of databases.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBLINK=database-link
Specifies a link from your local database
to database objects on another server.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBMAX_TEXT=bytes
Specifies the maximum length, in bytes, of large object or long character data
that SAS reads from the DBMS.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBMAX_TEXT=integer
Determines the length, in bytes, of a very long
data source character data type that is read into SAS or written from
SAS when you are using a SAS/ACCESS engine.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBNULL=<(>column-name-1=YES | NO< column-name-2=YES | NO...><)>
DBNULL=_ALL_=YES | NO
Indicates whether NULL is a valid value for the
specified columns when a table is created.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBNULL=
(<column-name-1=YES | NO> <column-name-n=YES | NO> < _ALL_=YES | NO> ) Specifies whether NULL is a valid value for the
specified columns when a table is created.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBNULLKEYS=YES | NO
Specifies whether NULL values are allowed in key columns.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBNULLKEYS= YES | NO
Controls the format of the WHERE clause when you
use the DBKEY data set option.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBNULLWHERE=YES | NO
Specifies whether character columns in a WHERE clause
can contain NULL values.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBSASLABEL=COMPAT | NONE
Specifies how the engine returns column labels.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBSASLABEL=COMPAT | NONE
Specifies whether SAS/ACCESS saves the data source's
column names as SAS label names.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBSASTYPE=(column-name-1=<'> SAS-data-type<'>
<...column-name-n=<'> SAS-data-type<'> > ) Specifies data types to override the default SAS
data types during input processing.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBSASTYPE=(<column-name-1> =<SAS data-type> ...<column-name-n> =
<SAS data-type> ) Specifies data type(s) to override the default SAS
data type(s) during input processing of data.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DBSLICE=("WHERE-clause-1" "WHERE-clause-2"
<" WHERE-clause-3"...>)
DBSLICE=( <server=>"WHERE-clause-1"
<server=>
"WHERE-clause-2"
<<server=> "WHERE-clause-3"...>
)
Specifies user-supplied WHERE clauses to partition
a DBMS query for threaded Reads.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBSLICEPARM=NONE | THREADED_APPS | ALL
DBSLICEPARM= ( NONE | THREADED_APPS | ALL
<max-threads>
)
DBSLICEPARM= (
NONE | THREADED_APPS | ALL<, max-threads>
)
Controls the scope of DBMS threaded Reads and the
number of DBMS connections.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBTYPE=(column-name-1=<'>
DMBS-type<'>
<column-name-n=<'> DBMS-type<'> ...> ) Specifies a data type to use instead of the default
DBMS data type when SAS creates a DBMS table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
DBTYPE=(<column-name-1> =<data-source-type> ...
<column-name-1> =<data-source-type> ) Specifies a data type to use instead of the default
data source data type when SAS creates a data source table.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
DLDMGACTION=FAIL | ABORT | REPAIR | NOINDEX
Specifies the action to take when a SAS data set
in a SAS library is detected as damaged.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
DROP=variable(s)
For an input data set, excludes the specified variables
from processing; for an output data set, excludes the specified variables
from being written to the data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
ENCODING= ANY | ASCIIANY | EBCDICANY
| SESSION | encoding-value
Overrides the encoding to use for reading or writing
a SAS data set.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
| |
|
ERRLIMIT=integer
Specifies the number of errors after which SAS stops
processing and issues a rollback.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
ERRLIMIT=integer
Specifies the number of errors that are allowed
before SAS stops processing and issues a rollback.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
ESCAPE_BACKSLASH=YES
| NO
Specifies whether backslashes in literals are preserved during data copy
from a SAS data set to a table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with 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 Data Set Options for SAS Viya Workbench
| |
|
FETCH_NUMERIC_TYPE=FLOAT64 | NUMERIC
Specifies how to load NUMERIC data from Google BigQuery.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
FILECLOSE=DISP | LEAVE | REREAD | REWIND
Specifies how a tape is positioned when a SAS data
set is closed.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
FIRSTOBS=n | nK | nM | nG | hexX | MIN | MAX
Specifies the first observation that SAS processes
in a SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
GENMAX=number-of-generations
Requests generations for a new data set, modifies
the number of generations for an existing data set, and specifies
the maximum number of versions.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
GENNUM=integer
Specifies a particular generation of a SAS data
set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
IDXNAME=index-name
Directs SAS to use a specific index to match the
conditions of a WHERE expression.
Product: Base SAS
Document: SAS Data Set Options 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 expression.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
IGNORE_FEDSQL_OBJECTS=YES | NO
Specifies whether to ignore FedSQL objects in a query.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
IGNORE_READ_ONLY_COLUMNS=YES | NO
Specifies whether to ignore or include columns whose
data types are read-only when generating a SQL statement for inserts
or updates.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
IN=variable
Creates a Boolean variable that indicates whether
the data set contributed data to the current observation.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
INDEX=(index-specification <index-specification-2 ...> )
Defines an index for a new output SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
INSERT_SQL=YES | NO
Specifies the method that SAS uses to insert rows into a data
source.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
INSERT_SQL=YES | NO
Determines the method to use to insert rows into
a data source.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
INSERTBUFF=positive-integer
Specifies the number of rows in a single DBMS insert.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
INSERTBUFF=number-of-rows
Specifies the number of rows in a single insert.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
KEEP=variable(s)
For an input data set, specifies the variables to
process; for an output data set, specifies the variables to write
to the data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
KEYSET_SIZE=number-of-rows
Specifies the number of rows in the cursor that
the keyset drives.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
KMS_PATH=path-and-filename
Specifies the location of a key file resource within a
project.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
MODE=STANDARD | PERFORMANCE
Specifies whether to enable multiple performance-related
options.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
NULLCHAR=SAS | YES | NO
Indicates how missing SAS character values are handled
during insert, update, DBINDEX=, and DBKEY= processing.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
NULLCHAR=YES | NO
Indicates how SAS character missing values are handled
during insert, update, and DBKEY= processing.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
NULLCHARVAL='character-string'
Specifies the character string that replaces missing
SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
NULLCHARVAL=<'character-string'>
Defines the character string that replaces SAS character
missing values during insert, update, and DBKEY= processing.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
OBS= n | nK | nM | nG | nT | hexX | MIN | MAX
Specifies the last observation that SAS processes
in a data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
OBSBUF=n
Determines the size of the view buffer for processing
a DATA step view.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
OR_IDENTITY_COLS=(column-name-1='user-sequence-1'
<column-name-2='user-sequence-2' ... column-name-n='user-sequence-n'>) specifies columns to be used to simulate an identity
column.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
OR_PARTITION=name
of a partition in a partitioned Oracle table
Allows reading, updating, and deleting from a particular
partition in a partitioned table, also inserting and bulk loading
into a particular partition in a partitioned table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
OR_UPD_NOWHERE=YES | NO
Specifies whether SAS uses an extra WHERE clause
when updating rows with no locking.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
ORHINTS='Oracle-hint'
Specifies Oracle hints to pass to Oracle from a
SAS statement or SQL procedure.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
OUTREP=SESSION | format
Specifies the data representation for the output
SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
OUTREP= format
Specifies the data representation for the output
SAS data set.
Product: Base SAS
Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
| |
|
PARTITION_BY=(column-name-1<...column-name-n>)
Specifies one or more columns that determine a table's
partitions.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
PARTITION_TYPE=DIRECTORY | FILENAME | HIVE
Specifies the type of partitioning for a table.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
PG_IDENTITY_COLS=(column-name="nextval('sequence-name')"
< ... column-nameN="nextval('sequence-nameN')">) Specifies that sequencing is being applied to one
or more columns.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with 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 Data Set Options for SAS Viya Workbench
| |
|
POST_COLUMN_OPTS="DBMS-SQL-option-1<, ... DBMS-SQL-option-n>"
Adds database-specific options after the final column definition in a CREATE
TABLE statement.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
POST_DML_STMT_OPTS=value
Specifies text to append to an INSERT, UPDATE, or
DELETE statement.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
POST_STMT_OPTS='DBMS-SQL-options'
Allows additional database-specific options to be
placed after the CREATE TABLE statement in generated SQL code.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
POST_TABLE_OPTS=DBMS-SQL-options
Allows additional database-specific options to be
placed after the table name in a CREATE TABLE statement.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
PRE_STMT_OPTS=DBMS-SQL-options
Allows additional database-specific options to be
placed before a CREATE TABLE statement.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
PRE_TABLE_OPTS=DBMS-SQL-options
allows additional database-specific options to be
placed before the table name in a CREATE TABLE statement.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
PRESERVE_COL_NAMES=
YES | NO
Preserves spaces, special characters, and case sensitivity
in DBMS column names when you create DBMS tables.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
PW=password
Assigns a READ, WRITE, and ALTER password to a SAS
data set, and enables access to a password-protected SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
PWD=password
Specifies the user's password for Access Control Lists (ACLs) in Parquet
files.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
PWREQ=YES | NO
Specifies whether to display a password window.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
QUALIFIER=<qualifier-name>
Specifies the qualifier to use when you are reading
database objects, such as DBMS tables and views.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
QUERY_TAG="value"
Specifies an optional string that you can use to tag queries to your data
source.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
QUERY_TIMEOUT=number-of-seconds
Specifies the number of seconds of inactivity to
wait before canceling a query.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with 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 Data Set Options for SAS Viya Workbench
| |
|
READ_ISOLATION_LEVEL=DBMS-specific-value
Specifies which level of read isolation locking
to use when you are reading data.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
READ_LOCK_TYPE=ROW | TABLE | NOLOCK
Specifies how data in a DBMS table is locked during
a read transaction.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
READ_MODE=BULKUNLOAD | STANDARD | STORAGE
Specifies the method to use to move data into SAS.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
READBUFF=integer
Specifies the number of rows of DBMS data to read
into the buffer.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
READBUFF=<number-of-rows>
Specifies the number of rows of data to read into
the buffer.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
RENAME=(old-variable-name-1=new-variable-name-1
<old-variable-name-2=new-variable-name-2 ...>
)
Changes the name of a variable.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
REPEMPTY=YES | NO
Specifies whether a new, empty data set can overwrite
an existing SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
REPLACE=NO | YES
Specifies whether a new database table can overwrite an existing database
table of the same name.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
REPLACE=NO | YES
Specifies whether a new SAS data set that contains
data can overwrite an existing data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
REUSE=NO | YES
Specifies whether new observations can be written
to available space in compressed SAS data sets.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
ROLE=FACT | DIMENSION Identifies the fact table for a star schema join.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
SAS_CHAR_COLUMN_DEFAULT=STRING
Specifies that all SAS character columns be written as logical type STRING
.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
SASDATEFMT=(DBMS-date-col-1='SAS-date-format'
<DBMS-date-col-2='SAS-date-format-2'...>) Changes the SAS date format of a DBMS column.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
SASDATEFMT=(<data-source-date-column-1> =<SAS date-format> ...
<data-source-date-column-n> =<SAS date-format> ) Changes the SAS date format of a data source column.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
| |
|
SCANSTRINGCOLUMNS=YES | NO
Specifies whether to determine the maximum length of VARCHAR or large type columns
in a database table or query.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
SCHEMA=schema-name
Specifies the schema to use when accessing tables
and views in a database.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
SORTEDBY=by-clause </ collate-name> | _NULL_
Specifies how a data set is currently sorted.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
SPILL=YES | NO
Specifies whether to create a spill file for non-sequential
processing of a DATA step view.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
SUB_CHAR=value
Specifies a substitution character to use in place
of any invalid characters that cannot be represented in the SAS session
encoding.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
TIMEOUTSECONDS=n
Specifies the client inactivity time-out interval in seconds. If SAS stops
transferring data to the server, the server starts the inactivity timer for the specified
duration
and cancels the request if SAS does not resume data transfer.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
TOBSNO=n
Specifies the number of observations to send in a client-server
transfer.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
TRANSCODE_FAIL=ERROR | WARN | SILENT
Specifies how the engine handles transcoding errors.
Product: Base SAS
Document: SAS Data Set Options 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 Data Set Options for SAS Viya Workbench
| |
|
UPDATE_ISOLATION_LEVEL=DBMS-specific-value
Specifies the degree of isolation of the current
application process from other concurrently running application processes.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
UPDATE_LOCK_TYPE=ROW | TABLE | NOLOCK
Specifies how data in a DBMS table is locked during
an update transaction.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
UPDATE_SQL=YES | NO
Determines which method to use to update and delete
rows in a data source.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
UPDATEBUFF=positive-integer
Specifies the number of rows that are processed
in a single DBMS Update or Delete operation.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
USE_PIPELINE=NO | YES
Enables pipeline read functionality for Amazon Redshift.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
USEDIRECTIO=YES | NO
Turns on direct file I/O for a library that contains the file to which the
ENABLEDIRECTIO option has been applied.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
USER=name
Specifies a user's name for Access Control Lists (ACLs) in Parquet
files.
Product: Accessing External Data Sources
Document: Accessing External Data Sources with SAS®Viya Workbench
| |
|
WHERE=(where-expression-1 <logical-operator
where-expression-2> )
Specifies specific conditions to use to select observations
from a SAS data set.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
WHEREUP=NO | YES
Specifies whether to evaluate new observations and
modified observations against a WHERE expression.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
| |
|
WRITE=write-password
Assigns a WRITE= password to a SAS data set that
prevents users from writing to a file, unless the users enter the
password.
Product: Base SAS
Document: SAS Data Set Options for SAS Viya Workbench
|
Last updated: September 24, 2026