You may not have the permissions to create views in the schema you're accessing, but I think if your able to connect using implicit SQL pass-through (which you seem to have), then you should be able to connect via explicit SQL pass-through without needing assistance or modification of the DB. Try something like this: LIBNAME OracSAS ORACLE USER=&UserNm PASS=&PassWd PATH='DB_NAME' CONNECTION=GLOBAL SCHEMA=SCHEMA_NAME; PROC SQL; CONNECT USING OracSAS AS OracDB; SELECT * FROM CONNECTION TO OracDB (SELECT ASCIISTR(COLUMN_A) AS COL_A_ASCII FROM TABLE_1); DISCONNECT FROM OracDB; ;QUIT;
... View more