The LIBNAME Statement for Relational Databases

SHOW_SYNONYMS= LIBNAME Option

Specifies whether PROC DATASETS shows synonyms, tables, views, or materialized views for the current user and schema if you specified the SCHEMA= option.

Default value:	YES
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Oracle

Syntax
Syntax Description
Details
See Also

Syntax

SHOW_SYNONYMS=<YES | NO>

Syntax Description

YES: specifies that PROC DATASETS shows only synonyms that represent tables, views, or materialized views for the current user.
NO: specifies that PROC DATASETS shows only tables, views, or materialized views for the current user.

Details

Instead of submitting PROC DATASETS, you can click the libref for the SAS Explorer window to get this same information. By default, no PUBLIC synonyms display unless you specify SCHEMA=PUBLIC.

When you specify only the SCHEMA option, the current schema always displays with the appropriate privileges.

Tables, views, materialized views, or synonyms on the remote database always display when you specify the DBLINK= LIBNAME option. If a synonym represents an object on a remote database that you might not be able to read, such as a synonym representing a sequence, you might receive an Oracle error.

Synonyms, tables, views, and materialized views in a different schema also display.