Data Set Options Listed by Product
Base SAS
|
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
| |
|
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: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
ADDROWID=<YES | NO>
Adds a column to the output data set with the name "_ROWID_" that
increments in numeric value with each row.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
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 data set that
prevents users from replacing or deleting the file, and enables access
to a Read- and Write-protected file.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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
| |
|
APPEND=YES | NO | FORCE
Specifies whether to append rows from a DATA step or a PROC step output to an
in-memory table.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
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
| |
|
BINARY_BYTE_LIMIT=n
Specifies the maximum length for binary columns
that do not have a defined length.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
BL_LOAD_REPLACE= NO | YES
Specifies whether DB2 appends or replaces rows during
bulk loading.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BL_LOG= path-and-log-filename
Identifies a log file that will contain information
such as statistics and error information for a bulk load.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BL_OPTIONS= 'option<, option ...>'
Passes options to the DB2 bulk-load facility, affecting
how it loads and processes data.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BUFNO=n | nK | hexX | MIN | MAX
Specifies the number of buffers to be allocated
for processing a SAS data set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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 LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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
| |
|
BULKLOAD=YES | NO
Loads rows of data as one unit.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BULKOPTS=(option=value <option1=value ... >)
Container option for BL_LOAD_REPLACE=, BL_LOG=,
and BL_OPTIONS= data set options.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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
| |
|
CASLIB=caslib-reference-name
Specifies the name of the caslib to use for engine operations for the
table.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
CHAR_COLUMN_LIMIT=n
Specifies the maximum length for character columns
that do not have a defined length.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: 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_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: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
COMPRESS= NO | YES | CHAR | BINARY
Specifies the compression of rows in an output table.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
COMPRESS=NO | BROTLI | GZIP | LZ4 | LZ4_HADP | SNAPPY | YES | ZLIB | ZSTD
Controls the compression for a new output table.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
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 | BINARY
COMPRESS=NO | YES
Specifies whether observations are compressed or the compression method to use for
an output data set.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
COPIES=integer
Specifies the number of copies for a redundant table.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
DATA_BLOCK_SIZE=n | nK | nM | nG
Requests a stripe size for an ORC table during creation
(output).
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: 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: Base SAS
Document: SAS Data Set Options: Reference
| |
|
DBCOMMIT=unsigned-integer
Causes an automatic Commit (a permanent writing
of data to the DBMS) after a specified number of rows have been processed.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBCONDITION="DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBFORCE= YES | NO
Specifies whether to force the truncation of data
during insert processing.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBGEN_NAME= DBMS | SAS
Specifies how SAS renames columns when they contain
characters that SAS does not allow.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBINDEX= YES | NO | <'>index-name<'>
Detects and verifies that indexes exist on a DBMS
table. If they do exist and are of the correct type, a join query
that is passed to the DBMS might improve performance.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBKEY=(<'>column1<'> <<'> column2<'> ... > )
Specifies a key column to optimize DBMS retrieval.
Can improve performance when you are processing a join that involves
a large DBMS table and a small SAS data set or DBMS table.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBLABEL= YES | NO
Specifies whether to use SAS column labels or SAS
column names as the DBMS column names during output processing.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBNULL=<_ALL_=YES | NO>
| ( <column-name-1=YES | NO > <<column-name-2=YES | NO> ...> ) When a table is created, this option indicates whether
a null is a valid value for the specified columns.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBNULLKEYS=YES | NO
Controls the format of the WHERE clause with regard
to null values when you use the DBKEY= data set option.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBSASLABEL= COMPAT | NONE
Specifies how the table driver returns column labels.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBTYPE=(column-name-1=<'> DBMS-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: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBTYPE=(column-name-1=column-type-1<...column-name-n=column-type-n>)
Specifies a data type to use instead of the default data type when SAS creates
a table.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: 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=column(s)
For an input data set, excludes the specified columns
from processing; for an output data set, excludes the specified columns
from being written to the data set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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 SAS Cloud Analytic Services is duplicated
on all nodes.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
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=YES | NO
Specifies whether to encrypt an output table.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s 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
| |
|
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
| |
|
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
| |
|
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
| |
|
FIRSTOBS= n | nK | nM | nG | hexX | MIN | MAX
Specifies the first row in a data source that SAS
processes.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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
| |
|
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 LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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 SAS uses an index search or a
sequential search to match the conditions of a WHERE expression.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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 that
are Read-only and that have unique values when generating a SQL statement
for inserts or updates.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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 that is used to insert rows
into a data source.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
INSERTBUFF=positive-integer
Specifies the number of rows in a single Insert
operation.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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=column(s)
For an input data set, specifies the columns to
process; for an output data set, specifies the columns to write to
the data set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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
| |
|
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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
| |
|
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
| |
|
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: Base SAS
Document: SAS Data Set Options: Reference
| |
|
NULLCHAR= SAS | YES | NO
Indicates how missing character values are handled
during insert, update, DBINDEX=, and DBKEY= processing.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
NULLCHARVAL='character-string'
Defines the character string that replaces missing
character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
OBS= n | nK | nM | nG | nT | hexX | MIN | MAX
Specifies the last row in a data source that SAS
processes.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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: Base SAS
Document: SAS Data Set Options: Reference
| |
|
ORDERBY=(<DESCENDING>
variable-name-1 <,<DESCENDING> variable-name-2 ...>)
Orders data hierarchically within a partition according to the specified
variables.
Product: Base SAS
Document: SAS Data Set Options: 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
| |
|
PARTITION=(variable-list)
| ( )
Partitions the output table according to the formatted values of the specified
variables.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
PARTITION_BY=(column-name-1<...column-name-n>)
Specifies one or more columns that determine a table's
partitions.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
PARTITION_TYPE=DIRECTORY | FILENAME | HIVE
Specifies the type of partitioning for a table.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: 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
| |
|
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
| |
|
PRESERVE_COL_NAMES=NO | YES
Preserves spaces, special characters, and case sensitivity
in column names when you create tables.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
PROMOTE=YES | NO
Requests that a CAS table is added with global scope.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
PW=password
Assigns a READ, WRITE, and ALTER password to a SAS
data set and enables access to a password-protected file.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: 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
| |
|
PWD=password
Specifies the user's password for Access Control Lists (ACLs) in Parquet
files.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
PWREQ=YES | NO
Specifies whether to display a password window.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
QUALIFIER=qualifier-name
Identifies database objects, such as tables, by
using a qualifier.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
READ=read-password
Assigns a READ password to a SAS data set that prevents
users from reading the file, unless they enter the password.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data in a DBMS table is locked during
a Read transaction.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
READBUFF=integer
Specifies the number of rows of data to read into
the buffer for an individual data set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
READTRANSFERSIZE=integer | integerK | integerM | integerG
Specifies the maximum number of bytes that the CAS engine reads when
transferring data from the CAS server.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
RENAME=(old-name-1=new-name-1< ...old-name-n=new-name-n> )
Changes the name of a column.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: 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
| |
|
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
| |
|
SAS_CHAR_COLUMN_DEFAULT=STRING
Specifies that all SAS character columns be written as logical type STRING
.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
SASDATEFMT=(DBMS-date-col-1='SAS-date-format'
<… DBMS-date-col-n='SAS-date-format'> ) Changes the SAS date format of a DBMS column.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
SCHEMA=schema-name
Enables you to read database objects, such as tables,
in the specified DBMS schema.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
SCRIPT=fileref
Specifies the file reference for the SAS script that defines the temporary
computed columns.
Product: Base SAS
Document: SAS Data Set Options: 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
| |
|
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
| |
|
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
| |
|
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: Base SAS
Document: SAS Data Set Options: Reference
| |
|
TEMPNAMES=variable-list
Adds temporary computed column names to the input table.
Product: Base SAS
Document: SAS Data Set Options: 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: Base SAS
Document: SAS Data Set Options: Reference
| |
|
TOBSNO=n
Specifies the number of observations to send in a client-server
transfer.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
TRANSCODE_FAIL=ERROR | WARN | SILENT
Specifies how the engine handles transcoding errors.
Product: Base SAS
Document: SAS Data Set Options: Reference
| |
|
TYPE=data-set-type
Specifies the data set type for a specially structured
data set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: 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: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data is locked during an update transaction.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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
| |
|
USER=name
Specifies a user's name for Access Control Lists (ACLs) in Parquet
files.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
WHERE=(where-expression-1 <logical-operator <where-expression-n>>)
Specifies specific conditions to use to select rows
from a data set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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 they enter the password.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
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: Base SAS
Document: SAS Data Set Options: Reference
|
SAS Data Agent
|
Name
|
Syntax and Description
|
|---|---|
|
CURSOR_TYPE=DYNAMIC | FORWARD_ONLY | KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only and updatable
cursors.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBCOMMIT=n
Causes an automatic COMMIT (a permanent writing of data to the DBMS) after a
specified number of rows are processed.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBCONDITION="DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBFORCE= YES | NO
Specifies whether to force the truncation of data
during insert processing.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBGEN_NAME=
DBMS | SAS
Specifies how SAS renames columns automatically when they contain characters
that SAS does not allow.Specifies how SAS automatically renames columns (when they
contain
characters that SAS does not allow, such as $) to valid SAS variable
names.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBINDEX= YES | NO | <'>index-name<'>
Detects and verifies that indexes exist on a DBMS table.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBINFMT=
(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 Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBKEY=(<'>
column-1<'>
<… <'> column-n<'> >
)
Specifies a key column to optimize DBMS retrieval.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBLABEL= YES | NO
Specifies whether to use SAS column labels or SAS
column names as the DBMS column names during output processing.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: 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 Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBNULL=<
_ALL_=YES | NO
>
| ( <column-name-1=YES | NO > <<column-name-2=YES | NO> ...> ) Indicates whether NULL is a valid value for the specified columns when a table
is created.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBNULLKEYS=YES | NO
Specifies whether NULL values are allowed in key columns.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBSASLABEL=
COMPAT | DBMS | NONE
Specifies how the table driver returns column labels.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
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 Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBTYPE=(column-name-1=<'> DBMS-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 Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
IGNORE_READ_ONLY_COLUMNS=YES | NO
Specifies whether to ignore or include columns that are Read-only and that have
unique values when generating an SQL statement for inserts or updates.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
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 Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
INSERT_SQL=YES | NO
Determines the method that is used to insert rows into a data
source.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
INSERTBUFF=positive-integer
Specifies the number of rows in a single DBMS insert.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
KEYSET_SIZE=number-of-rows
Specifies
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
NULLCHAR=SAS | YES | NO
Indicates how missing character values are handled
during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
NULLCHARVAL='character-string'
Defines the character string that replaces missing
character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
PRESERVE_COL_NAMES=NO | YES
Preserves spaces, special characters, and case sensitivity
in column names when you create tables.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
QUALIFIER=qualifier-name
Identifies database objects, such as tables, by
using a qualifier.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
QUERY_TIMEOUT=number-of-seconds
Specifies the number of seconds of inactivity to wait before canceling a
query.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
READ_ISOLATION_LEVEL=DBMS-specific-value
Specifies which level of Read isolation locking
to use when you are reading data.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data in a DBMS table is locked during
a Read transaction.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
READBUFF=integer
Specifies the number of rows of data to read into the
buffer.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
SASDATEFMT=(DBMS-date-col-1='SAS-date-format'
<… DBMS-date-col-n='SAS-date-format'> ) Changes the SAS date format of a DBMS column.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
SCHEMA=schema-name
Enables you to read database objects, such as tables,
in the specified DBMS schema.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
UPDATE_ISOLATION_LEVEL=DBMS-specific-value
Specifies the degree of isolation of the current
application process from other concurrently running application processes.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data is locked during an update transaction.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
|
SAS/ACCESS Interface R/3
|
Name
|
Syntax and Description
|
|---|---|
|
BATCH= Y | N
Specifies whether SAS uses SAP batch jobs for data
extracts.
Product: SAS/ACCESS Interface 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 R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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 R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBKEY= (<'>column-1<'> <...
<'>column-n<'>>)
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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 R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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 R/3
Document: SAS/ACCESS Interface to R/3: 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 R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
NULLCHARVAL= 'character-string'
Defines the character string that replaces missing
SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
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 R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
|
SAS/ACCESS Interface to SYSTEM 2000
|
Name
|
Syntax and Description
|
|---|---|
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
| |
|
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 the SAS Viya Platform
|
SAS/ACCESS Interface to the PI System
|
Name
|
Syntax and Description
|
|---|---|
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
TIMEZONE=LOCAL | GMT
Specifies whether SAS writes timestamps using local
time or GMT.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
|
SAS/ACCESS for Relational Databases
|
Name
|
Syntax and Description
|
|---|---|
|
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
| |
|
AUTOCOMMIT=YES | NO
Specifies whether to enable the DBMS autocommit
capability.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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_AZURE_SAS=value
Specifies the Azure shared access signature token value.
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_CLIENT_DATAFILE=path-and-data-file-name
Specifies the location of the data file that contains DBMS data for bulk
loading.
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_COLUMN_DELIMITER='any-single-character'
Specifies override of the default delimiter character for separating columns
of data during data transfer or retrieval 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_DBACCESS_PATH="directory-path"
Specifies the location of the DBACCESS utility.
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 (NO) or all files (YES) that the
SAS/ACCESS engine creates for the data source bulk-load utilty.
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=PRIMARY
BL_EXECUTE_LOCATION=HOST
[segment-host], number-of-segments
BL_EXECUTE_LOCATION=SEGMENT segmentID
Specifies which segment instances run 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 | ORC | PARQUET
Specifies the format of the external or web table data, or interim staging
file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FORMAT_OPT="option" | "option=value"
Specifies format options for loading CSV files.
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_ASSUME_ROLE_ARN="value"
Specifies an Amazon Resource Name (ARN) that identifies
an IAM role.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_IAM_ASSUME_ROLE_NAME="value"
Specifies an AWS IAM role name that enables you to connect to an Amazon S3
environment.
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
Enables you to 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_INFORMIXDIR="directory-path"
Specifies the location of the Informix SDK installation.
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
BL_LOAD_METHOD=APPEND
| REPLACE
| TRUNCATE
Specifies the method by which data is loaded into a 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 <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>>'
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PARFILE=<parameter-file>
Specifies 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=<'>directory-path<'>
Specifies the location of temporary files that are created by the bulk-loading
utility.
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_ROW_DELIMITER='character-sequence'
Specifies an override character sequence that delimits rows or records in data
during data transfer or retrieval during bulk loading.
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 location of the data file for bulk loading that the DBMS server
instance can access.
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 in seconds for a storage
task.
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 during bulk loading.
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.
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_WRITEBUFF=value
Specifies the number of rows to buffer in memory before writing to your data
source.
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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=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 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='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
| |
|
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 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 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 for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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 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
| |
|
DBLINK=database-link
For Oracle, specifies a link from your local database to
database objects on another server. For SAP ASE, specifies a link from your default
database
to another database on the server to which you are connected.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
DBMAX_TEXT_TYPES=LONG | ALL
Specifies whether the DBMAX_TEXT= data set option is applied to all character
types or only "long" data types.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
Specifies whether NULL values are allowed in key columns.
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 for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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-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: 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=<'>
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
| |
|
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
| |
|
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
| |
|
FETCH_NUMERIC_TYPE=FLOAT64 | NUMERIC
Specifies how to load NUMERIC data from Google BigQuery.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
IGNORE_FEDSQL_OBJECTS=YES | NO
Specifies whether to ignore FedSQL objects in a query.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: 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
| |
|
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=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
| |
|
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
| |
|
LOCKTABLE=EXCLUSIVE
| SHARE
Places exclusive or shared locks on tables.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: 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
| |
|
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
| |
|
MODE=STANDARD | PERFORMANCE
Specifies whether to enable multiple performance-related
options.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational 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
| |
|
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'
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: 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 for Relational Databases
Document: SAS/ACCESS for Relational Databases: 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-name1=pair_value1;..."
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_TAG="value"
Specifies an optional string that you can use to tag queries to your data
source.
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_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=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=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
| |
|
REPLACE=NO | YES
Specifies whether a new database table can overwrite an existing database
table of the same name.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: 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
| |
|
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 or large type 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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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
| |
|
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 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
| |
|
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 a primary 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
| |
|
USE_PIPELINE=NO | YES
Enables pipeline read functionality for Amazon Redshift.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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: July 17, 2025