Clever Geek Handbook

SAS: mapping SQL to database

As the title says, I'm very curious to know if there is a way to show / show the SQL that SAS is actually dropping into the database?

I know general things like to avoid custom SAS functions in your sql proc and use tables from the same library etc. But it would be very helpful to see the SQL pushed to the database as some features may be supported and some may not.

Is it possible?

+3


source to share


1 answer


options sastrace = ',, d' sastraceloc = saslog nostsuffix;



This will show the SQL statements being preempted in the SAS log.

+4


source






More articles:


All Articles