Data Set Options Syntax Alphabetically


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 used
Product: Base SAS
Document: Base SAS Guide to Information Maps
ALQ= allocation-quantity
Specifies how many disk blocks to initially allocate to a new SAS data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
ALQMULT= n
Specifies the number of pages that are preallocated to a file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
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 Companion for z/OS
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 Companion for the 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 Companion for OpenVMS on HP Integrity Servers
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 Language Reference: Dictionary
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
AUTHID= authorization-ID
Lets you qualify the specified table with an authorization ID, user ID, or group ID.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
AUTOCOMMIT=YES | NO
Specifies whether to enable the DBMS autocommit capability.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
AUTOCOMMIT=YES | NO
Determines whether the ACCESS engine commits (saves) updates as soon as the user submits them.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
AUTOCOMMIT=YES | NO
Determines whether the ACCESS engine commits (saves) updates as soon as the user submits them.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
BKS= bucket-size
Specifies the bucket size for a new data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
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 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 for Relational Databases: Reference
BL_BADDATA_FILE= filename
Specifies where to put records that failed to process internally.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 for Relational Databases: Reference
BL_CODEPAGE= numeric-codepage-ID
Identifies the codepage that the DBMS engine uses to convert SAS character data to the current database codepage during bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 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 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 for Relational Databases: Reference
BL_DATAFILE= path-and-data-filename
Identifies the file that contains control statements.
Product: SAS/ACCESS
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
Document: SAS/ACCESS 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 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 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 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 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 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 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 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 for Relational Databases: Reference
BL_DB2LDCT2='string'
Specifies a string in the LOAD utility control statement between INTO TABLE table-name and (field-specification).
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BL_DB2LDCT3='string'
Specifies a string in the LOAD utility control statement after (field-specification).
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 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 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 for Relational Databases: Reference
BL_DB2PRNLOG= YES | NO
Determines whether to write SYSPRINT output to the SAS log.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 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 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 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 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 for Relational Databases: Reference
BL_DB2TBLXST= YES | NO
Indicates whether the LOAD utility runs against an existing table.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 for Relational Databases: Reference
BL_DELETE_DATAFILE=YES | NO
Deletes the data file that is created for the DBMS bulk-load facility.
Product: SAS/ACCESS
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 load or bulk unload.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BL_DIRECT_PATH=YES | NO
Sets the Oracle SQL*Loader DIRECT option.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 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 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 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 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 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 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 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 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 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 for Relational Databases: Reference
BL_LOAD_REPLACE=NO | YES
Specifies whether DB2 appends or replaces rows during bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 for Relational Databases: Reference
BL_METHOD=CLILOAD
Specifies which bulk-load method to use for DB2.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BL_OPTIONS='< option…,option > ' [DB2 UNIX/PC, OLE DB, Oracle] BL_OPTIONS='<< option > > << value> ... '> [Netezza]
Passes options to the DBMS bulk-load facility, which affects how it loads and processes data.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BL_PARFILE= < parse-file >
Creates a file that contains the SQL*Loader command line options.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BL_PORT_MAX= < integer >
Sets the highest available port number for concurrent uploads.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BL_PORT_MIN= < integer >
Sets the lowest available port number for concurrent uploads.
Product: SAS/ACCESS
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
Document: SAS/ACCESS for Relational Databases: Reference
BL_RECOVERABLE=YES | NO
Determines whether the LOAD process is recoverable.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 for Relational Databases: Reference
BL_RETURN_WARNINGS_AS_ERRORS=YES | NO
Specifies whether SQL*Loader (bulkload) warnings should surface in SAS through the SYSERR macro as warnings or as errors.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 for Relational Databases: Reference
BL_SERVER_DATAFILE= path-and-data-filename
Specifies the name and location of the data file that the DB2 server instance sees.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BL_SQLLDR_PATH= pathname
Specifies the location of the SQLLDR executable file.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 for Relational Databases: Reference
BL_SYNCHRONOUS=YES | NO
Specifies how to process source file record sets.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 for Relational Databases: Reference
BL_TENACITY= number-of-seconds
Specifies how long the HP Neoview Transporter waits before retrying.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 for Relational Databases: Reference
BL_USE_PIPE=YES | NO
Specifies a named pipe for data transfer.
Product: SAS/ACCESS
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
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
Document: SAS/ACCESS 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 Companion for the 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 Language Reference: Dictionary
BUFSIZE= 0 | n | nK
Specifies the size of a permanent buffer page for an output SAS data set.
Product: Base SAS
Document: SAS 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 Companion for the UNIX Environments
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 Companion for OpenVMS on HP Integrity Servers
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 Language Reference: Dictionary
BULKEXTRACT=YES | NO
Rapidly retrieves (fetches) large number of rows from a data set.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BULKLOAD=YES | NO
Loads rows of data as one unit.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
BULKUNLOAD=YES | NO
Rapidly retrieves (fetches) large number of rows from a data set.
Product: SAS/ACCESS
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
Document: SAS/ACCESS for Relational Databases: Reference
BYNOEQUALS=YES | NO
Specifies whether the output order of data set observations that have identical values for the BY variable is guaranteed to be in the data set order.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
BYSORT=YES | NO
Specifies for the SPD Engine to perform an automatic sort when it encounters a BY statement.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
CACHENUM= n
Specifies the number of I/O data caches used per SAS file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
CACHESIZE= n | nK | nM | nG | hexX
Controls the size of the I/O data cache that is allocated for a SAS file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
CAST=YES | NO
Specifies whether SAS or the Teradata DBMS server should perform data conversions.
Product: SAS/ACCESS
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
Document: SAS/ACCESS for Relational Databases: Reference
CNTLLEV=MEM | REC
Specifies the level of shared access to SAS data sets.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
CNTLLEV=LIB | MEM | REC
Specifies the level of shared access to a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
COMMAND_TIMEOUT= number-of-seconds
Specifies the number of seconds to wait before a command times out.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
COMMAND_TIMEOUT= number-of-seconds
Specifies the number of seconds to wait before a command times out.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
COMMAND_TIMEOUT= number-of-seconds
Specifies the number of seconds to wait before a command times out.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: 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 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 Language Reference: Dictionary
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 Interface to PC Files: Reference
CURSOR_TYPE=DYNAMIC | FORWARD_ ONLY | KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only cursors and cursors to update.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: 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 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 Interface to PC Files: Reference
DBCOMMIT= number-of-rows
Lets you issue a commit statement automatically after a specified number of rows have been processed.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: 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 for Relational Databases: Reference
DBCONDITION= "SQL-query-clause"
Specifies criteria for subsetting and ordering data.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBCONDITION= "SQL-query-clause"
Specifies criteria for subsetting and ordering data.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBCONDITION= "DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS data.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
DBCREATE_TABLE_OPTS= 'SQL-clauses'
Specifies data source-specific syntax to be added to the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBCREATE_TABLE_OPTS= 'SQL-clauses'
Specifies data source-specific syntax to add to the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBCREATE_TABLE_OPTS= 'DBMS-SQL-clauses'
Specifies DBMS-specific syntax to add to the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
DBENCODING='12–byte-SAS-encoding-value';
Specifies the encoding character set to use in the Microsoft Access database or in the Excel workbook file.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBFORCE=YES | NO
Specifies whether to force the truncation of data during insert processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBFORCE=YES | NO
Specifies whether to force the truncation of data during insert processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBFORCE=YES | NO
Specifies whether to force the truncation of data during insert processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 Interface to PC Files: Reference
DBGEN_NAME=DBMS | SAS
Specifies whether to rename columns automatically when they contain disallowed characters.
Product: SAS/ACCESS
Document: SAS/ACCESS 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
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
Document: SAS/ACCESS for Relational Databases: Reference
DBKEY= (<'>column-1<'> <... <'>column-n<'>>)
Improves performance for a join with a large data source table and a small SAS data set (specifies a column to use as an index).
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBKEY= (<'>column-1<'> <... <'>column-n<'>>)
Improves performance by specifying a column to use as an index when you process a join that involves a large data source table and a small SAS data set.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBKEY=(<'> column-1 <'> <… <'> column-n <'> > )
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
DBLABEL=YES | NO
Specifies whether to use SAS variable labels as data source column names during output processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: 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 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 for Relational Databases: Reference
DBLINK= database-link
Specifies a link from your local database to database objects on another server [Oracle]. Specifies a link from your default database to another database on the server to which you are connected [Sybase].
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
DBMASTER= YES
Designates which table is the larger table when you are processing a join that involves tables from two different types of databases.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 Interface to PC Files: 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 Interface to PC Files: 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 for Relational Databases: Reference
DBNULL= (column-name-1=YES | NO <...column-name-n=YES | NO > |_ALL_=YES | NO)
Indicates whether NULL is a valid value for the specified columns when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
DBNULL= (column-name-1=YES | NO <...column-name-n=YES | NO > |_ALL_=YES | NO)
Indicates whether NULL is a valid value for the specified columns when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 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 Interface to PC Files: 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 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 for Relational Databases: Reference
DBPROMPT=YES | NO
Specifies whether SAS displays a window that prompts you to enter DBMS connection information.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 Interface to PC Files: Reference
DBSASLABEL=COMPAT | NONE
Specifies how the engine returns column labels.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 Interface to PC Files: Reference
DBSASTYPE= (column-name-1=<'>SAS-data-type<'> <...column-name-n=<'>SAS-data-type<'>>)
Specifies one or more data types to override one or more default SAS data types during input processing of data.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 for Relational Databases: Reference
DBSLICE=("WHERE-clause-1" " WHERE-clause-2" < ... "WHERE-clause-n"> ) DBSLICE=(< server=> "WHERE-clause-1" < server=> " WHERE-clause-2" < … < server=> "WHERE-clause-n"> )
Specifies user-supplied WHERE clauses to partition a DBMS query for threaded reads.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
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 for Relational Databases: Reference
DBTYPE= (column-name-1=<'>data-source-type<'> <...column-name-n=<'>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 Interface to PC Files: Reference
DBTYPE= (column-name-1=<'>data-source-type<'> <...column-name-n=<'>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 Interface to PC Files: 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 for Relational Databases: Reference
DDBCOMIT= n
Specifies the number of rows that will be processed before a database COMMIT statement is issued.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBERLMT= n
Specifies the number of errors that are used before SAS stops processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBKEY='default-key'
Specifies a Default Key.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBLOAD= 0|1
Specifies a fast-loading process.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBLOCK= 0|1
Suppresses the creation of an interface spool file.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBPW='password'
Specifies a CA-DATADICTIONARY password.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBSV='status/version'
Specifies the status and version of the CA-Datacom/DB table that you want to access.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBTRACE= 0|1
Displays information for debugging purposes.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBURT='User-Requirements-Table-name'
Specifies the URT that will be used by the interface view engine when it opens the view descriptor.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DDBUSER='userid'
Specifies the CA-DATADICTIONARY userid.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
DEGREE= ANY | 1
Determines whether DB2 uses parallelism.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
DEQ= default-file-extension-quantity
Specifies how many disk blocks to add when OpenVMS automatically extends a SAS data set during a write operation.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
DEQMULT= n
Specifies the number of pages to extend a SAS file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
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 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 Language Reference: Dictionary
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 Language Reference: Dictionary
ENCODING= ANY | ASCIIANY | EBCDICANY | encoding-value
Overrides the encoding to use for reading or writing a SAS data set.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
ENCRYPT=YES | NO
Specifies whether to encrypt an output SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
ENCRYPT=YES | NO
Specifies whether to encrypt an output SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
ENDOBS= n
Specifies the end observation number in a user-defined range of observations to be processed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
ERRLIMIT= integer
Specifies the number of errors that are allowed before SAS stops processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: 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 Interface to PC Files: 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 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
Document: SAS/ACCESS 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 Guide to Information Maps
FILECLOSE= FREE | LEAVE | REREAD | REWIND
Specifies how a tape is positioned when a SAS data set is closed.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
FILECLOSE=DISP | LEAVE | REREAD | REWIND
Specifies how a tape is positioned when a SAS data set is closed.
Product: Base SAS
Document: SAS Language Reference: Dictionary
FILEDISP=NEW | OLD
Specifies the initial disposition for a sequential access bound SAS library.
Product: Base SAS
Document: SAS 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 in a query for subsetting a result set
Product: Base SAS
Document: Base SAS 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 Language Reference: Dictionary
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 Language Reference: Dictionary
GENNUM= integer
Specifies a particular generation of a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
IDXBY=YES | NO
Specifies whether to use an index when processing BY statements in the SPD Engine.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
b IDXNAME= index-name
Directs SAS to use a specific index to match the conditions of a WHERE expression.
Product: Base SAS
Document: SAS Language Reference: Dictionary
IDXWHERE=YES | NO
Specifies to use indexes when processing WHERE expressions 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 Language Reference: Dictionary
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 for Relational Databases: Reference
IN= 'database-name.tablespace-name'|'DATABASE database-name'
Lets you specify the database or tablespace in which you want to create a new table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
IN= variable
Creates a Boolean variable that indicates whether the data set contributed data to the current observation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
INDEX=(index-specification-1 ...< index-specification-n > )
Defines an index for a new output SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
INSERTBUFF= number-of-rows
Specifies the number of rows in a single insert.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
INSERTBUFF= number-of-rows
Specifies the number of rows in a single insert.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
INSERTBUFF= positive-integer
Specifies the number of rows in a single DBMS insert.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
INSERT_SQL=YES | NO
Determines the method that is used to insert rows into a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
INSERT_SQL=YES | NO
Determines the method to use to insert rows into a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
INSERT_SQL=YES | NO
Determines the method to use to insert rows into a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
IOBLOCKSIZE= n
Specifies the size in bytes of a block of observations to be compressed.
Product: Base SAS
Document: SAS 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 Language Reference: Dictionary
KEYSET_SIZE= number-of-rows
Specifies the number of rows in the cursor that the keyset drives.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
LIBNAME libref pcfiles < connection-options > < libname-options > ; LIBNAME libref CLEAR | _ALL_ CLEAR; LIBNAME libref LIST | _ALL_ LIST;
Associates a SAS libref with a workbook, database, or ODBC data source.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
LIBNAME libref < engine-name > < physical-file-name > < SAS/ACCESS-engine-connection-options > < SAS/ACCESS-libname-options > ; LIBNAME libref CLEAR | _ALL_ CLEAR; LIBNAME libref LIST | _ALL_ LIST;
Associates a SAS libref with a workbook or database.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: 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
LOCATION= location-name
Lets you further specify exactly where a table resides.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
LOCKREAD=YES | NO
Specifies whether to read a record if a lock cannot be obtained for the record.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
LOCKTABLE=EXCLUSIVE | SHARE
Places exclusive or shared locks on tables.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
LOCKWAIT=YES | NO | n
Indicates whether SAS should wait for a locked record.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
MBF= multibuffer-count
Specifies the multibuffer count for a data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
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 for Relational Databases: Reference
ML_CHECKPOINT= checkpoint-rate
Specifies the interval between checkpoint operations in minutes.
Product: SAS/ACCESS
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 a bulk-load operation.
Product: SAS/ACCESS
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 a bulk-load operation.
Product: SAS/ACCESS
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-load operation.
Product: SAS/ACCESS
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
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
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
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
Document: SAS/ACCESS 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 Interface to PC Files: Reference
NULLCHAR= YES | NO
Indicates how SAS character missing values are handled during insert, update, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
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 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 Interface to PC Files: 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 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
Document: SAS/ACCESS for Relational Databases: Reference
OBS= n | nK | nM | nG | nT | hexX | MIN | MAX
Specifies the last observation that SAS processes in a data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
OBSBUF= n
Determines the size of the view buffer for processing a DATA step view.
Product: Base SAS
Document: SAS Language Reference: Dictionary
ORHINTS= 'Oracle-hint'
Specifies Oracle hints to pass to Oracle from a SAS statement or SQL procedure.
Product: SAS/ACCESS
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
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
Document: SAS/ACCESS for Relational Databases: Reference
OUTREP= format
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
OUTREP= format
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
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
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
POINTOBS=YES | NO
Specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed.
Product: Base SAS
Document: SAS Language Reference: Dictionary
PRESERVE_COL_NAMES=NO | YES
Preserves spaces, special characters, and case sensitivity in DBMS column names when you create DBMS tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 Companion for the 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 Language Reference: Dictionary
PWREQ=YES | NO
Specifies whether to display a dialog box to enter a SAS data set password.
Product: Base SAS
Document: SAS Language Reference: Dictionary
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 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 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 Language Reference: Dictionary
READBUFF= number-of-rows
Specifies the number of rows of data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
READBUFF= number-of-rows
Specifies the number of rows of data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
READBUFF= integer
Specifies the number of rows of DBMS data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 Guide to Information Maps
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 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 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 for Relational Databases: 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 Language Reference: Dictionary
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 Language Reference: Dictionary
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 Language Reference: Dictionary
REUSE=NO | YES
Specifies whether new observations can be written to freed space in compressed SAS data sets.
Product: Base SAS
Document: SAS Language Reference: Dictionary
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 Interface to PC Files: 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 Interface to PC Files: 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 for Relational Databases: Reference
SCHEMA= schema-name
Lets you read a data source (such as a DBMS table and view) in the specified schema.
Product: SAS/ACCESS
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
Document: SAS/ACCESS for Relational Databases: Reference
SET=YES | NO
Specifies whether duplicate rows are allowed when creating a table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
SGIO= YES| NO
Activates the Scatter/Gather I/O feature for a data set.
Product: Base SAS
Document: SAS 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 for Relational Databases: Reference
SORTEDBY= by-clause </ collate-name > | _NULL_
Specifies how a data set is currently sorted.
Product: Base SAS
Document: SAS Language Reference: Dictionary
SPILL=YES | NO
Specifies whether to create a spill file for non-sequential processing of a DATA step view.
Product: Base SAS
Document: SAS Language Reference: Dictionary
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.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: 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 for Relational Databases: Reference
THREADNUM= n
Specifies the maximum number of I/O threads the SPD Engine can spawn for processing an SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
TOBSNO= n
Specifies the number of observations to send in a client/server transfer.
Product: Base SAS
Document: SAS Language Reference: Dictionary
TRAP151=YES | NO
Enables columns that cannot be updated to be removed from a FOR UPDATE OF clause so updating of columns can proceed as normal.
Product: SAS/ACCESS
Document: SAS/ACCESS 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 Language Reference: Dictionary
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 Scalable Performance Data Engine: 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 for Relational Databases: 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 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 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 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 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 Companion for the 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 Language Reference: Dictionary
WHERENOINDEX=(name1 name2...)
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 Language Reference: Dictionary
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 Language Reference: Dictionary