Specifies the qualifier to use when you are reading database objects, such as DBMS tables and views.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | LIBNAME option value |
| Data source: | Amazon Redshift, Google BigQuery, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, PostgreSQL, Vertica |
| Notes: | Support for Amazon Redshift was added in the April 2016 release of SAS/ACCESS. |
| Support for Google BigQuery was added in the August 2019 release of SAS/ACCESS. | |
| See: | QUALIFIER= LIBNAME option |
If this option is omitted, the default qualifier name, if any, is used for the data source. QUALIFIER= can be used for any data source, such as a DBMS object, that allows three-part identifier names: qualifier.schema.object.