Help using Base SAS procedures

PROC SQL exec output

Reply
Frequent Contributor
Posts: 115

PROC SQL exec output

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.
Super Contributor
Posts: 288

Re: PROC SQL exec output

chang_y_chung found a paper on that topic:
http://support.sas.com/forums/thread.jspa?messageID=43038ꠞ
Valued Guide
Posts: 2,175

Re: PROC SQL exec output

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
Ask a Question
Discussion stats
  • 2 replies
  • 132 views
  • 0 likes
  • 3 in conversation