https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-exec-output/m-p/74250#M21500 Hi all, <BR /> <BR /> I can't seem to find the answer to this question. Is there an option in proc sql that would dump into the log the sql procedure that was sent to the server?<BR /> <BR /> I have an sql generated sql string and I want to see what is actually being sent to the server. Thu, 23 Sep 2010 13:54:52 GMT Jaime 2010-09-23T13:54:52Z https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-exec-output/m-p/74250#M21500 Hi all, <BR /> <BR /> I can't seem to find the answer to this question. Is there an option in proc sql that would dump into the log the sql procedure that was sent to the server?<BR /> <BR /> I have an sql generated sql string and I want to see what is actually being sent to the server. Thu, 23 Sep 2010 13:54:52 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-exec-output/m-p/74250#M21500 Jaime 2010-09-23T13:54:52Z https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-exec-output/m-p/74251#M21501 chang_y_chung found a paper on that topic:<BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=43038ꠞ" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=43038ꠞ</A> Thu, 23 Sep 2010 14:46:20 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-exec-output/m-p/74251#M21501 andreas_lds 2010-09-23T14:46:20Z https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-exec-output/m-p/74252#M21502 and have a look at the optional values for the system option SASTRACE<BR /> The examples in the on-line doc should help you choose the level of deatil you need Fri, 24 Sep 2010 16:13:35 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-exec-output/m-p/74252#M21502 Peter_C 2010-09-24T16:13:35Z