PROPERTIES= LIBNAME Statement Option

Specifies additional driver-specific JDBC connection properties that will be added to the generated JDBC URL.

Valid in: SAS/ACCESS LIBNAME and CONNECT statements
Category: JDBC connection options
Default: none
Interaction: This option is ignored when you also specify the URI= connection option.
Data source: Hadoop, Spark
Note: Support for Spark was added in SAS 9.4M7.

Table of Contents

Syntax

Syntax Description

JDBC-connection-property

specifies one or more JDBC connection options to override the default JDBC connection options.

Details

When the URI= option is not provided, SAS constructs a JDBC URL from arguments that are specified in the LIBNAME statement. For more information, see Arguments for Hadoop or Arguments for Spark. By specifying PROPERTIES=, you can include JDBC connection properties in the generated URL.

Note: The connection properties specified in the PROPERTIES= option are specific to the JDBC driver being used for the database connection. If you switch to a different JDBC driver, you will need to update this option accordingly.

For information about the properties that are supported by a JDBC driver, see the driver documentation.

Last updated: February 3, 2026