Und so geht’s:
libname ORASAS9 ORACLE path="oraunix.ger.sas.com" schema=XXX
dbprompt=yes;

options sastrace==',,,d' sastraceloc=saslog nostsuffix;

proc sql;
create table work.test
as select * from orasas9.product_dim
where supplier_id=50;
quit;


Auszug aus dem Log:

ORACLE_7: Prepared:
SELECT "PRODUCT_ID", "PRODUCT_NAME", "SUPPLIER_ID", "PRODUCT_GROUP", "PRODUCT_CATEGORY",
"PRODUCT_LINE" FROM sas9.PRODUCT_DIM WHERE ("SUPPLIER_ID" = 50 )

ORACLE_8: Executed:
SELECT statement ORACLE_7