Specifies whether PROC DATASETS shows synonyms, tables, views, or materialized views for the current user and schema if you specified the SCHEMA= option.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Alias: | SHOW_SYNONYMS= |
| Default: | YES |
| Data source: | Netezza |
| Note: | Support for this LIBNAME option was added for SAS 9.4. |
| See: | SCHEMA= LIBNAME option, SCHEMA= data set option |
Table of Contents
specifies that PROC DATASETS shows only synonyms that represent tables, views, or materialized views for the current user.
specifies that PROC DATASETS shows only tables, views, or materialized views for the current user.
Rather than submit PROC DATASETS, you can select the libref in SAS Explorer to obtain this same information. By default, no PUBLIC synonyms are displayed unless you specify SCHEMA=PUBLIC.
When you specify only the SCHEMA= option, the current schema is always displayed with the appropriate privileges.
Synonyms, tables, views, and materialized views in a different schema are also displayed.