I am writing a proc sql using SAS/ACCESS for Oracle. This is my library statement: libname oradb oracle user=&sysuserid. password='{SAS002}XXXX' path=db_path schema=db_schema sql_functions=all; I used sastrace to check the generated sql and execution location of this sql: options sastrace=',,,d' sastraceloc=saslog nostsuffix; Usually generated sql is executing in Oracle environment. But when I use PUT() to change forrmat then sql is executing in SAS environment and its impacting performance: SAS_SQL: Unable to convert the query to a DBMS specific SQL statement due to an error. ACCESS ENGINE: SQL statement was not passed to the DBMS, SAS will do the processing. I have a requirement to change the datetime and number to character format before using it in case when statement: proc sql; select case when a.id is not null then put(a.age,8.) when a.id is null then 'N/A' as age from oradb.table_nm as a; quit; Is there other way to change datetime or Number to Char so that SQL can process in DBMS environment? Any help or suggestion wil be much appreciate. Thanks
... View more