Data Set Options Syntax Listed Alphabetically

Data Set Options

A B C D E F G I K L M N O P Q R S T U W

Name
Syntax and Description
AGGREGATE= YES | NO
Specifies whether detailed data or aggregated data should be retrieved.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
ALTER=alter-password
Specifies a password for a SAS file that prevents users from replacing or deleting the file, but permits Read and Write access.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
ALTER= alter-password
Specifies a password for a SAS file that prevents users from replacing or deleting the file, but permits read and write access.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
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 9.3 Data Sets: 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 9.3 Scalable Performance Data Engine: Reference
AUTHID= authorization-ID
Lets you qualify the specified table with an authorization ID, user ID, or group ID.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
AUTOCOMMIT=YES | NO
Specifies whether to enable the DBMS autocommit capability.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
AUTOCOMMIT=YES | NO
Determines whether the ACCESS engine commits (saves) updates as soon as you submit them.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
BATCH= 0 | 1 | Y | N
Specifies whether SAS uses SAP batch jobs for data extracts.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
BL_ALLOW_READ_ACCESS=YES | NO
Specifies that the original table data is still visible to readers during bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_BADDATA_FILE= filename
Specifies where to put records that failed to process internally.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_BADFILE= path-and-filename
Identifies a file that contains records that were rejected during bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_CLIENT_DATAFILE= path-and-data-filename
Specifies the client view of the data file that contains DBMS data for bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_CONTROL= path-and-control-filename [Oracle]
BL_CONTROL= path-and-data-filename [Teradata]
Identifies the file that contains control statements.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_COPY_LOCATION= pathname
Specifies the directory to which DB2 saves a copy of the loaded data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DATAFILE= path-and-data-filename
Identifies the file that contains control statements.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DATAFILE= path-and-data-filename
Identifies the file that contains DBMS data for bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2CURSOR='SELECT * from filename'
Specifies a string that contains a valid DB2 SELECT statement that points to either local or remote objects (tables or views).
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2DATACLAS= data-class
Specifies a data class for a new SMS-managed data set.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2DEVT_PERM= unit-specification
Specifies the unit address or generic device type to use for permanent data sets that the LOAD utility creates—also SYSIN, SYSREC, and SYSPRINT when SAS allocates them.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2DEVT_TEMP= unit-specification
Specifies the unit address or generic device type to use for temporary data sets that the LOAD utility creates (Pnch, Copy1, Copy2, RCpy1, RCpy2, Work1, Work2).
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2DISC= data-set-name
Specifies the SYSDISC data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2ERR= data-set-name
Specifies the SYSERR data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2IN= data-set-name
Specifies the SYSIN data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2LDCT1='string'
Specifies a string in the LOAD utility control statement between LOAD DATA and INTO TABLE.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2LDCT2='string'
Specifies a string in the LOAD utility control statement between INTO TABLE and ().
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2LDCT3='string'
Specifies a string in the LOAD utility control statement after ().
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2LDEXT=GENRUN | GENONLY | USERUN
Specifies the mode of execution for the DB2 LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2MAP= data-set-name
Specifies the SYSMAP data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2MGMTCLAS= management-class
Specifies a management class for a new SMS-managed data set.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2PRINT= data-set-name
Specifies the SYSPRINT data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2PRNLOG=YES | NO
Determines whether to write SYSPRINT output to the SAS log.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2REC= data-set-name
Specifies the SYSREC data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2RECSP= primary-allocation
Determines the number of cylinders to specify as the primary allocation for the SYSREC data set when it is created.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2RSTRT=NO | CURRENT | PHASE
Tells the LOAD utility whether the current load is a restart and, if so, indicates where to begin.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2SPC_PERM= primary-allocation
Determines the number of cylinders to specify as the primary allocation for permanent data sets that the LOAD utility creates.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2SPC_TEMP= primary-allocation
Determines the number of cylinders to specify as the primary allocation for temporary data sets that the LOAD utility creates.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2STORCLAS= storage-class
Specifies a storage class for a new SMS-managed data set.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2TBLXST=YES | NO
Indicates whether the LOAD utility runs against an existing table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2UNITCOUNT= number-of-volumes
Specifies the number of volumes on which data sets can be extended.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DB2UTID= utility-ID
Specifies a unique identifier for a given run of the DB2 LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DBNAME='database-name'
Specifies the database name to use for bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DEFAULT_DIR=<host-specific-directory-path>
Specifies where bulk load creates all intermediate files.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DELETE_DATAFILE=YES | NO
Specifies whether to delete only the data file or all files that the SAS/ACCESS engine creates for the DBMS bulk-load facility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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 load or bulk unload.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DIRECT_PATH=YES | NO
Sets the Oracle SQL*Loader DIRECT option.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DISCARDFILE= path-and-discard-filename
Identifies the file that contains records that were filtered from bulk load because they did not match the criteria as specified in the CONTROL file.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_DISCARDS= number-of-discarded-records
Specifies whether and when to stop processing a job, based on the number of discarded records.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_ENCODING= character-set-encoding
Specifies the character set encoding to use for the external table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_ERRORS= number-of-failed-records
Specifies whether and when to stop processing a job based on the number of failed records.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_ESCAPE='<any-single-character>'
Specifies the single character to use for C escape sequences.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_EXCEPTION= exception table-name
Specifies the exception table into which rows in error are copied.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_EXECUTE_CMD= command | script
Specifies the operating system command for segment instances to run.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_EXECUTE_LOCATION=ALL | MASTER
| HOST [segment-hostname], number-of-segments | SEGMENT <segmentID>
Specifies which segment instances runs the given command.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_EXTERNAL_WEB=YES | NO
Specifies whether the external data set accesses a dynamic data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_FAILEDDATA= filename
Specifies where to put records that could not be written to the database.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_FORCE_NOT_NULL=YES | NO
Specifies how to process CSV column values.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_FORMAT=TEXT | CSV
Specifies the format of the external or web table data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_HOST='hostname' [Aster nCluster]
BL_HOST='localhost' [Greenplum]
Specifies the host name or IP address of the server where the external data file is stored.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_HOSTNAME= hostname
Specifies the unqualified host name of the HP Neoview machine.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_INDEX_OPTIONS= any valid SQL*Loader Index option segment-name
Lets you specify SQL*Loader Index options with bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_KEEPIDENTITY=YES | NO
Determines whether the identity column that is created during bulk load is populated with values that Microsoft SQL Server generates or with values that the user provides.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_KEEPNULLS=YES | NO
Indicates how NULL values in Microsoft SQL Server columns that accept NULL are handled during bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_LOAD_METHOD=INSERT | APPEND | REPLACE | TRUNCATE
Specifies the method by which data is loaded into an Oracle table during bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_LOAD_REPLACE=YES | NO
Specifies whether DB2 appends or replaces rows during bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_LOG= path-and-log-filename
Identifies a log file that contains information for bulk load, such as statistics and errors.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_METHOD=CLILOAD
Specifies the bulk-load method to use for DB2.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_NULL='\N' | empty-value
Specifies the string that represents a null value.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_NUM_ROW_SEPS=<integer>
Specifies the number of newline characters to use as the row separator for the load or extract data stream.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_OPTIONS='< option…,option > ' [DB2 under UNIX and PC Hosts, OLE DB, Oracle]
BL_OPTIONS='<< option > > << value> ... '> [Aster nCluster, Netezza, Sybase IQ]
Passes options to the DBMS bulk-load facility, which affects how it loads and processes data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_PARFILE= < parse-file >
Creates a file that contains the SQL*Loader command-line options.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_PATH='path'
Specifies the path to use for bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_PORT= < port >
Specifies the port number to use.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_PORT_MAX= < integer >
Sets the highest available port number for concurrent uploads.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_PORT_MIN= < integer >
Sets the lowest available port number for concurrent uploads.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_PROTOCOL='gpfdist' | 'file' | 'http'
Specifies the protocol to use.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_QUOTE="
Specifies the quotation character for CSV mode.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_RECOVERABLE=YES | NO
Determines whether the LOAD process is recoverable.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_REJECT_LIMIT= number
Specifies the reject limit count.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_REMOTE_FILE= pathname-and-base-filename
Specifies the base filename and location of DB2 LOAD temporary files.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_RETRIES= number-of-attempts
Specifies the number of attempts to make for a job.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_RETURN_WARNINGS_AS_ERRORS=YES | NO
Specifies whether SQL*Loader (bulk-load) warnings should surface in SAS through the SYSERR macro as warnings or as errors.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_ROWSETSIZE= number-of-records
Specifies the number of records to exchange with the database.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_SERVER_DATAFILE= path-and-data-filename
Specifies the name and location of the data file that the DBMS server instance sees.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_SQLLDR_PATH= pathname
Specifies the location of the SQLLDR executable file.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_STREAMS= < number >
Specifies the value for the HP Neoview Transporter parallel streams option.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_SUPPRESS_NULLIF= <_ALL_=YES | NO>
| ( < 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_SYNCHRONOUS=YES | NO
Specifies how to process source file record sets.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_SYSTEM= unqualified-systemname
Specifies the unqualified name of the primary segment on an HP Neoview system.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_TENACITY= number-of-seconds
Specifies how long the HP Neoview Transporter waits before trying again.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_TRIGGER=YES | NO
Specifies whether to enable triggers on a table when loading jobs.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_TRUNCATE=YES | NO
Specifies whether the HP Neoview Transporter truncates target tables (when loading) or target data files (when extracting) before job processing begins.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BL_USE_PIPE=YES | NO
Specifies a named pipe for data transfer.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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 9.3 Companion for UNIX Environments
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 9.3 Data Sets: 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 9.3 Companion for UNIX Environments
BUFSIZE= 0 | n | nK
Specifies the size of a permanent buffer page for an output SAS data set.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
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 9.3 Data Sets: Reference
BULK_BUFFER= numeric-value
Specifies the number of bulk rows that the SAS/ACCESS engine can buffer for output.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BULKEXTRACT=YES | NO
Rapidly retrieves (fetches) large number of rows from a data set.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BULKLOAD=YES | NO
Loads rows of data as one unit.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BULKUNLOAD=YES | NO
Rapidly retrieves (fetches) large number of rows from a data set.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
BYNOEQUALS=YES | NO
Specifies whether the output order of data set observations that have identical values for the BY variable is guaranteed to be in the data set order.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
BYSORT=YES | NO
Specifies for the SPD Engine to perform an automatic sort when it encounters a BY statement.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
CAST=YES | NO
Specifies whether SAS or the Teradata DBMS server should perform data conversions.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CNTLLEV=LIB | MEM | REC
Specifies the level of shared access to a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
COMMAND_TIMEOUT= number-of-seconds
Specifies the number of seconds to wait before a command times out.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
COMMAND_TIMEOUT= number-of-seconds
Specifies the number of seconds to wait before a command times out.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
COMPRESS= NO | YES | CHAR | BINARY
Specifies to compress SPD Engine data sets on disk as they are being created.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
COMPRESS=NO | YES | CHAR | BINARY
Specifies how observations are compressed in a new output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
CURSOR_TYPE=DYNAMIC | FORWARD_ONLY | KEYSET_DRIVEN | STATIC
Specifies the cursor type for read only and updatable cursors.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
CURSOR_TYPE=KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only cursors and for cursors to be updated.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
You can specify SAS/ACCESS data set options on a SAS data set when you access PC files data with the LIBNAME Statement Syntax for PC Files on Linux and UNIX.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCOMMIT= number-of-rows
Enables you to issue a commit statement automatically after a specified number of rows have been processed.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBCONDITION= "DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS data.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DBCONDITION= "DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCONDITION= SQL-query-clause
Specifies criteria for subsetting and ordering data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBCONSTRAINT='DBMS-SQL-clauses'
Provides table-level definitions to specify when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCREATE_TABLE_OPTS= 'DBMS-SQL-clauses'
Specifies DBMS-specific syntax to add to the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBCREATE_TABLE_OPTS= 'SQL-clauses'
Specifies data source-specific syntax to add to the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBENCODING= 12–byte SAS encoding-value
Specifies the encoding character set to use in the Microsoft Access database or in the Microsoft Excel workbook.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBFORCE=YES | NO
Specifies whether to force data truncation during insert processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBFORCE= YES | NO
Specifies whether to force the truncation of data during insert processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBGEN_NAME= DBMS | SAS
Specifies how SAS automatically renames columns (when they contain characters that SAS does not allow, such as $) to valid SAS variable names.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBGEN_NAME=DBMS | SAS
Specifies whether to rename columns automatically when they contain disallowed characters.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBINDEX=YES | NO | <'>index-name<'>
Detects and verifies that indexes exist on a DBMS table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBKEY= (<'> column-1 <'> < ... <'>column-n<'> >)
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
DBKEY=(<'> column-1 <'> <… <'> column-n <'> > )
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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
Document: SAS/ACCESS 9.3 Interface to PC Files: 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBLABEL=YES | NO
Specifies whether to use SAS variable labels as data source column names during output processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBLINK= database-link
Specifies a link from your local database to database objects on another server [Oracle]. Specifies a link from your default database to another database on the server to which you are connected [Sybase].
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBMASTER=YES
Designates which is the larger table when you process a join of tables from two different types of databases.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: 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: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBMAX_TEXT= integer
Determines the length of any very long DBMS character data type that is read into SAS or written from SAS when you are using a SAS/ACCESS engine.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBMAX_TEXT= integer
Determines the length 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
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBNULL= <_ALL_=YES | NO >
| ( < column-name-1=YES | NO> <…< column-name-n=YES | NO> > )
Indicates whether NULL is a valid value for the specified columns when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBNULL=
(< column-name-1 > =YES|NO
< column-name-n > =YES|NO
< _ALL_ > =YES|NO)
Specifies whether NULL is a valid value for the specified columns when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBNULLKEYS=YES | NO
Controls the format of the WHERE clause with regard to NULL values when you use the DBKEY= data set option.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBNULLKEYS= YES | NO
Controls the format of the WHERE clause when you use the DBKEY data set option.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBPROMPT=YES | NO
Specifies whether SAS displays a window that prompts you to enter DBMS connection information.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBSASLABEL=COMPAT | NONE
Specifies how the engine returns column labels.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBSASLABEL= COMPAT | NONE
Specifies whether SAS/ACCESS saves the data source's column names as SAS label names.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBSASTYPE=(< column-name-1 > =< SAS data-type > ...< column-name-n > =
< SAS data-type > )
Specifies data type(s) to override the default SAS data type(s) during input processing of data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DBSLICE=("WHERE-clause-1" "WHERE-clause-2" < ... " WHERE-clause-n"> )
DBSLICE=(< server=> "WHERE-clause-1" < server=> "
WHERE-clause-2" < … < server=> " WHERE-clause-n"> )
Specifies user-supplied WHERE clauses to partition a DBMS query for threaded reads.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
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/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DBTYPE=(< column-name-1 > =< data-source-type > ...
< column-name-1 > =< data-source-type > )
Specifies a data type to use instead of the default data source data type when SAS creates a data source table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
DEGREE=ANY | 1
Determines whether DB2 uses parallelism.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DIMENSION=YES | NO
Specifies whether the database creates dimension tables or fact tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DISTRIBUTE_ON='column-1 <... ,column-n>' | RANDOM
Specifies a column name to use in the DISTRIBUTE ON clause of the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DISTRIBUTED_BY='column-1 <... ,column-n>' | RANDOMLY DISTRIBUTED
Uses one or multiple columns to distribute table rows across database segments.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
DLDMGACTION=FAIL | ABORT | REPAIR | NOINDEX | PROMPT
Specifies the action to take when a SAS data set in a SAS library is detected as damaged.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
DROP= variable-1 <...variable-n>
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 9.3 Data Sets: Reference
ENCODING= ANY | ASCIIANY | EBCDICANY | encoding-value
Overrides the encoding to use for reading or writing a SAS data set.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
ENCRYPT=YES | NO
Specifies whether to encrypt an output SPD Engine data set.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
ENCRYPT=YES | NO
Specifies whether to encrypt an output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
ENDOBS= n
Specifies the end observation number in a user-defined range of observations to be processed.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
ERRLIMIT= integer
Specifies the number of errors that are allowed before SAS stops processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ERRLIMIT= integer
Specifies the number of errors that are allowed before SAS stops processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
EXPCOLUMNLEN= column-length
Specifies the default length of the SAS character column when a data item defined with expressions is encountered.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
EXTENDOBSCOUNTER=NO | YES
Specifies whether to extend the maximum observation count in a new output SAS data file.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
FETCH_IDENTITY=YES | NO
Returns the value of the last inserted identity value.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
FILECLOSE= DISP | LEAVE | REREAD | REWIND | FREE
Specifies how a tape is positioned when a SAS data set is closed.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILECLOSE=DISP | LEAVE | REREAD | REWIND
Specifies how a tape is positioned when a SAS data set is closed.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
FILEDISP= NEW | OLD
Specifies the initial disposition for a sequential access bound SAS library.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILTER=(<NOT> filter-1 < ... Boolean-operator <NOT> filter-n >)
Uses the filters that are defined in an information map to specify criteria for subsetting a result set.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
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 9.3 Data Sets: 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 9.3 Data Sets: Reference
GENNUM= integer
Specifies a particular generation of a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
IDXBY=YES | NO
Specifies whether to use an index when processing BY statements in the SPD Engine.
Product: Base SAS
Document: SAS 9.3 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 9.3 Data Sets: Reference
IDXWHERE=YES | NO
Specifies to use indexes when processing WHERE expressions in the SPD Engine.
Product: Base SAS
Document: SAS 9.3 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 9.3 Data Sets: Reference
IGNORE_READ_ONLY_COLUMNS=YES | NO
Specifies whether to ignore or include columns whose data types are read-only when generating an SQL statement for inserts or updates.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
IN= 'database-name.tablespace-name'|'DATABASE database-name'
Lets you specify the database or table space in which you want to create a new table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
IN= variable
Creates a Boolean variable that indicates whether the data set contributed data to the current observation.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
INDEX=(index-specification-1 ...< index-specification-n > )
Defines an index for a new output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
INSERT_SQL=YES | NO
Determines the method to use to insert rows into a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
INSERT_SQL=YES | NO
Determines the method to use to insert rows into a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
INSERTBUFF= positive-integer
Specifies the number of rows in a single DBMS insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
INSERTBUFF= number-of-rows
Specifies the number of rows in a single insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
IOBLOCKSIZE= n
Specifies the size in bytes of a block of observations to be used in an I/O operation.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
KEEP= variable-1 <...variable-n>
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 9.3 Data Sets: Reference
KEYSET_SIZE= number-of-rows
Specifies the number of rows in the cursor that the keyset drives.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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 9.3 Scalable Performance Data Engine: Reference
LOCATION= location-name
Lets you further specify exactly where a table resides.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
LOCKTABLE=EXCLUSIVE | SHARE
Places exclusive or shared locks on tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ML_CHECKPOINT= checkpoint-rate
Specifies the interval between checkpoint operations in minutes.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 a bulk-load operation.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 a bulk-load operation.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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-load operation.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
MULTILOAD=YES | NO
Specifies whether Teradata Insert and Append operations should use the Teradata MultiLoad utility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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 Interface to R/3
Document: SAS/ACCESS 4.4 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
NULLCHAR= YES | NO
Indicates how SAS character missing values are handled during insert, update, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
NULLCHARVAL= 'character-string'
Defines the character string that replaces missing SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
NULLCHARVAL= < 'character-string' >
Defines the character string that replaces SAS character missing values during insert, update, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
OBS= n | nK | nM | nG | nT | hexX | MIN | MAX
Specifies the last observation that SAS processes in a data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
OBSBUF= n
Determines the size of the view buffer for processing a DATA step view.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
ORHINTS= 'Oracle-hint'
Specifies Oracle hints to pass to Oracle from a SAS statement or SQL procedure.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
OUTREP= format
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS 9.3 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 9.3 Scalable Performance Data Engine: Reference
PARTITION_KEY='column-name'
Specifies the column name to use as the partition key for creating fact tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
PARTSIZE= n | nM | nG | nT
Specifies the maximum size (in megabytes, gigabytes, or terabytes) that the data component partitions can be. The value is specified when an SPD Engine data set is created. This size is a fixed size. This specification applies only to the data component files.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
POINTOBS=YES | NO
Specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
PW=password
Assigns a READ, WRITE, or ALTER password to a SAS file, and enables access to a password-protected SAS file.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
PW= password
Assigns a READ, WRITE, and ALTER password to a SAS file, and enables access to a password-protected SAS file.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
PWREQ=YES | NO
Specifies whether to display a dialog box to enter a SAS data set password.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
QUALIFIER= <qualifier-name>
Specifies the qualifier to use when you are reading database objects, such as DBMS tables and views.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
QUERY_BAND=pair-name=pair_value” FOR TRANSACTION;
Specifies whether to set a query band for the current transaction.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
READ= read-password
Assigns a READ password to a SAS file that prevents users from reading the file, unless they enter the password.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
READ_ISOLATION_LEVEL= DBMS-specific-value
Specifies which level of read isolation locking to use when you are reading data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
READBUFF= integer
Specifies the number of rows of DBMS data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
READBUFF= integer
Specifies the number of rows to hold in memory for input into SAS.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
READBUFF= < number-of-rows >
Specifies the number of rows of data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
RENAME=(old-name-1=new-name-1 < ...old-name-n=new-name-n > )
Changes the name of a variable.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
REPEMPTY=YES | NO
Specifies whether a new, empty data set can overwrite an existing SAS data set that has the same name.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
REPLACE=NO | YES
Specifies whether a new SAS data set that contains data can overwrite an existing data set that has the same name.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
REREAD_EXPOSURE= NO | YES
Specifies whether the SAS/ACCESS engine behaves like a random-access engine for the scope of the LIBNAME statement.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
REUSE=NO | YES
Specifies whether new observations can be written to freed space in compressed SAS data sets.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
ROLE= FACT | DIMENSION | DIM
Identifies the fact table for a star schema join.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SASDATEFMT=(< data-source-date-column-1 > =< SAS date-format > ...
< data-source-date-column-n > =< SAS date-format > )
Changes the SAS date format of a data source column.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
SCHEMA= schema-name
Allows reading of such database objects as tables and views in the specified schema.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SEGMENT_NAME= segment-name
Lets you control the segment in which you create a table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SET=YES | NO
Specifies whether duplicate rows are allowed when creating a table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SGIO= YES| NO
Activates the Scatter and Gather I/O feature for a data set.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
SLEEP= number-of-minutes
Specifies the number of minutes that MultiLoad waits before it retries logging in to Teradata.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
SORTEDBY= by-clause </ collate-name > | _NULL_
Specifies how a data set is currently sorted.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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 9.3 Data Sets: Reference
STARTOBS= n
Specifies the starting observation number in a user-defined range of observations to be processed.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
SYNCADD=YES|NO
Specifies to process one observation at a time or multiple observations at a time.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
TEMPORAL_QUALIFIER=CURRENT VALIDTIME
| VALIDTIME AS OF PERIOD 'period' | SEQUENCED VALIDTIME
| NONSEQUENCED VALIDTIME 'period'
TEMPORAL_QUALIFIER=CURRENT TRANSACTIONTIME
| TRANSACTIONTIME AS OF PERIOD 'period'
| NONSEQUENCED TRANSACTIONTIME
Specifies time-dimension criteria for retrieving data from Teradata.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TENACITY= number-of-hours
Specifies how many hours MultiLoad continues to retry logging on to Teradata if the maximum number of Teradata utilities are already running.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
THREADNUM= n
Specifies the maximum number of I/O threads the SPD Engine can spawn for processing an SPD Engine data set.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
TOBSNO= n
Specifies the number of observations to send in a client/server transfer.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TPT_PACKMAXIMUM= YES | NO
Specifies whether to pack the maximum possible or default number of statements into Multi-Statement insert requests when using the TPT API.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TPT_TRACE_OUTPUT= integer
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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TRAP151=YES | NO
Enables removal of columns that cannot be updated from a FOR UPDATE OF clause so that update of columns can proceed as normal.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
TYPE= data-set-type
Specifies the data set type for a specially structured SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
UNIQUESAVE=YES|NO
Specifies to save observations with nonunique key values (the rejected observations) to a separate data set when appending or inserting observations to data sets with unique indexes.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
UPDATE_ISOLATION_LEVEL= DBMS-specific-value
Defines the degree of isolation of the current application process from other concurrently running application processes.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 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
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
USEDIRECTIO=
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 9.3 Companion for UNIX Environments
WHERE=(where-expression-1<logical-operator where-expression-n>)
Specifies specific conditions to use to select observations from a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
WHERENOINDEX=(name1 name2...)
Specifies a list of indexes to exclude when making WHERE expression evaluations.
Product: Base SAS
Document: SAS 9.3 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 9.3 Data Sets: Reference
WRITE= write-password
Assigns a WRITE password to a SAS file that prevents users from writing to a file, unless they enter the password.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference