The LIBNAME Statement for Relational Databases |
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
|
-
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.
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.
DBLINK= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.