BookmarkSubscribeRSS Feed
kwu
SAS Employee kwu
SAS Employee
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.
1 REPLY 1
chang_y_chung_hotmail_com
Obsidian | Level 7
There is undocumented _method option to the proc sql statement. See also Kent's note at
http://support.sas.com/techsup/technote/ts553.html

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 7736 views
  • 1 like
  • 2 in conversation