PROC SQL exec output

[Jaime]

Hi all,

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?

I have an sql generated sql string and I want to see what is actually being sent to the server.

[andreas_lds]

chang_y_chung found a paper on that topic:
http://support.sas.com/forums/thread.jspa?messageID=43038ꠞ

[Peter_C]

and have a look at the optional values for the system option SASTRACE
The examples in the on-line doc should help you choose the level of deatil you need