124 SHOW_SYNONYMS= LIBNAME Option Chapter 9
PRINT and still use the libref (CARGO) in the SAS/ACCESS LIBNAME statement, you
specify the schema in the SCHEMA= option. Then you put the libref.table in the
procedure’s DATA statement.
libname cargo oracle schema=airports user=testuser password=testpass
path="myorapath";
proc print data=cargo.schedule;
run;
In the Teradata interface example that follows, the user TESTUSER prints the EMP
table, which is located in the OTHERUSER database.
libname mydblib teradata user=testuser pw=testpass schema=otheruser;
proc print data=mydblib.emp;
run;
See Also
To apply this option to an individual data set, see the data set option “SCHEMA=
Data Set Option” on page 211.
SHOW_SYNONYMS= LIBNAME Option
Specifies whether PROC DATASETS shows only tables and views for the current user (or schema if
the SCHEMA= option is specified)
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: Oracle
Default value: NO
Syntax
SHOW_SYNONYMS= <YES | NO>
Syntax Description
YES
specifies that PROC DATASETS shows only the synonyms that represent the tables
and views for the current user (or schema if the SCHEMA= option is specified).
NO
specifies that PROC DATASETS shows only tables and views for the current user (or
schema if the SCHEMA= option is specified).
Details
Instead of submitting PROC DATASETS, you can click the libref for the SAS Explorer
window to get this same information.
