SAS option: sastrace

sastrace = ',,,d'

Setting sastrace to ,,,d allows to view the sql statements that SAS sends to a DBMS:

%let ora_user     = sasdba;
%let ora_password = secret_garden;
%let ora_server   = ora.test.renenyffenegger.ch;

options
  sastrace    = ',,,d'   /* show SQL statements sent to data source */
  sastraceloc = saslog   /* required on PC platforms                */
  nostsuffix             /* nostsuffix: make log more readable      */
;


libname tq84_ora
   oracle 
   user                     = &ora_user
   password                 = &ora_password
   path                     = &ora_server
   sql_functions            = all
   db_length_semantics_byte = no
;


data dual;
  set tq84_ora.dual (schema=sys);
run;
/*
ORACLE_4: Prepared: on connection 37
SELECT * FROM sys.DUAL
*/

Github repository about-SAS, path: /programming/options/sastrace/log-SQL-statements.sas

With this feature, it's possible to determine how SAS functions are translated to Oracle functions.

SAS option: sastrace

sastrace = ',,,d'

See also