https://communities.sas.com/t5/SAS-Programming/how-to-find-the-execution-plan-of-proc-sql/m-p/74054#M15983 There is undocumented _method option to the proc sql statement. See also Kent's note at <BR /> <A href="http://support.sas.com/techsup/technote/ts553.html" target="_blank">http://support.sas.com/techsup/technote/ts553.html</A> Wed, 22 Sep 2010 20:30:49 GMT chang_y_chung_hotmail_com 2010-09-22T20:30:49Z https://communities.sas.com/t5/SAS-Programming/how-to-find-the-execution-plan-of-proc-sql/m-p/74053#M15982 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. <BR /> <BR /> Any information about the sql query optimizer, or how optimizer comes up the execution plan would be a great help. <BR /> Thanks in advance. Wed, 22 Sep 2010 19:21:17 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-the-execution-plan-of-proc-sql/m-p/74053#M15982 kwu 2010-09-22T19:21:17Z https://communities.sas.com/t5/SAS-Programming/how-to-find-the-execution-plan-of-proc-sql/m-p/74054#M15983 There is undocumented _method option to the proc sql statement. See also Kent's note at <BR /> <A href="http://support.sas.com/techsup/technote/ts553.html" target="_blank">http://support.sas.com/techsup/technote/ts553.html</A> Wed, 22 Sep 2010 20:30:49 GMT https://communities.sas.com/t5/SAS-Programming/how-to-find-the-execution-plan-of-proc-sql/m-p/74054#M15983 chang_y_chung_hotmail_com 2010-09-22T20:30:49Z