When using the SAS/ACCESS LIBNAME engine, SAS® will display only the tables belonging to the default schema. In order to display more than one schema's tables you can create a concatenated library that points to each of the schemas. For example:
libname ora1 oracle user=scott password=tiger path=yyy schema=scott;
libname ora2 oracle user=sasts password=sasts1 path=xxx schema=sasts;
libname all (ora1 ora2);
Libref 'all' will show all the tables in both schemas. Just keep in mind the search order. If there is a table called EMP in both schemas, SAS will find EMP from the first schema listed.