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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 7758 views
  • 1 like
  • 2 in conversation