DATA Step, Macro, Functions and more

how to find the execution plan of proc sql?

Reply
SAS Employee kwu
SAS Employee
Posts: 34

how to find the execution plan of proc sql?

I would like to know how SAS proc sql process a query and see what type of join it performs and if I should use a proc sql or a data step.

Any information about the sql query optimizer, or how optimizer comes up the execution plan would be a great help.
Thanks in advance.
Regular Contributor
Posts: 241

Re: how to find the execution plan of proc sql?

There is undocumented _method option to the proc sql statement. See also Kent's note at
http://support.sas.com/techsup/technote/ts553.html
Ask a Question
Discussion stats
  • 1 reply
  • 2127 views
  • 1 like
  • 2 in conversation