PROC SQL exec output

Jaime · Posted 09-23-2010 09:54 AM

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 · Posted 09-23-2010 10:46 AM

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

Peter_C · Posted 09-24-2010 12:13 PM

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

PROC SQL exec output

Re: PROC SQL exec output

Re: PROC SQL exec output

PROC SQL exec output

Re: PROC SQL exec output

Re: PROC SQL exec output

Click image to register for webinar

Classroom Training Available!