Data Set Options Listed Alphabetically
|
Name
|
Syntax and Description
|
|---|---|
|
ACCELWHERE=NO | YES
Determines whether WHERE processing is optimized
by data subsetting being performed in the Hadoop cluster.
Product: Base SAS
Document: SAS SPD Engine: Storing Data in the Hadoop Distributed File System
| |
|
ADDROWID=<YES | NO>
Adds a column to the output data set with the name
"_ROWID_" that increments in numeric value with each row.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ALIGN=YES | NO
specifies variable alignment.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
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: Reference
| |
|
ANALYZE=YES | NO
Lets SAS improve performance when a single Hive
store table is queried.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
APPEND=YES | NO | FORCE
Specifies whether to append rows from the DATA step
and the PROC step output to the in-memory table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ASYNCINDEX=YES | NO
Specifies to create indexes in parallel when creating
multiple indexes on an SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
ATTRIBUTE=attribute-name
Specifies the attribute to use for retrieving elements.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
AUTOCOMMIT=YES | NO
Specifies whether to enable the DBMS autocommit
capability.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BATCH= Y | N
Specifies whether SAS uses SAP batch jobs for data
extracts.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
BL_ACCOUNTNAME="account-name"
Specifies the name of the account to use on the
external storage system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_ALLOW_READ_ACCESS=YES | NO
Specifies that the original table data is still
visible to readers during bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_ALLOW_WRITE_ACCESS=YES | NO
Specifies that table data is still accessible to
readers and writers while import is in progress.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_API_BULKLOAD=YES | NO
Specifies to perform bulk loading using the Oracle
Direct Path API instead of the Oracle SQL*Loader utility.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_APPLICATIONID="value"
Specifies the application ID (a GUID string) for
accessing the external storage system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_AWS_CONFIG_FILE=path-and-file-name
Specifies the location of the AWS configuration
file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_AWS_CREDENTIALS_FILE=path-and-file-name
Specifies the path to the credentials file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_BADFILE=path-and-file-name
Identifies a file that contains records that were
rejected during bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_CODEPAGE=numeric-code-page-ID
Identifies the code page that the DBMS engine uses
to convert SAS character data to the current database code page during
bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_COMPRESS=YES | NO
Specifies whether to compress data files using the
gzip format.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_CONTROL=path-and-control-file-name
BL_CONTROL=path-and-data-file-name
Identifies the file that contains control statements.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_COPY_LOCATION=path-name
Specifies the directory to which DB2 saves a copy
of the loaded data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_CPU_PARALLELISM=number of processes or threads
Specifies the number of processes or threads to
use when building table objects.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DATAFILE=path-and-data-file-name
Identifies the file that contains DBMS data for
bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DATAFILE=path-and-data-file-name
Identifies the file that contains control statements.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DATAFILE_EXISTS=YES | NO
Lets you load a table from an existing data set.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DEFAULT_DIR='host-specific-directory-path'
Specifies where bulk loading creates all intermediate
files.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DELETE_DATAFILE=YES | NO
Specifies whether to delete only the data file or
all files that the SAS/ACCESS engine creates for the DBMS bulk-load
facility.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DIRECT_PATH=YES | NO
Specifies the Oracle SQL*Loader DIRECT option.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DISK_PARALLELISM=number-of-processes-or-threads
Specifies the number of processes or threads to
use when writing data to disk.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DNSSUFFIX="network-storage-host-name"
Specifies the network host name where the storage
system resides.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_ENCKEY=encryption-key-name
Specifies the name of the encryption key to use
when you access an Amazon S3 environment.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_ENCODING=character-set-encoding
Specifies the character set encoding to use for
the external table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_ESCAPE='any-single-character' | 'OFF'
Specifies the single character to use for C escape
sequences.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_EXCEPTION=exception-table-name
Specifies the exception table into which rows in
error are copied.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_EXECUTE_CMD=command | script
Specifies the operating system command for segment
instances to run.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_EXECUTE_LOCATION=ALL
BL_EXECUTE_LOCATION=MASTER
BL_EXECUTE_LOCATION=HOST [segment-host], number-of-segments
BL_EXECUTE_LOCATION=SEGMENT segmentID
Specifies which segment instances runs the given
command.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_EXTERNAL_WEB=YES | NO
Specifies whether the external data set accesses
a dynamic data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FILESYSTEM="file-system-name"
Specifies the name of the file system within the
external storage system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FOLDER="file-path-and-folder"
Specifies the folder or file path for the data in
the external storage system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FORCE_NOT_NULL=YES | NO
Specifies how to process CSV column values.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FORMAT=TEXT | CSV
Specifies the format of the external or web table
data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_HEADER=YES | NO
Indicates whether to skip or load the first record
in the input data file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_HOST='hostname'
[Impala]
BL_HOST='localhost'
[Greenplum]
Specifies the host name or IP address of the server
where the external data file is stored.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_IAM_ROLE='role-value'
Specifies an optional Amazon Web Services IAM role
to use for the COPY command.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_IDENTITY="identity-value"
Specifies the authentication method for the COPY
command.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_INDEX_OPTIONS=any valid SQL*Loader Index option segment-name
Lets you specify SQL*Loader Index options with bulk
loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_INDEXING_MODE=AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED
Indicates which scheme the DB2 load utility should
use for index maintenance.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_INTERNAL_STAGE=stage-and-path
Specifies the internal stage and path.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_LOAD_METHOD=INSERT | APPEND | REPLACE | TRUNCATE
BL_LOAD_METHOD=APPEND | REPLACE | TRUNCATE
Specifies the method by which data is loaded into
an Oracle or PostgreSQL table during bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_LOAD_REPLACE=YES | NO
Specifies whether DB2 appends or replaces rows during
bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_LOCATION=http://file-location
Specifies the location of a file on a web server
for segment hosts to access.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_LOG=path-and-log-file-name
Identifies a log file that contains information
for bulk loading, such as statistics and errors.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_LOGFILE=path-and-log-file-name
Identifies a log file that contains information
for bulk loading, such as statistics and errors.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_MAXERRORS=value
Specifies the maximum number of rejected rows that
are allowed in the load before the COPY command is canceled.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_METHOD=CLILOAD | IMPORT | LOAD
Specifies the bulk-loading method to use for DB2.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_NULL='/N' | empty-value
Specifies the string that represents a null value.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_NUM_DATAFILES=value
Specifies the number of data files to create to
contain the source data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_NUM_READ_THREADS=value
Specifies the number of threads to use for bulk
unloading from the DBMS into SAS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
value-1<,option-2 value-2<... option-N
value-N>>'
Passes options to the DBMS bulk-load facility, which
affects how it loads and processes data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PARFILE=<parse-file>
Creates a file that contains the SQL*Loader command-line
options.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PORT=port
Specifies the port number to use.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PORT_MAX=integer
Specifies the highest available port number for
concurrent uploads.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PORT_MIN=integer
Specifies the lowest available port number for concurrent
uploads.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PROTOCOL=gpfdist | file | http
Specifies the protocol to use.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PSQL_PATH=path-name
Specifies the location of the PSQL executable file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_QUOTE='single 1-byte character'
Specifies the quotation character for CSV mode.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_RECOVERABLE=YES | NO
Determines whether the LOAD process is recoverable.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_REGION=region
Specifies the Amazon Web Services (AWS) region from
which data is being loaded.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_REJECT_LIMIT=number
Specifies the reject limit count.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_REJECT_TYPE=ROWS | PERCENT
Indicates whether the reject limit count is a number
of rows or a percentage of total rows.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_REMOTE_FILE=path-name-and-base-file-name
Specifies the base file name and location of DB2
LOAD temporary files.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_SECRET=secret-access-key
Specifies the secret access key that is used to
bulk load data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_SERVER_DATAFILE=path-and-data-file-name
Specifies the name and location of the data file
that the DBMS server instance sees.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_TIMEOUT=value
Specifies the maximum completion time for a storage
task, in seconds.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_ESCAPE=YES | NO
Specifies whether to escape a predefined set of
special characters for Amazon Redshift during bulk loading. These
special characters include the backslash (‘\’), newline
(‘\n’), and return (‘\r’). If you have
specified a value for BL_DELIMITER=, that value is also treated as
an escape character.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_LOG=YES | NO
Specifies whether to get reports on rejected rows
and the corresponding error file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_MANIFEST=YES | NO
Specifies whether to create a manifest file for
S3. By default, SAS/ACCESS Interface to Amazon Redshift creates a
manifest file that specifies all the data files that were used during
a bulk-loading operation.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_PIPE=YES | NO
Specifies whether to use a named pipe for data transfer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_SSL=YES | NO
Specifies whether to use TLS encryption for connections
to Amazon S3.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_WARNING_COUNT=warning-count
Specifies the maximum number of row warnings to
allow before the load fails.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_YB_PATH=<'>path<'>
Specifies the path to the Yellowbrick ybload and
ybunload tools.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BOUNDARY=INSIDE | OUTSIDE | INTERPOLATED
Specifies the boundary type to use to retrieve PI
Point time series data values.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
BUFFERS=number-of-shared-memory-buffers
Specifies the number of shared memory buffers to
use for transferring data from SAS to Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
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: Reference
| |
|
BULK_BUFFER=numeric-value
Specifies the number of bulk rows that the SAS/ACCESS
engine can buffer for output.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BULKLOAD=YES | NO
Loads rows of data as one unit.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BULKUNLOAD=YES | NO
Rapidly retrieves (fetches) large number of rows
from a data set.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BYNOEQUALS=YES | NO
Specifies whether the output order of data set observations
that have identical values for the BY variable is guaranteed to be
in the data set order.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
BYSORT=YES | NO
Specifies the SPD Engine to perform an automatic
sort when it encounters a BY statement.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
CALCULATION_BASIS=method
Specifies the method to determine the number of
data points to use when calculating summary statistics.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
CASLIB=caslib-reference-name
Specifies the name of the caslib to use for engine
operations for the table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
CAST=YES | NO
Specifies whether SAS or the Teradata DBMS server
should perform data conversions.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CAST_OVERHEAD_MAXPERCENT=<n>
Specifies the overhead limit for data conversions
to perform in Teradata instead of SAS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CATEGORY=category-name
Specifies the category name to use as a filter when
you retrieve observations.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
CHAR_AS_BINARY=YES | NO
Specifies whether to fetch all character columns
as binary values when reading data from DB2.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CHILD=ALL | NO | IMMEDIATE | LEAF
Specifies the retrieval behavior when an engine
retrieves elements for the target element.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
CNTLLEV=LIB | MEM | REC
Specifies the level of shared access to a SAS data
set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
COLUMN_DELIMITER=single-character
Specifies the single character to use as a column
(field) delimiter.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
COMPRESS=YES | NO
Requests that the CAS table is compressed.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
COMPRESS=NO | CHAR | BINARY
Specifies to compress SPD Engine data sets on disk
as they are being created.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
COMPRESS=NO | YES | CHAR | BINARY
Specifies how observations are compressed in a new
output SAS data set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
COPIES=integer
Specifies the number of copies for a redundant
table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
COUNT=integer
For PI System Data Archive, specifies the number
of intervals to display in your data. For PI System Asset Framework,
specifies the number of data values to retrieve.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
CURSOR_TYPE=DYNAMIC | FORWARD_ONLY | KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only and updatable
cursors.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DATALIMIT=integer | integerK | integerM | integerG | ALL
Specifies the maximum number of bytes of data that
can be transferred between the CAS server and SAS during a single-table
read.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
DATETIME2=YES | NO
Specifies the scale for the timestamp literal for
Microsoft SQL Server 2008 and the native Microsoft driver.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DB_ONE_CONNECT_PER_THREAD=YES | NO
Specifies whether to limit the number of connections
to the DBMS server for a threaded Read.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
DBCOMMIT=n
Causes an automatic COMMIT (a permanent writing
of data to the DBMS) after a specified number of rows are processed.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCONDITION= "DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBCONDITION="DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
DBCONDITION="DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCONSTRAINT='DBMS-SQL-clauses'
Provides table-level definitions to specify when
a table is created.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCREATE_TABLE_EXTERNAL=YES | NO
Specifies the type of table to create and how associated
data files are handled.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCREATE_TABLE_LOCATION='path'
Identifies the HDFS location of the root directory
for storing table data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
DBCREATE_TABLE_OPTS='DBMS-SQL-clauses'
Specifies DBMS-specific syntax to add to the end
of the CREATE TABLE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
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
| |
|
DBFORCE=YES | NO
Specifies whether to force data truncation during
insert processing.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBGEN_NAME=DBMS | SAS
Specifies how SAS automatically renames columns
to valid SAS variable names when those column names contain characters
that SAS does not allow.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
DBINDEX=YES | NO | <’>index-name<’>
Detects and verifies that indexes exist on a DBMS
table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBKEY= (<'>column-1<'> <...
<'>column-n<'>>)
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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
| |
|
DBKEY=(<'> column-1<'> <… <'> column-n<'> > )
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
DBLABEL=YES | NO
Specifies whether to use SAS variable labels or
SAS variable names as the DBMS column names during output processing.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBLARGETABLE=YES
Designates which is the larger table when you process
a join of tables from two different types of databases.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
DBLINK=database-link
Specifies a link from your local database to database
objects on another server [Oracle]. Specifies a link from your default
database to another database on the server to which you are connected
[SAP ASE].
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBMASTER=YES
Designates which table is the larger table when
you are processing a join that involves tables from two different
types of databases.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBMAX_TEXT=number-of-bytes
Specifies the maximum number of bytes to allocate
for character columns.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
DBMAX_TEXT=integer
Determines the length of very large DBMS character
data types, such as BLOB or CLOB, that are read into SAS or written
from SAS when you are using a SAS/ACCESS engine.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
DBNULLKEYS=YES | NO
Controls the format of the WHERE clause with regard
to NULL values when you use the DBKEY= data set option.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBNULLWHERE=YES | NO
Specifies whether character columns in a WHERE clause
can contain NULL values.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBSASLABEL=COMPAT | DBMS | NONE
Specifies how the engine returns column labels.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
DBSASLABEL=COMPAT | DBMS | NONE
Specifies how the engine returns column labels.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBSASTYPE=(column-name-1=<'>SAS-data-type-1<'>
<column-name-2=<'>SAS-data-type-2<'> ...> )
Specifies an alternate data type that overrides
the default SAS data type when loading data.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBSASTYPE=(column-name-1=<'>SAS-data-type<'> <...column-name-n=<'>SAS-data-type<'> >)
Specifies data types that override the default SAS
data types during input processing.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBSLICE=("WHERE-clause-1"
"WHERE-clause-2" <…" WHERE-clause-n">)
DBSLICE=(<server=> "WHERE-clause-1" <server=> "
WHERE-clause-2" < … <server=> " WHERE-clause-n"> ) Specifies user-supplied WHERE clauses to partition
a DBMS query for threaded Reads.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DISTRIBUTE_ON='column-1 <…,column-n>' | RANDOM
Specifies one or more column names to use in the
DISTRIBUTE ON clause of the CREATE TABLE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DISTRIBUTED_BY='column-1 <…,column-n>'
| DISTRIBUTED
RANDOMLY
Uses one or multiple columns to distribute table
rows across database segments.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
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: Reference
| |
|
DUPLICATE=YES | NO
Specifies whether the output table in the SAS Cloud Analytic Services
is duplicated on all nodes.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
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 Guide
| |
|
ENCRYPT= AES | NO | YES
Specifies whether to encrypt an output SPD Engine
data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
ENCRYPT=AES | AES2 | NO | YES
Specifies whether to encrypt an output SAS data
set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
ENCRYPTKEY="key-value"
Specifies a key value for AES encryption.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
ENCRYPTKEY=key-value
Specifies a key value for Advanced
Encryption Standard (AES) encryption.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
END="end-time"
Specifies the timestamp of the last tag value to
read in the form of a PI System timestamp string.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
ENDOBS=n
Specifies the end observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
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
| |
|
ERRLIMIT=integer
Specifies the number of errors after which SAS stops
processing and issues a rollback.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ESCAPE_BACKSLASH=YES | NO
Specifies whether backslashes in literals are preserved
during data copy from a SAS data set to a table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
FASTEXPORT= YES | NO
Specifies whether the SAS/ACCESS engine uses the
TPT API to read data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
FASTLOAD YES | NO
Enables you to specify whether this is to be a FASTLOAD
or not.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
FETCH_IDENTITY=YES | NO
Returns the value of the last inserted identity
value.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
FILTER="filter-expression"
Specifies filter expression that is used to limit
the records that are read.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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: Reference
| |
|
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: Reference
| |
|
GENNUM=integer
Specifies a particular generation of a SAS data
set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
GUID=element-ID
Specifies the element ID to use for retrieving an
element.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
HIDEFLAGS=YES | NO
Specifies whether the columns Questionable, Annotated,
and Substituted are hidden.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
HIDEOPTVARS=YES | NO
Specifies whether to exclude nonessential variables
in the data set.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
IDXBY=YES | NO
Specifies whether to use an index when processing
a BY statement in the SPD Engine.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
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: Reference
| |
|
IDXWHERE=YES | NO
Specifies whether to use an index when processing
a WHERE expression in the SPD Engine.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
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: Reference
| |
|
IGNORE_READ_ONLY_COLUMNS=YES | NO
Specifies whether to ignore or include columns whose
data types are read-only when generating an SQL statement for inserts
or updates.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
IN='database-name.tablespace-name' | database-name’
Lets you specify the database or tablespace in which
you want to create a new table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
INDEX=(index-specification <index-specification-2 ...> )
Defines an index for a new output SAS data set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
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
| |
|
INSERT_SQL=YES | NO
Determines the method to use to insert rows into
a data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
INSERTBUFF=positive-integer
Specifies the number of rows in a single DBMS insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
INTERVAL="interval-length"
Specifies the length of the time interval to use
when displaying data.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
IOBLOCKSIZE=n
Specifies the size in bytes of a block of observations
to be used in an I/O operation.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
IOBLOCKSIZE=n
Specifies a size in bytes of a block of observations
to be used in an I/O operation.
Product: Base SAS
Document: SAS SPD Engine: Storing Data in the Hadoop Distributed File System
| |
|
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: Reference
| |
|
KEYSET_SIZE=number-of-rows
Specifies the number of rows in the cursor that
the keyset drives.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LABEL=<'>label<'>
Specifies that a SAS variable label is used as the
output DBMS column name.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
LISTFILES=YES | NO
Specifies whether the CONTENTS procedure lists the
complete pathnames of all of the component files of an SPD Engine
data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
MAX=value
Specifies the maximum value to read from the Value
column.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
MAXTABLEMEM=integer | integerK | integerM | integerG
Specifies the maximum amount of memory, in bytes,
to allocate for an in-memory table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
MAXTABLEMEM=integer | integerK | integerM | integerG
Specifies the maximum amount of memory in bytes
that each thread should allocate for in-memory blocks before converting
to a memory-mapped file.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
MBUFSIZE=size-of-shared-memory-buffers
Specifies the size of the shared memory buffers
to use for transferring data from SAS to Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MIN=value
Specifies the minimal value to read from the Value
column.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
MIXED=YES | NO
Specifies whether to merge data sets with different
data types for Value with the Picomp virtual table.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
ML_CHECKPOINT=checkpoint-rate
Specifies the interval between checkpoint operations
in minutes.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ML_ERROR1=temporary-table-name
Specifies the name of a temporary table that MultiLoad
uses to track errors that were generated during the acquisition phase
of bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ML_ERROR2=temporary-table-name
Specifies the name of a temporary table that MultiLoad
uses to track errors that were generated during the application phase
of bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ML_LOG=prefix-for-MultiLoad-temporary-tables
Specifies a prefix for the names of the temporary
tables that MultiLoad uses during a bulk-loading operation.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ML_RESTART=temporary-table-name
Specifies the name of a temporary table that MultiLoad
uses to track checkpoint information.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ML_WORK=temporary-table-name
Specifies the name of a temporary table that MultiLoad
uses to store intermediate data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MODEL=ARCHIVE | COUNT | INTERPOLATE | PLOT
Specifies the data model to use to retrieve time
series data values. This setting applies to the attribute of the
PI Point value that is retrieved.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
MULTILOAD=YES | NO
Specifies whether Teradata Insert and Append operations
should use the Teradata MultiLoad utility.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MULTISTMT=YES | NO
Specifies whether insert statements are sent to
Teradata one at a time or in a group.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
NAME=<'>element-name<'>
Specifies the element name to use for retrieving
elements.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
NCHARMULTIPLIER=n
Specifies a multiplication factor that is used to
increase the number of bytes for a fixed character variable when data
is transcoded to the UTF-8 encoding in order to run in the CAS server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
NULLCHAR= SAS | YES | NO
Indicates how missing SAS character values are handled
during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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
| |
|
NULLCHAR=SAS | YES | NO
Indicates how missing SAS character values are handled
during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
NULLCHARVAL= 'character-string'
Defines the character string that replaces missing
SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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
| |
|
NULLCHARVAL='character-string'
Specifies the character string that replaces missing
SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
OBSBUF=n
Determines the size of the view buffer for processing
a DATA step view.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
ONDEMAND=YES | NO
Specifies how to evaluate temporary computed columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
OR_UPD_NOWHERE=YES | NO
Specifies whether SAS uses an extra WHERE clause
when updating rows with no locking.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ORDERBY=(<DESCENDING> variable-name-1 <,<DESCENDING> variable-name-2 ...>)
Orders data hierarchically within a partition according
to the specified variables.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
ORHINTS='Oracle-hint'
Specifies Oracle hints to pass to Oracle from a
SAS statement or SQL procedure.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
OUTREP=SESSION | format
Specifies the data representation for the output
SAS data set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
OUTREP= format
Specifies the data representation for the output
SAS data set.
Product: Base SAS
Document: SAS National Language Support (NLS): Reference Guide
| |
|
PADCOMPRESS=n
Specifies the number of bytes to add to compressed
blocks in a data set opened for OUTPUT or UPDATE.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
PARALLELREAD=NO | YES
Determines when the SPD Engine uses parallel processing
to read data stored in HDFS.
Product: Base SAS
Document: SAS SPD Engine: Storing Data in the Hadoop Distributed File System
| |
|
PARALLELWRITE=NO | YES | threads
Determines whether the SPD Engine uses parallel
processing to write data in HDFS.
Product: Base SAS
Document: SAS SPD Engine: Storing Data in the Hadoop Distributed File System
| |
|
PARMDEFAULT=YES | NO
Specifies whether the SAP HANA engine uses the defaults
for variables and parameters that are specified in the metadata in
SAP HANA.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PARMSTRING=<"variable-name1=variable-value1,variable-name2=variable-value2,...">
< "'PLACEHOLDER'
= ('variable-name1',
'variable-value1'),<
'PLACEHOLDER'=
('variable-name2', 'variable-value2'),>..."> Specifies a quoted string of variable name and value
pairs separated by a comma, or a placeholder string.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PARTITION=(variable-list)
| ( )
Partitions the output table according to the formatted
values of the specified variables.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
PARTITIONED_BY=(column-name1< ...
column-nameN>)
Specifies the column name to use as the partition
key for creating fact tables.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PARTSIZE=n | nM | nG | nT
Specifies the maximum size (in megabytes, gigabytes,
or terabytes) that the data component partitions can be. The value
is specified when an SPD Engine data set is created. This size is
a fixed size. This specification applies only to the data component
files.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
PARTSIZE=n | nM
| nG | nT
Specifies a size for the SPD Engine data partition
file.
Product: Base SAS
Document: SAS SPD Engine: Storing Data in the Hadoop Distributed File System
| |
|
PATH="path-value"
Specifies the full path to use for retrieving an
element and any children.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
POST_DML_STMT_OPTS=value
Specifies text to append to an INSERT, UPDATE, or
DELETE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
POST_STMT_OPTS='DBMS-SQL-options'
Allows additional database-specific options to be
placed after the CREATE TABLE statement in generated SQL code.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
POST_TABLE_OPTS=DBMS-SQL-options
Allows additional database-specific options to be
placed after the table name in a CREATE TABLE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRE_STMT_OPTS=DBMS-SQL-options
Allows additional database-specific options to be
placed before a CREATE TABLE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRE_TABLE_OPTS=DBMS-SQL-options
allows additional database-specific options to be
placed before the table name in a CREATE TABLE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRESERVE_COL_NAMES=YES | NO
Preserves spaces, special characters, and case sensitivity
in DBMS column names when you create DBMS tables.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
PRESERVE_COL_NAMES=YES | NO
Preserves spaces, special characters, and case sensitivity
in DBMS column names when you create DBMS tables.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PROMOTE=YES | NO
Requests that the CAS table is added with global
scope.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
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: Reference
| |
|
PWREQ=YES | NO
Specifies whether to display a password dialog box.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
QUALIFIER=<qualifier-name>
Specifies the qualifier to use when you are reading
database objects, such as DBMS tables and views.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
QUERY_BAND="pair-name=pair_value;"
Specifies whether to set a query band for the current
transaction.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
QUERY_TIMEOUT=number-of-seconds
Specifies the number of seconds of inactivity to
wait before canceling a query.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
READ_ISOLATION_LEVEL=DBMS-specific-value
Specifies which level of read isolation locking
to use when you are reading data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data in a DBMS table is locked during
a read transaction.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_METHOD=JDBC | HDFS
Specifies how to read data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_MODE=BULKUNLOAD | STANDARD | STORAGE
Specifies the method to use to move data into SAS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_MODE_WAIT=YES | NO
Specifies during SAS/ACCESS Read operations whether
Teradata waits to acquire a lock or fails your request when a different
user has locked the DBMS resource.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
READBUFF=integer
Specifies the number of rows of DBMS data to read
into the buffer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READTRANSFERSIZE=integer | integerK | integerM | integerG
Specifies the maximum number of bytes that the CAS
engine reads when transferring data from the CAS server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
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: Reference
| |
|
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: Reference
| |
|
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: Reference
| |
|
REREAD_EXPOSURE= NO | YES
Specifies whether the SAS/ACCESS engine behaves
like a random-access engine for the scope of the LIBNAME statement.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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: Reference
| |
|
ROLE=FACT | DIMENSION Identifies the fact table for a star schema join.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
ROW_DELIMITER=single-character
Specifies the single delimiter character to use
to separate Hive table records.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ROWSET_SIZE=integer
Specifies the number of rows of DBMS data to read
into the buffer.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
Specifies SAS/ACCESS data set options on a SAS data
set when you access data using the LIBNAME statement for the PC Files
engine.
Product: SAS/ACCESS Interface to SYSTEM 2000
Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya
| |
|
SASDATEFMT=(DBMS-date-column-1=<'>SAS-date-format<'> <...DBMS-date-column-n=<'>SAS-date-format<'> >)
Changes the SAS date format of a DBMS column.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
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
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SCANSTRINGCOLUMNS=YES | NO
Specifies whether to determine the maximum length
of VARCHAR columns in a database table or query.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SCHEMA=schema-name
Specifies the schema to use when accessing tables
and views in a database.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SCHEMA_TABLES=YES | NO
Specifies whether to create tables that give details
about a schema.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCRATCH_DB=schema-name
Specifies a Hive schema so that SAS can store temporary
output.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SCRIPT=fileref
Specifies the file reference for the SAS script
that defines the temporary computed columns.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
SEARCHBY=ATTRIBUTE | CATEGORY | GUID | NAME | PATH | TEMPLATE
Specifies the search method that locates element
objects that are defined in the target server and database.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SEGMENT_NAME=segment-name
Lets you control the segment in which you create
a table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SELECT=ALL | GOOD | BAD | SNAPSHOT
Specifies which values are displayed.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SESSIONS=number-of-sessions
Specifies how many Teradata sessions to be logged
on when using FastLoad, FastExport, or Multiload.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SET=YES | NO
Specifies whether duplicate rows are allowed when
creating a table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SHOWFLAGS=YES | NO
Specifies whether the columns Questionable, Annotated,
and Substituted display.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SHOWINDEX=YES | NO
Specifies whether to include column _index from
the Picomp table.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SLEEP=number-of-minutes
Specifies the number of minutes that FastExport,
FastLoad, or MultiLoad waits before trying again to log on to Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SORTEDBY=by-clause </ collate-name> | _NULL_
Specifies how a data set is currently sorted.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
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: Reference
| |
|
START="start-time"
Specifies the timestamp of the earliest tag value
to read in the form of a PI System TIMESTAMP string.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
STARTOBS=n
Specifies the starting observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SYNCADD=YES | NO
Specifies to process one observation at a time or
multiple observations at a time when adding observations.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
TABLE_TYPE=ROW | COLUMN | LOCAL
| LOCAL TEMPORARY | GLOBAL | GLOBAL TEMPORARY Specifies the type of temporary tables and table
storage when the engine creates tables in SAP HANA.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TAG=tag-name
Specifies a multi-level prefix for a CAS table that
is used to identify the table to both the CAS server and SAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
TAGFILTER="string"
Specifies a character string that is used to filter
tags when reading from the Pipoint virtual table.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TAGLIST=data-set-name <(data-set-options)>
Specifies a SAS data set name that is used for the
selection process when reading from Picomp.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TAGLIST_JOIN=YES | NO
Specifies whether to perform a join between the
requested table (Picomp or Picomp_Summary) and the table that is listed
in TAGLIST.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TEMPLATE=template-name
Specifies the template to use for retrieving elements.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TEMPNAMES=variable-list
Adds temporary computed column names to the input
table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
TEMPORAL_QUALIFIER=CURRENT VALIDTIME
| VALIDTIME AS OF 'period' | SEQUENCED VALIDTIME 'period' | NONSEQUENCED VALIDTIME 'period' TEMPORAL_QUALIFIER=CURRENT TRANSACTIONTIME | TRANSACTION AS OF 'period' | NONSEQUENCED TRANSACTIONTIME Specifies time-dimension criteria for retrieving
data from Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TENACITY=number-of-hours
Specifies how many hours that FastExport, FastLoad,
or MultiLoad continues to try to log on again to Teradata if the maximum
number of Teradata utilities are already running.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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 Scalable Performance Data Engine: Reference
| |
|
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: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
TIMEZONE=LOCAL | GMT
Specifies whether SAS reads and writes PI System
timestamps using local time or GMT.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TOBSNO=n
Specifies the number of observations to send in
a client/server transfer.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
TPT=YES | NO
Specifies whether SAS uses the TPT API to load data
for Fastload, MultiLoad, or Multi-Statement insert requests.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_APPL_PHASE=YES | NO
Specifies whether a load process that is being restarted
has failed in the application phase.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_BLOCK_SIZE=integer
Specifies the block size in bytes for TPT Export.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_BUFFER_SIZE=integer
Specifies the output buffer size in kilobytes when
SAS sends data to Teradata with Fastload or MultiLoad using the TPT
API.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_CHECKPOINT_DATA=checkpoint_data_in_error_message
Specifies the checkpoint data to return to Teradata
when restarting a failed MultiLoad or Multi-Statement step that uses
the TPT API.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_DATA_ENCRYPTION=YES | NO
Specifies whether to fully encrypt SQL requests,
responses, and data when SAS sends data to Teradata for Fastload,
MultiLoad, or Multi-Statement insert that uses the TPT API.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_ERROR_TABLE_1=valid_teradata_table_name
Specifies the name of the first error table for
SAS to use when using the TPT API with Fastload or MultiLoad.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_ERROR_TABLE_2=valid_teradata_table_name
Specifies the name of the second error table for
SAS to use when using the TPT API with Fastload or MultiLoad.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_LOG_TABLE=valid_teradata_table_name
Specifies the name of the restart log table for
SAS to use when using the TPT API with Fastload, MultiLoad, or Multi-Statement
insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_MAX_SESSIONS=integer
Specifies the maximum number of sessions for Teradata
to use when using the TPT API with FastLoad, MultiLoad, or Multi-Statement
insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_MIN_SESSIONS=integer
Specifies the minimum number of sessions for Teradata
to use when using the TPT API with FastLoad, MultiLoad, or Multi-Statement
insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_PACK=integer
Specifies the number of statements to pack into
a Multi-Statement insert request when using the TPT API.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_PACKMAXIMUM=YES | NO
Specifies whether to pack the maximum possible or
default number of statements into Multi-Statement insert requests
when using the TPT API.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_RESTART=YES | NO
Specifies that a failed FastLoad, MultiLoad, or
Multi-Statement run that used the TPT API is being restarted.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_TRACE_LEVEL=integer
Specifies the required tracing level for sending
data to Teradata and using the TPT API with Fastload, MultiLoad, or
Multi-Statement insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_TRACE_LEVEL_INF=integer
Specifies the tracing level for the required infrastructure
for sending data to Teradata and using the TPT API with Fastload,
MultiLoad, or Multi-Statement insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_TRACE_OUTPUT=file-name
Specifies the name of the external file for SAS
to use for tracing when using the TPT API with Fastload, MultiLoad,
or Multi-Statement insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_WORK_TABLE=valid_teradata_table_name
Specifies the name of the work table for SAS to
use when using the TPT API with MultiLoad.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TRANSCODE_FAIL=<ERROR> | <WARNING> | <SILENT>
Lets you specify how to handle processing and notification
of transcoding errors.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TRANSCODE_FAIL=ERROR | WARN | SILENT
Specifies how the engine handles transcoding errors.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
TYPE=data-set-type
Specifies the data set type for a specially structured
SAS data set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
UNIQUESAVE=YES | NO
Specifies to save observations with nonunique key
values (the rejected observations) to a separate data set when adding
observations to data sets with unique indexes.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
UPDATE_ISOLATION_LEVEL=DBMS-specific-value
Specifies the degree of isolation of the current
application process from other concurrently running application processes.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data in a DBMS table is locked during
an update transaction.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATE_MODE_WAIT=YES | NO
Specifies during SAS/ACCESS Update operations whether
the DBMS waits to acquire a lock or fails your request when a different
user has locked the DBMS resource.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATE_SQL=YES | NO
Determines which method to use to update and delete
rows in a data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATEBUFF=positive-integer
Specifies the number of rows that are processed
in a single DBMS Update or Delete operation.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPSERT=YES | NO
Specifies whether a Teradata MultiLoad upsert should
take place.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPSERT_CONDITION=condition(s)-to-append
Specifies one or more conditions to add to a WHERE
condition for a Teradata MultiLoad upsert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPSERT_WHERE=list-of-column(s)
Specifies which columns in the controller table
are used to generate a WHERE condition for a Teradata MultiLoad upsert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: Reference
| |
|
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: Reference
| |
|
WHERENOINDEX=(name(s))
Specifies a list of indexes to exclude when making
WHERE expression evaluations.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
WHEREUP=NO | YES
Specifies whether to evaluate new observations and
modified observations against a WHERE expression.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
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: Reference
| |
|
WRITETRANSFERSIZE=integer | integerK | integerM | integerG
Specifies the maximum number of bytes that the CAS
engine writes when transferring data to the CAS server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
YB_JAVA_HOME=<'>JRE-path<'>
Specifies the path to the JRE for Yellowbrick.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
|
Last updated: March 23, 2022