LIBNAME Statement Options Listed Alphabetically
|
Name
|
Syntax and Description
|
|---|---|
|
ABAP_NAMESPACE= namespace
Indicates the namespace for ABAP functions and programs
that SAS uses.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
ABAPFM= abap_function_name
Indicates the name of the ABAP function module
that SAS uses.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
ABAPPROG= abap_program
Indicates the name of the ABAP program that SAS
uses.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
ACCESS=READONLY
Determines the access level with which a libref
connection is opened.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ACCESS= READONLY
Determines the access level with which a libref
connection is opened.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
ACCESS= READONLY
Determines the access level with which a libref
connection is opened.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
ACCESS=READONLY | TEMP
Assigns an access attribute to the SAS library.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
ACCESS=READONLY
Determines the access level of the data source.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
ACCOUNT=<'>account_ID<' >
Specifies an account number that you want to charge for the Teradata
session.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ACLGRP=acl-group
Names an ACL group that has been previously assigned
to the SPD Server user ID.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
ACLSPECIAL=NO | YES
Invokes special access to SPD Server resources in
the server domain for a server user. The special privilege must already
exist in the password database.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS=YES | NO
Specifies whether to adjust the lengths of CHAR
or VARCHAR data type columns with byte semantic column lengths.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ADJUST_NCHAR_COLUMN_LENGTHS=YES | NO
Specifies whether to adjust the lengths of NCHAR
or NVARCHAR data type columns.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ADMIN=name
Specifies an administrator's name for Access Control Lists (ACLs) in Parquet
files.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
ADMINPASS=password
Specifies the administrator's password for Access Control Lists (ACLs) in
Parquet files.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
ALLOW_LARGE_RESULTS=ALWAYS | MUST | OFF
Specifies whether to allow query results larger than the Google BigQuery
maximum response size.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ALLOW_SELF_SIGNED_CERTS=NO | YES
Enables or disables SSL wire encryption of client requests.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ANALYZE=YES | NO
Lets SAS improve performance when a single Hive store table is
queried.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
API_TRACE=YES | NO
Specifies whether to display the number of API calls
that are made during a SAS session while connected to Salesforce.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
APPLICATIONNAME=name
Specifies the client application’s name for
auditing purposes.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
APPLICATIONNAME=name
Specifies the client application’s name for
auditing purposes.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
ASHOST= application_server_host
Indicates the host name or IP address of a specific
SAP application server.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
AUTH=AUTO | KERBEROS | LDAP | PASSWORD
Specifies the authorization method that is used to authenticate to an external
data source.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
AUTH=OAUTH2 | PASSWORD
Specifies the authorization method that is used to access Microsoft
Azure.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
AUTHDOMAIN=authentication_domain
Indicates the name of the metadata-based authentication domain to use to
associate user name and password credentials with an identity.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
AUTHDOMAIN=authentication-domain
Allows connection to a server by specifying the name of an authentication
domain object.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
AUTHDOMAIN=authentication-domain
Allows connection to a server by specifying the name of an authentication
domain object.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
AUTHDOMAIN=authentication-domain
Enables connection to SPD Server by specifying the
name of an authentication domain.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
AUTHENDPOINT=authorization-endpoint
Specifies the authorization endpoint to use.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
AUTHSCOPE="scope"
Specifies the Microsoft Azure resource and permissions that are required for
authorizing access.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
AUTHTYPE=OAUTH2
Specifies authentication to Microsoft Entra ID (formerly Azure Active Directory)
using single sign-on.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
AUTOCOMMIT=YES | NO
Indicates whether updates are committed immediately
after they are submitted.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
AUTOCOMMIT= YES | NO
Indicates whether updates are committed immediately
after they are submitted.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
AUTOCOMMIT= YES | NO
Specifies whether updates are committed immediately after they are
submitted.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
AUTOMAP=REPLACE | REUSE
Specifies to automatically generate an XMLMap file
to import an XML document.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
BATCH= Y | N
Indicates whether SAS should use SAP batch jobs
for data extracts.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
BATCH_UPDATE=YES | NO
Specifies whether to use batch update to write data to your external data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BINARY_BYTE_LIMIT=n
Specifies the maximum length for binary columns
that do not have a defined length.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
BL_ACCOUNTNAME="account-name"
Specifies the name of the account to use on the
external storage system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_APPLICATIONID="string"
Specifies the application ID (a GUID string) for
accessing the external storage system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_AWS_CONFIG_FILE=path-and-file-name
Specifies the location of the AWS configuration
file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_AWS_CREDENTIALS_FILE=path-and-file-name
Specifies the path to the credentials file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_AWS_PROFILE_NAME=profile-name
Specifies the AWS profile to use when there is more
than one profile in the AWS configuration file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_AZURE_SAS=value
Specifies the Azure shared access signature token value.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_BADFILE=path-and-file-name
Identifies a file that contains records that were rejected during bulk
loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_BUCKET='<bucket-name>'
Specifies the bucket name to use when transferring
data files in bulk.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_COMPRESS=YES | NO
Specifies whether to compress data files using the
gzip format.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_CONFIG='<path-and-file-name>'
Specifies the location of the optional configuration
file that the SAS communication layer uses to interact with the Amazon
S3 tool.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_CONTROL=path-and-control-file-name
Identifies the file that contains control statements.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DATAFILE=path-and-data-file-name
Specifies the file that contains DBMS data for bulk loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DEFAULT_DIR='host-specific-directory-path'
Specifies where bulk loading creates all intermediate
files.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DELETE_DATAFILE=YES | NO
Specifies whether to delete only the data file (NO) or all files that the
SAS/ACCESS engine creates (YES) for the DBMS bulk-load facility.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DELETE_ONLY_DATAFILE=YES | NO
Specifies whether to delete the data file that the SAS/ACCESS engine creates for
the DBMS bulk-load facility.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DELIMITER='<any-single-character>'
Specifies override of the default delimiter character
for separating columns of data during bulk loading or unloading (retrieval).
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DIRECT_PATH=YES | NO
Specifies the Oracle SQL*Loader DIRECT option.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DISCARDFILE=path-and-discard-file-name
Specifies the file that contains records that were filtered from bulk loading
because they did not match the criteria as specified in the CONTROL file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_DNSSUFFIX="network-storage-host-name"
Specifies the network host name where the storage
system resides.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_ENCKEY=encryption-key-name
Specifies the name of the encryption key to use when you access an Amazon S3
environment.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FILESYSTEM="file-system-name"
Specifies the name of the file system within the external storage
system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FOLDER="file-path-and-folder"
Specifies the folder or file path for the data in
the external storage system.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FORMAT=CSV | ORC | PARQUET | TEXT
Specifies the format of the bulk-load staging file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_FORMAT_OPT="option" | "option-value"
Specifies formatting options for CSV files.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_HOST='host-name'
Specifies the WebHDFS host name or IP address of the server where the external
data file is stored.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_IAM_ASSUME_ROLE_ARN="ARN-value"
Specifies an Amazon Resource Name (ARN) that identifies
an IAM role.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_IAM_ASSUME_ROLE_NAME="value"
Specifies an AWS IAM role name that enables you to connect to an Amazon S3
environment.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_IAM_ROLE='role-value'
Specifies an optional Amazon Web Services IAM role to use for the COPY
command.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_IDENTITY="identity-value"
Specifies the authentication method for the COPY
command.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_INDEX_OPTIONS='any valid SQL*Loader Index option'
segment-name
Enables you to specify SQL*Loader Index options with bulk
loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_INFORMIXDIR="directory-path"
Specifies the location of the Informix SDK installation.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_KEY=key-value
Specifies the Amazon Web Services access key that
is used with key-based access control.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_LOAD_METHOD=APPEND | INSERT
| REPLACE
| TRUNCATE
Specifies the method by which data is loaded into a table during bulk
loading.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_LOG=<'>file-name<'>
Specifies the name of the error file where all errors
are written when BULKLOAD=YES.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_MAXERRORS=value
Specifies the maximum number of rejected rows that
are allowed in the load before the COPY command is canceled.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_NUM_DATAFILES=value
Specifies the number of data files to create to contain the source
data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_NUM_READ_THREADS=value
Specifies the number of threads to use for bulk
unloading from the DBMS into SAS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_OPTIONS='option-1<, option-2<,..., option-N>>'
BL_OPTIONS='option-1=value-1 <, option-2=value-2 <... option-N=value-N>>'
Passes to the DBMS bulk-load facility options that affect how it loads and
processes data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PARFILE=<parameter-file>
Specifies a file that contains the SQL*Loader command-line
options.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_PRESERVE_BLANKS=YES | NO
Determines how the SQL*Loader handles requests to insert blank spaces into
CHAR/VARCHAR2 columns with the NOT NULL constraint.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_RECOVERABLE=YES | NO
Determines whether the LOAD process is recoverable.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_REGION=region
Specifies the Amazon Web Services (AWS) region from
which data is being retrieved.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_RETURN_WARNINGS_AS_ERRORS=YES | NO
Specifies whether SQL*Loader (bulk-load) warnings should be displayed in SAS
through the SYSERR macro as warnings or errors.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_SECRET=secret-access-key
Specifies the secret access key that is used when
you transfer data in bulk.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_SUPPRESS_NULLIF=(_ALL_=YES | NO)
BL_SUPPRESS_NULLIF=(column-name-1=YES | NO)< ... column-name-N=YES | NO>)
Specifies whether to suppress the NULLIF clause for the specified columns to
increase performance when a table is created.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_TIMEOUT=value
Specifies the maximum completion time for a storage
task, in seconds.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_TOKEN=temporary-token
Specifies a temporary token that is associated with
the temporary credentials that you specify with the BL_KEY= and BL_SECRET=
options.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_ESCAPE=YES | NO
Specifies whether to escape a predefined set of
special characters during bulk loading or bulk retrieval.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_LOG=YES | NO
Specifies whether to get reports on rejected rows
and the corresponding error file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_PIPE=YES | NO
Specifies whether to use a named pipe for data transfer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_USE_SSL=YES | NO
Specifies whether to use TLS encryption for connections to Amazon
S3.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BL_WRITEBUFF=value
Specifies the number of rows to buffer in memory before writing to your data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BLBYTES=number-of-bytes
Modifies the size of the cached rowsets used in bulk
loading.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
BLBYTES=number-of-bytes
Modifies the size of a bulkload transfer, specified as bytes.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BLCOMMIT=unsigned-integer
Specifies the maximum number of rows that can be inserted before a bulk load
commit occurs.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
BLERRLIMIT=number-of-errors
Specifies the number of insertion errors that are allowed before bulk loading
is terminated.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
BLERRLIMIT=number-of-errors
Specifies the number of insertion errors that are allowed before bulk loading is
terminated.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BLROWS=number-of-rows
Modifies the number of rows in the cached rowsets that are used in bulk
loading.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
BLROWS=number-of-rows
Modifies the number of rows in a bulkload transfer.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BLSERVER=0 | OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Modifies the settings for server-side bulk loading.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
BLSERVER=0 | OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Modifies the settings for server-side bulk loading.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BLWARNLIMIT=number-of-warnings
Specifies the number of warning messages that are
allowed before bulk loading is terminated.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
BLWARNLIMIT=number-of-warnings
Specifies the number of warning messages that are
allowed before bulk loading is terminated.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BUFFER_SIZE=buffersize
Sets the minimum buffer size for data transfers
in batch and dialog modes.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
BULK_API=YES | NO
Determines whether SAS uses the Salesforce Bulk
API to insert and retrieve data from a Salesforce database.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
BULK_REFRESH=value
Specifies how often bulk load requests are checked
for completion.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
BULK_TIMEOUT=value
Specifies the timeout period for bulk load operations.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
BULKLOAD=YES | NO
Determines whether SAS uses a data source utility to insert data into a data
source table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BULKLOAD=0
| OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Specifies whether to use bulk loading to improve performance.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
BULKLOAD=0 | OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Enables bulk loading for the engine to improve performance.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
BULKUNLOAD=YES | NO
Rapidly retrieves (fetches) a large number of rows
from an external data set.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
BYSORT=YES | NO
Specifies the SPD Engine to perform an automatic
sort when it encounters a BY statement.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
BYSORT=NO | YES
Specifies whether to use implicit automatic SPD
Server sorts on BY clauses.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
CASLIB=caslib-reference-name
Specifies the name of the caslib to use for engine
operations in the LIBNAME statement.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
CAST=YES | NO
Specifies whether SAS or the Teradata DBMS server performs data
conversions.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CAST_OVERHEAD_MAXPERCENT=n
Specifies the overhead limit for data conversions to perform in Teradata
instead of SAS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CHAR_AS_NCHAR=YES | NO
Specifies the default character type to use for
table columns.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CHAR_COLUMN_LIMIT=n
Specifies the maximum length for character columns
that do not have a defined length.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
CHARMULTIPLIER=value
Expands column (variable) lengths by a multiplier
value.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
CHNGPASS=NO | YES
Specifies whether to prompt a server user for a
change of password.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
CLASSPATH=directory-path
Specifies additional resources, including JDBC drivers, to add to the JDBC
class path.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CLIENT= client
Specifies the SAP logon parameter client.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
CLIENT_ENCODING='encoding'
Specifies the encoding to use when transferring
data from your DBMS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CLIENT_ID=ID-value
Specifies the client ID value for the OAuth client that is used to connect to
Google BigQuery using the OAuth authentication method.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CLIENT_SECRET=authentication-secret
Specifies the client secret value for the OAuth client that is used to connect
to Google BigQuery using the OAuth authentication method.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
COMPRESS=YES | NO
Requests that the CAS table is compressed.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
COMPRESS= NO | YES | CHAR | BINARY
Specifies the compression of rows in output tables.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
COMPRESS= NO | YES | CHAR | BINARY
Specifies the compression of rows in output tables.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
COMPRESS=NO | BROTLI | GZIP | LZ4 | LZ4_HADP | SNAPPY | ZLIB | ZSTD
Controls the compression for new output tables.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
COMPRESS=NO | CHAR | BINARY
Controls the compression of observations in output SAS data sets for a SAS
library.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
COMPRESS=NO | YES | BINARY
Specifies to compress an SPD Engine data set on disk as it is being created.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
CONNECTION=
SHAREDREAD | UNIQUE | SHARED | GLOBALREAD | GLOBAL
Specifies whether operations on a single libref share a connection to the DBMS
and whether operations on multiple librefs share a connection to the
DBMS.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
CONNECTION= GLOBAL | GLOBALREAD | SHARED | SHAREDREAD | UNIQUE
Specifies whether operations on single or multiple
librefs can share a connection to the DBMS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CONNECTION= SHARED | SHAREDREAD | UNIQUE
Specifies whether operations on a single libref can share a connection to the
DBMS.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
CONNECTION_GROUP=
connection-group-name
Causes operations on multiple librefs and on multiple pass-through facility
CONNECT statements to share a connection to the DBMS.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
CONNECTION_GROUP=connection-group-name
Causes operations on multiple librefs and on multiple
SQL pass-through facility CONNECT statements to share a connection
to the DBMS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CONOPTS='connection_option1<;connection_option2...>';
Specifies database-specific connection options to use when
connecting.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CONOPTS=
"options"
Specifies optional connection options to pass to SAS Federation
Server.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
CONTEXTROOT="HTTP-context-root"
Specifies the context root to use in the HTTPS URL
for an HTTP reverse proxy.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
CONTEXTROOT="HTTP-context-root"
Specifies the context root to use in the HTTPS URL
for an HTTP reverse proxy.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
CRED_PATH='path-and-filename'
Specifies the location of a credential file that enables authentication to
Google Cloud Platform.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
CURSOR_TYPE=DYNAMIC | FORWARD_ONLY | KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only and updatable
cursors.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LIBNAME
libref
'SAS-library'
<CVPBYTES=bytes>CVPENGINE=V9<CVPEXCLUDE=variable
expression><CVPFORMATWIDTH=YES | NO><CVPINCLUDE=variable
expression><CVPMULTIPLIER=multiplier>;
Reduce the risk of truncation when character variables are
transcoded.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
DATA_BLOCK_SIZE=n | nK | nM | nG
Requests a stripe size for an ORC table during creation
(output).
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
DATABASE=<'>database-name<' >
Specifies the database that you want to access.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DATALIMIT=integer | integerK | integerM | integerG | ALL
Specifies the maximum number of bytes of data that
can be transferred between the CAS server and SAS during a single-table
read.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
DATAPATH=('path1' <'path2'>...)
Specifies a list of paths in which to store data
partitions (.dpf) for an SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
DATASRC=<'>data-source<'>
Specifies the configured data source to which you want to
connect.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DATETIME2=YES | NO
Specifies the scale for the timestamp literal for
Microsoft SQL Server 2008 and the native Microsoft driver.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DB_LENGTH_SEMANTICS_BYTE=YES | NO
Indicates whether CHAR and VARCHAR2 column lengths
are specified in bytes or characters when creating an Oracle table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DB_OBJECTS=TABLES | VIEWS | SYNONYMS | PUBLIC_SYNONYMS | ALL
Specifies which database objects to return with
PROC DATASETS or in SAS Explorer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCLIENT_ENCODING_FIXED=YES | NO
Specifies whether SAS session encoding is a fixed
width.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCLIENT_MAX_BYTES=max-client-bytes
Specifies the maximum number of bytes per single
character in the SAS session encoding.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBCLIENT_MAX_BYTES=maximum-client-bytes
Specifies the maximum number of bytes per single character in SAS session
encoding when reading character data from a DBMS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCLIENT_MAX_BYTES=maximum-client-bytes
Specifies the maximum number of bytes per single character in SAS session
encoding when reading character data from a DBMS.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBCLIENT_MAX_BYTES=maximum-client-bytes
Specifies the maximum number of bytes per single character in SAS session
encoding when reading character data from a DBMS.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBCOMMIT=n
Causes an automatic COMMIT (permanently writing
data to the DBMS) after processing a specified number of rows.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCOMMIT=
n
Causes an automatic Commit (a permanent writing of data to the DBMS) after a
specified number of rows have been processed.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBCOMMIT= unsigned-integer
Causes an automatic Commit after a specified number of rows have been
processed.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBCONINIT=<'>DBMS-user-command<'>
Specifies a user-defined initialization command
to execute immediately after every connection to the DBMS that is
within the scope of the LIBNAME statement or libref.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCONTERM=<'>DBMS-user-command<'>
Specifies a user-defined termination command to
execute before every disconnect from the DBMS that is within the scope
of the LIBNAME statement or libref.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCREATE_TABLE_EXTERNAL=YES | NO
Specifies whether a Hive table is created and stored
in the Hive warehouse or external to the Hive warehouse.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCREATE_TABLE_LOCATION='path'
Specifies the default location for external tables.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBCREATE_TABLE_OPTS='DBMS-SQL-clauses'
Specifies DBMS-specific syntax to add to the CREATE
TABLE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBDATASRC=<'>database-data-source<'>
Is an environment variable that lets you specify a default data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBGEN_NAME=
DBMS | SAS
Specifies how SAS automatically renames DBMS columns (when they contain
characters that SAS does not allow, such as $) to valid SAS variable
names.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBGEN_NAME=DBMS | SAS
Specifies how columns with invalid characters are automatically renamed to
valid SAS variable names.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
DBGEN_NAME=DBMS | SAS
Specifies the method that SAS uses to rename any DBMS columns that contain
characters that SAS does not allow.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBGEN_NAME=
DBMS | SAS
Specifies how SAS automatically renames columns that contain characters that
SAS does not allow, such as $, to valid SAS column names.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBGEN_NAME= DBMS | SAS
Specifies how SAS renames columns that contain characters that SAS does not allow,
such as $, to valid SAS column names.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBINDEX=YES | NO
Specifies whether SAS uses columns that have specified DBMS indexes when
processing a join.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBINDEX=
YES | NO
Improves performance when processing a join that involves a large DBMS table
and a small SAS data set.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBINDEX= YES | NO
Specifies whether to use database indexes during a join to a SAS data
set.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBLIBINIT=<'>DBMS-user-command<'>
Specifies a user-defined initialization command
to execute once within the scope of the LIBNAME statement or libref
that established the first connection to the DBMS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBLIBINIT=<'> command<'>
Specifies a valid data source command to be executed
once within the scope of the LIBNAME statement or libref that established
the first connection to the data source.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBLIBINIT=<'> command<'>
Specifies a valid data source command to be executed after the first data source
connection is successfully established.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBLIBTERM=<'>DBMS-user-command<'>
Specifies a user-defined termination command to
execute once, before the DBMS that is associated with the first connection
made by the LIBNAME statement or libref disconnects.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBLIBTERM=<
'
>
command<
'
>
Specifies a valid data source command to be executed once, before the data
source that is associated with the last connection made by the LIBNAME statement or
libref
disconnects.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBLIBTERM=<'> command<'>
Specifies a valid data source command to be executed immediately before SAS
terminates the last connection to the data source.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBLINK=database-link
For Oracle, this option specifies a link from your local
database to database objects on another server. For SAP ASE, this option specifies
a link
from the default database to another database on the server to which you are
connected.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBMAX_TEXT=number-of-bytes
Specifies the maximum number of bytes to allocate for character
columns.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
DBMAX_TEXT=integer
Determines the length of any very long DBMS character
data type, such as BLOB or CLOB, that is read into SAS or written
from SAS when using a SAS/ACCESS engine.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBMAX_TEXT_TYPES=LONG | ALL
Specifies whether the DBMAX_TEXT= LIBNAME option is applied to all character types
or only "long" data types.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBMSTEMP=YES | NO
Specifies whether SAS creates temporary tables.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBNULL=YES | NO
Specifies whether NULL is a valid value for the
specified columns when a table is created.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
DBNULLKEYS=YES | NO
Specifies whether Null values are allowed in key columns.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBNULLKEYS= YES | NO
Controls the format of the WHERE clause when you
use the DBKEY= data set option.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBNULLKEYS= YES | NO
Controls the format of the WHERE clause when you
use the DBKEY= data set option.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBNULLWHERE=YES | NO
Specifies whether character columns in a WHERE clause
can contain NULL values.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBPROMPT= YES | NO
Specifies whether SAS displays a window that prompts
the user to enter DBMS connection information before connecting to
the DBMS in interactive mode.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBPROMPT= YES | NO
Specifies whether a window prompts the user to enter
connection information before connecting to the data source in interactive
mode.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBPROMPT= YES | NO
Specifies whether SAS displays a window that prompts for connection
information.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBSASLABEL=
COMPAT | NONE
Specifies the column labels an engine uses.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DBSASLABEL=COMPAT | DBMS | NONE
Specifies the column labels that an engine uses.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
DBSASLABEL=COMPAT | DBMS | NONE
Specifies the column labels an engine uses.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBSASLABEL= COMPAT | NONE
Specifies how the table driver returns column labels.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DBSASLABEL= COMPAT | NONE
Specifies how the table driver returns column labels.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DBSERVER_ENCODING_FIXED=YES | NO
Specifies whether Oracle database encoding is a
fixed width.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBSERVER_MAX_BYTES=max-server-bytes
Specifies the maximum number of bytes per single
character in the database server encoding.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DBSLICEPARM=NONE | THREADED_APPS | ALL
DBSLICEPARM= ( NONE | THREADED_APPS | ALL
<max-threads>
)
DBSLICEPARM= (
NONE | THREADED_APPS | ALL<, max-threads>
)
Controls the scope of DBMS threaded Reads and the
number of threads.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DEFAULT_AUTH_PLUGIN=caching_sha2_password | mysql_native_password
Specifies the authentication plugin to use for a connection to a data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DEFER=
NO | YES
Specifies when the connection to the DBMS occurs.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DEFER=YES | NO
Specifies whether to wait until a table is accessed before connecting to the
data source.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
DEFER=YES | NO
Specifies whether to defer the connection to the data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DEFER= NO | YES
Specifies when the connection to the data source
occurs.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DEFER= NO | YES
Specifies when the connection to the data source occurs.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DELETE_MULT_ROWS=YES | NO
Indicates whether to let SAS delete multiple rows
from a data source, such as a DBMS table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DERIVECHARMULTIPLIER=YES | NO
Expands column (variable) lengths by a default multiplier
value that is based on the session encoding.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
DESTGROUP= destination_group
Indicates the name of the destination group for
batch access to the SAP system when the SAP LIBNAME engine uses direct
RFC calls.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DESTINATION= destination
Indicates the destination in the saprfc.ini file
if you are working with an saprfc.ini file.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DIRECT_EXE= DELETE
Allows you to pass a SAS SQL procedure DELETE statement directly to a data
source to process, which can improve performance.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DIRECT_EXE= DELETE
Allows you to pass a SAS SQL procedure DELETE statement directly to a data source
to process, which can improve performance.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DIRECT_SQL=
YES | NO | NONE | NOGENSQL | NOWHERE
| NOFUNCTIONS | NOMULTOUTJOINS Lets you specify whether generated SQL is passed to the DBMS for
processing.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
DIRECT_SQL=NO
| NOFUNCTIONS
| NOGENSQL | NOMULTOUTJOINS | NONE | NOWHERE | YES
Specifies whether generated SQL is passed to the
DBMS for processing.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DIRECT_SQL=
YES | NO | NONE | NOGENSQL | NOWHERE | NOFUNCTIONS | NOMULTOUTJOINS
Enables you to specify whether generated SQL is passed to the data source for
processing.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
DIRECT_SQL= YES | NO | NONE | NOGENSQL | NOWHERE | NOFUNCTIONS
| NOMULTOUTJOINS Specifies whether generated SQL is passed to the data source for
processing.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
DIRECTORIES_AS_DATA=YES | NO
Specifies whether file system directories are used
as tables.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
DISCONNECT=NO | YES
Controls how user proxy resources are assigned for
a server user.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
DM_UNICODE="UTF-8" | "UTF-16"
Specifies the Unicode encoding for your driver manager.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DRIVER=<'>ODBC-driver<'>
Specifies the ODBC driver to use to connect to your database.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DRIVER_TRACE=tracing-level
Requests tracing information that logs transaction
records to an external file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DRIVER_TRACEFILE='path-and-filename'
Specifies the name of the trace log.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DRIVER_TRACEOPTIONS=value
Specifies options for the trace log file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DRIVERCLASS=<'>driver<'>
Specifies the fully qualified class name of the JDBC driver required for
establishing a connection to your database.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
DSN=<'>data-source<'>
Specifies the configured ODBC data source to which you want to connect.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ENABLE_BULK=NO | YES
Lets the connection process bulk copy when loading
data into an SAP ASE table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ENABLE_CLEARTEXTPLUGIN=YES | NO
Specifies whether to enable the Cleartext plug-in
for authentication.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ENCRYPT=YES | NO
Specifies how communication is encrypted.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ENDOBS=n
Specifies the end observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
ENDOBS=n
Specifies the end row number in a user-defined range
for processing.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
ERRLIMIT=integer
Specifies the number of errors that are allowed while using the TPT or
Fastload utility before SAS stops loading data to Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ESCAPE_BACKSLASH=YES
| NO
Specifies whether backslashes in literals are preserved
during data copy from a SAS data set to a table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
FASTEXPORT=YES | NO
Specifies whether the SAS/ACCESS engine uses the TPT API to read
data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
FASTLOAD YES | NO
Quickly loads large amounts of data into an empty Teradata
table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
FETCH_IDENTITY=YES | NO
Returns the value of the last inserted identity
value.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
FETCH_NUMERIC_TYPE=FLOAT64 | NUMERIC
Specifies how to load NUMERIC data from Google BigQuery.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
FILE_NAME_EXTENSION=extension-type | _NONE_
FILE_NAME_EXTENSION=(extension-type-1 ... extension-type-n <_NONE_>)
Specifies nondefault file extensions for SAS to read and write
files.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
FILELOCKS=NONE | FAIL | CONTINUE
Specifies whether file locking is turned on or off for the files that are
opened under the libref in the LIBNAME statement.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
FILELOCKWAIT=n
Specifies the number of seconds SAS waits for a locked file to become
available to another process.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
FORMATACTIVE=NO | YES
Specifies whether SAS formats are used.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
FORMATLIBRARY=libref
Specifies the libref of an existing SAS library
in which to create the format catalog.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
FORMATNOREPLACE=NO | YES
Specifies whether to replace existing format entries
in the format catalog search path in cases where an existing format
entry has the same name as a format that is being created by the XML
engine when it converts a CDISC ODM CodeList element.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
GO_ENABLE_LOGGING=YES | NO
Specifies whether to enable logging in the Go layer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
GO_LOG_FILE="path-and-file-name"
Specifies the file that contains log information from the Go
layer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
GO_LOG_FORMAT=json | pretty | term | file | plain | message | logfmt
Specifies the format for trace messages in Go layer
logging.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
GO_LOG_LEVEL=ERROR | WARN | INFO | DEBUG | TRACE
Specifies the logging level for Go layer logging.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
GROUP= application_server_group
Indicates the name of the group of SAP application
servers if you are using load balancing.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
GWHOST= gateway_host_name
Indicates the host name of the SAP gateway.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
GWSERV= gateway_service
Indicates the service of the SAP gateway.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
HDFS_DATADIR='path'
Specifies the path to the directory where SAS reads and writes data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
HDFS_TEMPDIR='path'
Specifies the path to the HDFS directory where SAS reads and writes temporary
data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
HIDEFLAGS=YES | NO
Specifies whether the columns Questionable, Annotated,
and Substituted are hidden.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
HIDEOPTVARS=YES | NO
Specifies whether to hide the secondary variables
of a data set.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
HIVE_PRINCIPAL='Hive-principal-name'
Specifies the principal name of the Hive server in an environment that uses
Kerberos.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
HOST=<'>host-name<'>
Specifies the host name or IP address where the database is
running.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
HOST= "Kubernetes-service-name"
specifies the CAS server that is associated with
a CAS session.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
HOST=host-name
Specifies an SPD Server machine by node name or
IP address.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
HTTPPATH="http-path"
Specifies the HTTP or HTTPS endpoint for building the JDBC URL connection string.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
IDXBY=YES | NO
Specifies whether to use an index when processing
a BY statement in the SPD Engine.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
IEEE_REVERSE= Y | N
Indicates whether floating-point numbers are byte-reversed.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
IGNORE_BASELINE=YES | NO
Specifies whether to try the connection regardless
of the minimum required Hadoop version.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
IGNORE_FEDSQL_OBJECTS=YES | NO
Specifies whether to ignore FedSQL objects in a library
query.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
IGNORE_READ_ONLY_COLUMNS=YES | NO
Specifies whether to ignore read-only columns.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
IGNORE_READ_ONLY_COLUMNS=YES | NO
Specifies whether to ignore or include columns where
data types are read-only when generating a SQL statement for inserts
or updates.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
IGNORE_READ_ONLY_COLUMNS= YES | NO
Specifies whether to ignore or include columns that are Read-only and that have
unique values when generating an SQL statement for inserts or updates.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
IGNORE_READ_ONLY_COLUMNS= YES | NO
Specifies whether to ignore or include columns that
are Read-only and that have unique values when generating a SQL statement
for inserts or updates.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
IN='database-name.tablespace-name' | DATABASE database-name'
Lets you specify the database and tablespace in
which you want to create a new table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
INDENT=integer
Specifies the number of columns to indent each nested
element in the exported XML document.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
INDEXPATH=('path1' <'path2'...>)
Specifies a path or list of paths in which to store
the two types of index component files (.hbx and .idx) associated
with an SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
INENCODING= code_page
Indicates the code page.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
INENCODING=ANY | ASCIIANY | EBCDICANY | encoding-value
Overrides and changes the encoding when reading
or writing Base SAS data sets in the SAS library.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
INENCODING=ANY | ASCIIANY | EBDICANY | encoding-value
Overrides and changes the encoding when reading or writing SAS data sets in
the SAS library.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
INSERT_SQL=YES | NO
Determines the method to use to insert rows into
a data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
INSERT_SQL= YES | NO
Specifies the method that is used to insert rows
into a data source.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
INSERT_SQL=
YES | NO
Specifies the method that is used to insert rows into a data
source.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
INSERTBUFF=positive-integer
Specifies the number of rows in a single DBMS insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
INSERTBUFF= positive-integer
Specifies the number of rows in a single insert
operation.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
INSERTBUFF= positive-integer
Specifies the number of rows to insert in one write block.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
INSTANCE=instance-number
Specifies the instance number of the SAP HANA database engine.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
INTERFACE=file-name
Specifies the name and location of the interfaces
file that is searched when you connect to the SAP ASE server.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
IOBLOCKSIZE=n
Specifies the size in bytes of a block of observations
to be used in an I/O operation.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
IP=YES
Invokes SQL implicit pass-through processing for
the SPD Server session.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
IP_CURSOR=YES | NO
Specifies whether implicit PROC SQL pass-through processes multiple result
data sets simultaneously.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
KEYSET_SIZE=number-of-rows
Specifies the number of rows that are keyset driven.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LANGUAGE= language
Indicates the SAP logon parameter language.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
LARGE_RESULTS_DATASET=<'>Google-BigQuery-data-set-ID<'>
Specifies a data set ID for query results.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LARGE_RESULTS_EXPIRATION_TIME=milliseconds
Specifies the amount of time in milliseconds until a temporary table is
deleted.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LARGE_RESULTS_PROJECT=<'>project-ID<'>
Specifies a project ID for large query results.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LIBGEN=NO | YES
Configures the SPD Server connection to generate
additional domain connections.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
LIBRARYDEFINITION=source-definition-URI
Retrieves pre-defined engine LIBNAME information from the Data Sources
microservice and performs a LIBNAME assignment.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
LOCATION="location"
Specifies the localization that was used to store data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LOCKING=NO | YES
Enables record-level locking for the domain.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
LOCKTABLE=EXCLUSIVE
| SHARE
Places exclusive or shared locks on tables.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LOCKTIME=positive-integer
Specifies the number of seconds to wait until rows are available for
locking.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LOCKWAIT=YES
| NO
Specifies whether to wait indefinitely until rows
are available for locking.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LOGDB=database-name
Redirects to an alternate database-specific table that FastExport creates or
MultiLoad uses.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LOGIN_TIMEOUT=numeric-value
Specifies the default login time-out for connecting
to and accessing data sources in a library.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
LOGIN_TIMEOUT=timeout-in-seconds
Specifies the number of seconds that the engine should wait to connect to Cloud
Data Exchange for the SAS Viya platform.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
LOGIN_TIMEOUT=timeout-in-seconds
Specifies the number of seconds the engine should
wait to connect to SAS Federation Server.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
MAPREDUCE_JOB_NAME="name"
Specifies the MapReduce job name.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MAPREDUCE_QUEUE_NAME="name"
Specifies the MapReduce queue name.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MAX_BINARY_LEN=value
Specifies the maximum length in bytes of a binary column.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MAX_CHAR_LEN=value
Specifies the maximum column width for results that
are returned from an external database.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
MAX_CHAR_LEN=value
Specifies the maximum number of characters to allocate for Google BigQuery
string columns.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MAX_CONNECTS=numeric-value
Specifies the maximum number of simultaneous connections
that SAP ASE allows.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MAX_STRING_SIZE=NONE | EXTENDED | STANDARD
Specifies whether to override string limits that are returned via
Oracle.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MAX_TABLE_JOINS = number
Indicates the number of tables that you can use
in a left-outer join or an inner join in ABAP Open SQL.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
MAXTABLEMEM=integer | integerK | integerM | integerG
Specifies the maximum amount of memory, in bytes,
to allocate for an in-memory table.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
METAPATH=('path1' <'path2'...>)
Specifies a list of paths in which to store overflow
metadata (.mdf) component files for an SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
MODE=STANDARD
| PERFORMANCE
MODE=TERADATA
| ANSI
Specifies the connection mode for Teradata or
specifies the performance mode for Google BigQuery.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MONGO_PLATFORM=NATIVE | ATLAS
Specifies the type of database server to use for
the MongoDB connection.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
MSHOST= message_server_host
Indicates the host name of the message server, if
you are using load balancing.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
MULTI_DATASRC_OPT= NONE | IN_CLAUSE
Used instead of the DBKEY= data set option to improve
performance when you process a join between two data sources.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
MULTI_DATASRC_OPT=IN_CLAUSE | NONE
Used in place of DBKEY to improve performance when
processing a join between two data sources.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MULTI_DATASRC_OPT=
NONE | IN_CLAUSE
Used in place of DBKEY to improve performance when processing a join between
two data sources.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
MULTI_DATASRC_OPT= NONE | IN_CLAUSE
Used in place of DBKEY to improve performance when
processing a join between two data sources.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
MULTISTMT=YES | NO
Specifies whether insert statements are sent to Teradata one at a time or in a
group.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
MUTUAL_AUTH=YES | NO
Specifies whether to enforce mutual authentication.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
NAMESPACE=name
Subsets a table list by namespace.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
NCHARMULTIPLIER=n
Specifies a multiplication factor that is used to
increase the number of bytes for a fixed character variable when data
is transcoded to the UTF-8 encoding in order to run in the CAS server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
NETCOMP=NO | YES
Sends compressed data in a server network packet.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
NEWPASSWORD='new-password'
Specifies a new password for an SPD Server user.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
NOPROMPT=<'>connection-options<'>
Specifies connection options for your database.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
NUMC_SAS_TYPE=
N | C | $
Indicates the SAS type for ABAP type NUMC.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
ODSCHARSET=character-set
Specifies the character set to use for the output
file
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
ODSRECSEP=DEFAULT | NONE | YES
Controls the generation of a record separator that
marks the end of a line in the output XML document.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
ODSTRANTAB=table-name
Specifies the translation table to use for the output
file.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
OR_BINARY_DOUBLE
=YES
| NO
Specifies the default data type to use for numeric
table columns.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
OR_ENABLE_INTERRUPT=YES | NO
Allows interruption of any long-running SQL processes
on the DBMS server.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
OR_UPD_NOWHERE=YES | NO
Specifies whether SAS uses an extra WHERE clause
when updating rows with no locking.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
OUTREP=format
Specifies the data representation for the SAS library, which is the form in
which data is stored in a particular operating environment.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
PACKETSIZE=numeric-value
Allows specification of the packet size for SAP
ASE to use.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PARMDEFAULT=YES | NO
Specifies whether the SAP HANA engine uses the defaults
for variables and parameters that are specified in the metadata in
SAP HANA.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PARMSTRING=<"variable-name1=variable-value1,variable-name2=variable-value2,...">
< "'PLACEHOLDER' = ('variable-name1', 'variable-value1'),< 'PLACEHOLDER'=
('variable-name2', 'variable-value2'),>..."> Specifies a quoted string of variable name and value
pairs separated by a comma, or a placeholder string.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
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
| |
|
PASSWORD= password
Indicates the SAP logon parameter password.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
PASSWORD=<'>password<'>
Specifies the password or access token to access a data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PASSWORD='password'
Specifies the password of the server user.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
PATH=<'>Oracle-database-specification<'>
Specifies the Oracle driver, node, and database.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PLATFORM=SPARK | DATABRICKS
Specifies the target platform.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
POINTOBS=YES | NO
Specifies whether SAS creates compressed data sets whose observations can be
randomly accessed or sequentially accessed.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
PORT=port-number
Specifies the port number that is used to connect to the data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PORT=integer
Specifies the network port number on which the controller
listens for client connections.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
POST_DML_STMT_OPTS=value
Specifies text to append to an INSERT, UPDATE, or
DELETE statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
POST_STMT_OPTS='DBMS-SQL-options'
Allows additional database-specific options to be
placed after the CREATE TABLE statement in generated SQL code.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PREFETCH=0 | OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Specifies the number of cached rowsets to be used
by client and server prefetching.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
PREFETCH=0 | OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Enables prefetch with a specified number of cached rowsets.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
PREFETCHBYTES=<unsigned-integer>
Modifies the size of the cached rowsets used in
prefetching.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
PREFETCHBYTES=number-of-bytes
Modifies the size of the cached rowsets used in prefetching, specified as
bytes.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
PREFETCHROWS=<unsigned-integer>
Modifies the number of rows in the cached rowsets used in
prefetching.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
PREFETCHROWS=<number-of-rows>
Modifies the number of rows in the cached rowsets used in
prefetching.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
PREFIXATTRIBUTES=YES | NO
Specifies whether the element name is concatenated
to the attribute name when generating each XMLMap COLUMN element,
which defines the SAS variable name.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
PRESERVE_COL_NAMES=YES | NO
Specifies whether to preserve spaces, special characters, and case sensitivity in
DBMS column names when you create DBMS tables.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRESERVE_COL_NAMES= NO | YES
Preserves spaces, special characters, use of reserved
words, and case sensitivity in column names when you create tables.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
PRESERVE_COL_NAMES= NO | YES
Specifies whether to preserve spaces, special characters, and case sensitivity in
DBMS column names when you create DBMS tables.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
PRESERVE_COMMENTS=YES | NO
Specifies whether comments should be kept and passed
down to your data source for processing.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRESERVE_GUID=YES | NO
Preserves the Microsoft SQL Server GUID (Unique
Identifier).
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRESERVE_NAMES=YES | NO
Specifies whether to preserve spaces, special characters, and case sensitivity in
DBMS column names and table names.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRESERVE_TAB_NAMES=YES | NO
Specifies whether to preserves spaces, special characters, and case sensitivity in
DBMS table names.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PRESERVE_TAB_NAMES= NO | YES
Preserves spaces, special characters, reserved words,
and case sensitivity in DBMS table names.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
PRESERVE_TAB_NAMES= NO | YES
Specifies whether to preserves spaces, special characters, and case sensitivity in
DBMS table names.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
PRESERVE_USER=YES | NO
Preserves the case of the value in the USER= connection
option.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PROC_DATASETS_TAGFILTER="filter-string"
Specifies a character string, which can include
the wildcard characters ‘*’ and ‘?’, that
is used to limit the output from the DATASETS procedure.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
PROGRAM_NAME='user-defined-string'
Specifies the string to use as the application identifier
for DB2 monitoring.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PROJECT='project-ID'
Specifies the project ID for a Google Cloud Platform
project.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PROJECT_LIST="project-ID-1<,project-ID-2...>"
Specifies a list of projects to access on Google Cloud
Platform.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PROMPT=NO | YES
Specifies to prompt the SPD Server user for a password.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
PROPERTIES='JDBC-connection-property-1<;JDBC-connection-property-2...>'
Specifies additional driver-specific JDBC connection properties that will be added
to the generated JDBC URL.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PROXY="URL"
Specifies the URL of a proxy server that is used to connect to Google
BigQuery.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
PROXY="(SERVER=proxy-host-name; PORT=port-number; UID=user-name; PWD=password)”
Specifies options to connect to an intermediate
proxy server.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
PROXY="(SERVER=proxy-host-name; PORT=port-number; UID=user-name; PWD=password)”
Specifies options to connect to an intermediate
proxy server.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
PROXY_HOST="host-name";
Specifies the host name or IP address of a proxy
server.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
PROXY_PASS="password";
Specifies the password that is associated with PROXY_USER=.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
PROXY_PORT=<"port-number";>
Specifies the port number of the proxy server.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
PROXY_USER=<"user-id";>
Specifies the user ID that is used to access the
proxy server.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
QUALIFIER=<'><qualifier-name><'>
Enables identification of tables and views with the specified
qualifier.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
QUALIFIER= qualifier-name
Identifies database objects, such as tables, by
using a qualifier.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
QUALIFIER= qualifier-name
Identifies database objects, such as tables, by
using a qualifier.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
QUERY_BAND="pair-name=pair_value;"
Specifies whether to set a query band for the current
session.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
QUERY_TAG="string"
Specifies an optional string that you can use to tag queries to your data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
QUERY_TIMEOUT=number-of-seconds
Specifies the number of seconds of inactivity to
wait before canceling a query.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
QUOTE_CHAR="character"
Specifies which quotation mark character to use
when delimiting identifiers.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
QUOTE_CHAR="character "
Specifies which quotation mark character to use
when delimiting identifiers.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
QUOTED_IDENTIFIER=YES | NO
Allows specification of table and column names with
embedded spaces and special characters.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
R3NAME= system_name
Indicates the name of the R/3 system.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
READ_ISOLATION_LEVEL=DBMS-specific
values
Specifies the degree of isolation of the current
application process from other concurrently running application processes.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_ISOLATION_LEVEL= DBMS-specific
value
Defines the degree of isolation of the current application
process from other concurrently running application processes.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
READ_ISOLATION_LEVEL= DBMS-specific
value
Specifies the degree of isolation of the current application process from other
concurrently running application processes.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
READ_LOCK_TYPE=ROW
| PAGE
| TABLE
| NOLOCK
| VIEW
Specifies how data in a DBMS table is locked during
a READ transaction.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_LOCK_TYPE= ROW | NOLOCK
Specifies how data in a DBMS table is locked during
a Read transaction.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
READ_LOCK_TYPE= ROW | NOLOCK
Specifies how data in a DBMS table is locked during
a Read transaction.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
READ_METHOD=JDBC | HDFS
Specifies how to read data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_MODE=STANDARD | STORAGE
Specifies the method to use to move data into SAS.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_MODE_WAIT=YES | NO
During SAS/ACCESS Read operations, specifies whether Teradata should wait to
acquire a lock or fail the request when a different user has already locked the DBMS
resource.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READ_ONLY=YES | NO
Specifies whether to connect to the Netezza database in Read-Only
mode.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READBUFF=integer
Specifies the number of rows of DBMS data to read
into the buffer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
READBUFF= integer
Specifies the number of rows of data to read into
the buffer.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
READBUFF=
integer
Specifies the number of rows of data to read in one read
block.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
READTRANSFERSIZE=integer | integerK | integerM | integerG
Specifies the maximum number of bytes that the CAS
engine reads when transferring data from the CAS server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
REFRESH_TOKEN=token-value
Specifies the refresh token value for the OAuth client that is used to connect
to Google BigQuery using the OAuth authentication method.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
REMOTE_DRIVER=REMFS | FSNET | IOM | FEDSVR | REMTS
Specifies the remote driver to use for the SAS Federation Server
connection.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
REMOTE_DRIVER_OPTIONS=”connection-option1<
; connection-option2
>”
Specifies remote driver options for connecting to Cloud Data Exchange for the
SAS Viya platform.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
REMOTE_DRIVER_OPTIONS=”connection-option1<; connection-option2>”
Specifies remote driver options for connecting to
SAS Federation Server.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
REPEMPTY=YES | NO
Controls replacement of a data set when the new one is empty.
Product: Base SAS
Document: SAS V9 LIBNAME Engine: Reference
| |
|
REPEMPTY=YES | NO
Controls replacement of a data set when the new
data set is empty.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: 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 R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
REREAD_EXPOSURE=YES | NO
Specifies whether the SAS/ACCESS engine functions
like a random access engine for the scope of the LIBNAME statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
REREAD_EXPOSURE=
NO | YES
Specifies whether the interface behaves like a random access engine for the
scope of the LIBNAME statement.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
REREAD_EXPOSURE=
NO | YES
Specifies whether the interface behaves like a random access engine for the scope
of the LIBNAME statement.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
RESULTS=MEMORY | SERVER
Determines how result sets are retrieved from the server.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
RFC_STRING= additional_rfc_options
Indicates additional logon or connection parameters
for the RfcOpenEx() call.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
ROLE=<'>Snowflake-role<'>
Specifies the default Snowflake role to use for sessions that the driver
initiated.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ROWSET_SIZE=integer
Specifies the number of rows of DBMS data to read
into the buffer.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SAS_DBMS_AUTOMETADATA=YES | NO
Specifies whether to transfer data types and character-set metadata from input
to output for DATA step processing.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SCAN_LIMIT=value
Specifies the number of documents to scan to define
or update a schema.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCANSTRINGCOLUMNS=YES | NO
Specifies whether to determine the maximum length of VARCHAR or long type columns
in a database table or a query.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SCHEMA=schema-name
Subsets a table list by user name.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
SCHEMA=<'>schema-name<'>
Specifies the schema to use when accessing tables
and views in a database.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SCHEMA= schema-name
Enables you to read database objects, such as tables,
in the specified DBMS schema.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
SCHEMA= schema-name
Specifies the schema name for the data source connection.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
SCHEMA="domain-name"
Specifies the server domain name.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
SCHEMA_AUTH=AUTO | KERBEROS | LDAP | PASSWORD
Specifies the authorization method that is used
to access a MongoDB schema.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_COLLECTION='collection-name'
Specifies the MongoDB collection where the schema
file is stored.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_DB='database-name'
Specifies the MongoDB database where a schema is
stored.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_MONGO_PLATFORM=ATLAS | NATIVE
Specifies the type of database server to use for
the MongoDB schema mapping.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_PASSWORD='string'
Specifies the password that corresponds to a schema.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_PORT=value
Specifies the port that corresponds to a schema.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_SERVER=<'>server-name<'>
Specifies the server name or IP address of the server
that stores the schema mapping.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_SSL_CA="path-and-file-name"
Specifies the full path name to the certificate
authority file for the MongoDB schema location.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_SSL_CERT="path-name"
Specifies the full path name to the certificate
file for the MongoDB schema location.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_TABLES=YES | NO
Specifies whether to create tables that give details
about a schema.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCHEMA_USER='user-ID'
Specifies the user ID that corresponds to a schema.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SCRATCH_DB=schema-name
Specifies a Hive schema so that SAS can store temporary
output.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SERVER=<'>server-name<'>
Specifies the server, host name, or IP address that is used to connect to the
data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SERVER=host-name.service-name
Specifies an SPD Server host machine by its host
name and service name.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
SERVERPREFETCH=0 | OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Modifies the number of cached rowsets to be used
in server-side prefetching.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
SERVERPREFETCH=0 | OFF | FALSE | NO | 1 | ON | TRUE | YES | unsigned-integer
Enable server side prefetch.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
SERVICE=service-name | port-number
Specifies the service name or port number for the
SPD Server’s name server.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
SESSIONS=number-of-sessions
Specifies how many Teradata sessions to be logged on when using FastLoad,
FastExport, or Multiload.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SESSREF=session-name
Specifies the name of the CAS session to which you
want to connect.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
SHARE=NO | YES
Enables enhanced sharing of user proxies.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
SHOW_METADATA=YES | NO
Specifies whether to display metadata tables and
columns.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SHOW_RECYCLED=YES | NO
Specifies whether to display deleted table rows
in the recycle bin.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SHOW_SYNONYMS=YES | NO
Specifies whether synonyms only or tables, views, or materialized views are
available through your LIBNAME connection.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SHOWFLAGS=YES | NO
Specifies whether the columns Questionable, Annotated,
and Substituted display.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SKIP_IDENTITY_COL=YES | NO
Specifies whether to skip IDENTITY columns when writing to an external
table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SLEEP=number-of-minutes
Specifies the number of minutes that FastExport, FastLoad, or MultiLoad waits
before trying again to log on to Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SPOOL= YES | NO
Specifies whether SAS creates a utility spool file
during read transactions that read data more than once.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
SPOOL=YES | NO
Specifies whether SAS creates a utility spool file
during Read transactions that read data more than once.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SPOOL=YES | NO | DBMS
Specifies whether SAS creates a utility spool file
during Read transactions that read data more than once.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SPOOL= YES | NO
Specifies whether SAS creates a utility spool file
during Read transactions that read data more than once.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
SPOOL= YES | NO
Specifies whether SAS creates a utility spool file during Read transactions that
read data more than once.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
SQL_FUNCTIONS=ALL | EXTERNAL_REPLACE=<libref.member>
| EXTERNAL_APPEND=<libref.member> Customizes the in-memory SQL dictionary function
list for this particular LIBNAME statement.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SQL_FUNCTIONS= ALL
Specifies that the functions that match those supported
by SAS should be passed to the data source.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
SQL_FUNCTIONS= ALL
Specifies that the functions that match those supported by SAS should be passed to
the data source.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
SQL_FUNCTIONS_COPY=libref.member | SASLOG
Writes the function associated with this particular
LIBNAME statement to a table or the SAS log.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
SQL_FUNCTIONS_COPY=libref.member | SASLOG
Specifies whether to write the functions that are associated with a LIBNAME
statement to a SAS data set or the SAS log.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SQL_OJ_ANSI=YES | NO
Specifies whether to pass ANSI outer-join syntax
through to the database.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SQLGENERATION=NONE | DBMS
Specifies whether SAS procedures generate SQL for in-database processing of source
data.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSL_CA="path-and-file-name"
Specifies the full path name to the certificate
authority file.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SSL_CA="path-and-file-name"
Specifies the full path to the certificate authority (CA)
file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSL_CERT="path-name"
Specifies the full path name to the certificate
file.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
SSL_CERT="path-name"
Specifies the path to the client public key certificate file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSL_CIPHER="cipher-list"
Specifies a list of permissible ciphers to use for
encryption.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSL_KEY="path"
Specifies the path to the client private key file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSL_TRUST_STORE="path"
Specifies the path to the SSL truststore.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSLCREATESELFSIGNEDCERTIFICATE=YES | NO
Specifies whether to create a self-signed certificate if the keystore cannot be
found.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSLCRYPTOPROVIDER=SAPCRYPTO | OPENSSL
Specifies the cryptographic library provider to use for SSL
connectivity.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSLHOSTNAMEINCERTIFICATE=<'>string<'>
Specifies the host-name certificate of the keystore.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSLKEYSTORE=<'>file<'>
Specifies the path to the keystore file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSLMODE='value'
Specifies support for a TLS encrypted connection to your data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSLTRUSTSTORE=<'>file<'>
Specifies the path to the truststore file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SSLVALIDATECERTIFICATE=YES | NO
Specifies whether to validate the certificate of the communication
partner.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
STARTOBS=n
Specifies the starting observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
STARTOBS=n
Specifies the start row number in a user-defined
range for processing.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
STORAGE_ACCOUNT_NAME=name
Specifies the account name for connecting to Microsoft Azure.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_APPLICATION_ID="string"
Specifies the application ID for connecting to Microsoft Azure.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AUTH_DOMAIN=authentication-domain
Allows connection to a server by specifying the name of an authentication
domain object.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AWS_CONFIG_FILE="path-and-AWS-configuration-file-name"
Specifies the location of the Amazon Web Services (AWS) configuration file.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AWS_KEY="key-string"
Specifies the primary service account key for AWS authentication.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AWS_KEY_FILE="key-file-location"
Specifies a file that contains AWS authentication options.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AWS_REGION="region"
Specifies the AWS region for Amazon S3 data.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AWS_ROLEARN="IAM-role-ARN"
Specifies an Amazon Resource Name (ARN) that identifies an IAM role.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AWS_SECRET_KEY="key-string"
Specifies the secret key for AWS authentication.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_AWS_SESSION_TOKEN="token-string"
Specifies the temporary security token for AWS authentication.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_BUCKET_NAME="bucket-name"
Specifies the name of the storage bucket.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_CLIENT_SECRET="secret-string"
Specifies the secret key for Azure authentication.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_DNS_SUFFIX="name"
Specifies the network host name for connecting to Microsoft
Azure.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_FILE_SYSTEM=name
Specifies the name of the file system for connecting to Microsoft
Azure.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_GCS_KEY_FILE="key-file-location"
Specifies a file that contains your service account key for Google Cloud
Storage authentication.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_GCS_KEY_STRING="key-string"
Specifies your service account key for Google Cloud Storage authentication as a
string.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_PLATFORM=ADLS | AWS | GCS
Specifies the type of cloud storage system.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_SCOPE="scope-URI"
Specifies the Microsoft Azure resource and permissions that are required for
federated authentication between Microsoft Entra ID and Amazon S3.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_SHARED_KEY="string"
Specifies the account key for connecting to Microsoft Azure.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STORAGE_TIMEOUT=n
Specifies the maximum completion time for connecting
to a cloud storage system.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
STRINGDATES=YES | NO
Specifies whether to read date and time values from
the database as character strings or as numeric date values.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
STRINGDATES=YES | NO
Specifies whether to read date and time values from the database as character
strings.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
STRINGDATES= YES | NO
Specifies whether to read date and time values from
the data source as character strings or as numeric date values.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
STRINGDATES= YES | NO
Specifies whether to read date and time values from
the data source as character strings or as numeric date values.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
SUB_CHAR=value
Specifies a substitution character to use in place
of any invalid characters that cannot be represented in the SAS session
encoding.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SYBBUFSZ=number-of-rows
Specifies the number of rows of DBMS data to write to the
buffer.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SYNONYMS=YES | NO
Specifies whether PROC DATASETS shows synonyms,
tables, views, or materialized views for the current user and schema
if you specified the SCHEMA= option.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
SYSNR= system_number
Indicates the SAP system number—the 2-byte
code that identifies the system on the host.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
TABLE_TYPE=ROW | COLUMN
TABLE_TYPE=LOCAL | GLOBAL
TABLE_TYPE=(COLUMN
LOCAL)
Specifies the type of temporary tables and table
storage when the engine creates tables in SAP HANA.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TAG=tag-name
Specifies a multi-level prefix for a CAS table that
is used to identify the table to both the CAS server and SAS.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
TAGSET=tagset-name
Specifies the name of a tagset to override the default
tagset that is used by the specified markup type.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
TEMP=YES | NO
Specifies to store the library in a temporary subdirectory
of the primary path.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
| |
|
TEMP=NO | YES
Creates a temporary server domain for this LIBNAME
assignment.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
TEMP_CTAS=YES | NO
Specifies whether to create an intermediate (temporary)
table in Hive.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TEMPORAL_QUALIFIER=CURRENT VALIDTIME
| VALIDTIME AS OF PERIOD 'period' | SEQUENCED VALIDTIME PERIOD 'period' | NONSEQUENCED VALIDTIME PERIOD 'period' TEMPORAL_QUALIFIER=CURRENT TRANSACTIONTIME
| TRANSACTIONTIME AS OF 'period' | NONSEQUENCED TRANSACTIONTIME Specifies time-dimension criteria for retrieving data from
Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TENACITY=number-of-hours
Specifies how many hours that FastExport, FastLoad, or MultiLoad continues to
try to log on again to Teradata if the maximum number of Teradata utilities are already
running.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TEZ_QUEUE_NAME="name"
Specifies an Apache Tez queue name in which to execute client
requests.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TIMEOUTSECONDS=n
Specifies the client inactivity time-out interval
in seconds. If SAS stops transferring data to the server, the server
starts the inactivity timer for the specified duration and cancels
the request if SAS does not resume data transfer.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
TIMEZONE=LOCAL | GMT
Specifies whether SAS writes timestamps to result data using local time or GMT.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TPT=YES | NO
Specifies whether SAS uses the Teradata Parallel Transporter (TPT) API to load
data when SAS requests a Fastload, MultiLoad, or Multi-Statement insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_DATA_ENCRYPTION=YES | NO
Specifies whether to encrypt SQL requests, responses, and data when using the
Teradata Parallel Transport (TPT) API.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_MAX_SESSIONS=integer
Specifies the maximum number of sessions for Teradata to use when using the
TPT API with FastLoad, MultiLoad, or Multi-Statement insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_MIN_SESSIONS=integer
Specifies the minimum number of sessions for Teradata to use when using the
TPT API with FastLoad, MultiLoad, or Multi-Statement insert.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TPT_UNICODE_PASSTHRU=YES | NO
Specifies whether to allow pass-through characters (PTC) to be loaded into SAS
or written to Teradata.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TR_ENABLE_INTERRUPT=YES | NO
Allows interruption of any long-running SQL processes that are involved in
creating the result set or spool file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TRACE= Y | N
Indicates whether SAS should trace the RFC requests.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
TRACE=YES | NO
Specifies whether to turn on tracing information
for use in debugging.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TRACE=YES | NO
Specifies whether to turn on tracing information
for use in debugging.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TRACEFILE=file-name | 'path-and-file-name'
Specifies the file name to which the DBMS driver
manager writes trace information.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TRACEFILE=file-name | <'>path-and-file-name<'>
Specifies the file name to which the DBMS driver
manager writes trace information.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TRACEFLAGS=ALL | COLBINDINGS | GETDATA | PUTDATA | TIMESTAMP
Enables various tracing operations.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
TRACEFLAGS=ALL | COLBINDINGS | GETDATA | PUTDATA | TIMESTAMP
Specifies whether to record column, time, and other parameter data in the
trace file.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TRANSCODE_FAIL=ERROR | WARNING | SILENT
Lets you specify how to handle processing and notification
of transcoding errors.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
TRANSCODE_FAIL=ERROR | WARN | SILENT
Specifies how the engine handles transcoding errors.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
TRANSERRORCOMPATMODE=Y | N
Indicates whether transcoding errors are reported.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
TRUNCWARN=NO | YES
Suppresses hard failure on NLS transcoding overflow
and character mapping errors.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
TRUST_STORE_PASSWORD="password"
Specifies the password for the truststore.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UNIXDOMAIN=NO | YES
Specifies to use UNIX domain sockets for data transfers
between the client and SPD Server.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
UPDATE_ISOLATION_LEVEL=DBMS-specific-value
Specifies the degree of isolation of the current
application process from other concurrently running application processes.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATE_ISOLATION_LEVEL= data
source-specific-value
Specifies the degree of isolation of the current
application process from other concurrently running application processes.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
UPDATE_ISOLATION_LEVEL= data
source-specific-value
Specifies the transaction isolation level for updating tables and
views.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data in a DBMS table is locked during
an update transaction.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATE_LOCK_TYPE= ROW | TABLE | NOLOCK
Specifies how data is locked during an update transaction.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
UPDATE_LOCK_TYPE= ROW | TABLE | NOLOCK
Specifies how data is locked during update operations.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
UPDATE_MODE_WAIT=YES | NO
Specifies during SAS/ACCESS Update operations whether Teradata should wait to
acquire a lock or fail the request when a different user has locked the DBMS
resource.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATE_MULT_ROWS=YES | NO
Indicates whether SAS updates multiple rows from
a data source, such as a DBMS table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATE_SQL=YES | NO
Specifies whether SAS uses current-of-cursor SQL to update and delete rows in a
data source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UPDATEBUFF=positive-integer
Specifies the number of rows that are processed
in a single DBMS Update or Delete operation.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
URI=<'>JDBC-URL<'>
Specifies the JDBC connection string to use for your database
connection.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
URL="jdbc:driver-name://driver-connection-options"
Specifies the JDBC connection string to use for your database
connection.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USE_DATADIRECT=YES | NO
Specifies the driver to use.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USE_INFORMATION_SCHEMA=YES | NO
Specifies whether to use INFORMATION_SCHEMA in Google BigQuery to retrieve a
list of schemas and tables or views.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USE_NATIVE_NAMES=YES | NO
Specifies whether to restore native naming conventions
for custom tables and columns.
Product: SAS/ACCESS Interface to the PI System
Document: SAS/ACCESS for Nonrelational Databases: Reference
| |
|
USE_ODBC_CL=YES | NO
Indicates whether the Driver Manager uses the ODBC
Cursor Library.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USE_PIPELINE=NO | YES
Enables pipeline read functionality for Amazon Redshift.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USE_SP_TABLES=YES | NO
Specifies whether to use the sp_tables stored procedure to check for table
existence.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USE_SSL=YES | NO
Specifies whether to use TLS encryption for connections.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USER= user
Indicates the SAP logon parameter user.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
USER=<'>user-identifier<'>
Specifies the user name or user ID for connecting to a data
source.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
USER='user-name'
Specifies an SPD Server user ID.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
USERS=(name-1=password-1… name-n=password-n)
Defines users and their passwords that can be specified in Access Control
Lists (ACLs) for Parquet files.
Product: Base SAS
Document: SAS Viya LIBNAME Engines for ORC and Parquet: Reference
| |
|
UTILCONN_TRANSIENT=NO | YES
Specifies whether a utility connection is automatically dropped as soon as it is
no longer in use.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
UTILCONN_TRANSIENT= NO | YES
Enables utility connections to be maintained or
dropped, as needed.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
UTILCONN_TRANSIENT= NO | YES
Specifies whether a utility connection gets automatically dropped as soon as it is
no longer in use.
Product: Base SAS
Document: SAS LIBNAME Engine for SAS Federation Server: User’s Guide
| |
|
UUID=“session-uuid”
Connects the CAS engine to the CAS session that
is identified in the UUID.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
UUIDMAC=“macro-variable-name”
Specifies a macro variable that stores a UUID for
any session created by the engine.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
VIYA_SERVICES_URL | VIYA_URL=<https://viya-ingress-url[:port]>
Specifies the URL for the SAS Viya platform deployment for
Ingress.
Product: SAS Data Agent
Document: LIBNAME Engine for Cloud Data Exchange for the SAS Viya Platform: User’s Guide
| |
|
WAREHOUSE=<'>Snowflake-warehouse<'>
Specifies the default Snowflake warehouse to use for sessions that the driver
initiated.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
WARN_BIGINT=YES | NO
specifies whether to issue a warning in the SAS log if the INT8 data type is
in a DBMS table.
Product: SAS/ACCESS Interface R/3
Document: SAS/ACCESS Interface to R/3: User’s Guide
| |
|
WARN_BIGINT=YES | NO
issues a warning in the SAS log if the BIGINT data
type is in a DBMS table.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
WRITETRANSFERSIZE=integer | integerK | integerM | integerG
Specifies the maximum number of bytes that the CAS
engine writes when transferring data to the CAS server.
Product: SAS Cloud Analytic Services
Document: SAS Cloud Analytic Services: User’s Guide
| |
|
XMLCONCATENATE=NO | YES
Specifies whether the file to be imported contains
multiple, concatenated XML documents.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLDATAFORM=ELEMENT | ATTRIBUTE
Specifies whether the tag for the element to contain
SAS variable information (name and data) is in open-element or enclosed-attribute
format.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLDOUBLE=DISPLAY | INTERNAL
Controls the results of importing or exporting numeric
values.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLENCODING='encoding-value'
Overrides the SAS data set's encoding for the
output file.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLFILEREF=fileref
Specifies an XML document to be exported or imported.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLMAP=fileref | 'XMLMap-location'
Specifies an XML document that contains specific
XMLMap syntax.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLMETA=DATA | SCHEMADATA | SCHEMA
Specifies whether to include metadata-related information
in the exported markup, or specifies whether to import metadata-related
information that is included in the input XML document.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLPROCESS=CONFORM | PERMIT
Determines how the engine processes character data
that does not conform to W3C specifications.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLSCHEMA=fileref | 'external-file'
Specifies an external file to contain metadata-related
information.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
XMLTYPE=GENERIC | CDISCODM | MSACCESS | ORACLE | XMLMAP
Specifies the XML markup type.
Product: Base SAS
Document: SAS XMLV2 and XML LIBNAME Engines: User’s Guide
| |
|
ZOOKEEPER_NAMESPACE=namespace
Specifies the ZooKeeper namespace.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ZOOKEEPER_PORT=port-number
Specifies the port number that ZooKeeper listens to for client
requests.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
| |
|
ZOOKEEPER_QUORUM='server-node1<,server-node2...>'
Specifies the server nodes that are available to run client
requests.
Product: SAS/ACCESS for Relational Databases
Document: SAS/ACCESS for Relational Databases: Reference
|
Last updated: July 17, 2025