CONOPTS= LIBNAME Statement Option

Specifies database-specific connection options to use when connecting.

Valid in: SAS/ACCESS LIBNAME statement
CONNECT statement
Category: Data Set Control
Default: none
Data source: Amazon Redshift, Aster, Greenplum, Impala, Informix, Netezza, PostgreSQL, SAP HANA, SAP IQ, Snowflake, Vertica, Yellowbrick
Notes: Support for Yellowbrick was added in SAS 9.4M7.
Support for Informix was added in SAS 9.4M9.
Tip: You can also specify any of these additional connection options: DATABASE=, ROLE=, SCHEMA=, and WAREHOUSE=. [Snowflake]
Example: This example specifies an SSL mode of required for PostgreSQL. 
libname pg postgres user=myusr1 pwd=mypwd1 server='mysrv.com' 
     port=5432 db=userpg conopts='sslmode=required';

Syntax

CONOPTS='connection_options';
Last updated: February 3, 2026