Search notes:

SAS - proc sql: specify Oracle schema in select statement

libname tq84_ora
  oracle
  user     = …
  password = …
  path     = …
;

proc sql;

  select * from some_table (schema = schema_of_table);
 
quit;

See also

Specifying an Oracle schema in a data step set statement
SAS and Oracle

Index