https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-WHERE-vs-JOIN/m-p/69675#M20034 The SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> has several documentation and supplemental technical papers on this topic. Here's a Google advanced search argument that will yield several useful references:<BR /> <BR /> +"proc sql" +where +join +performance site:sas.com<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Fri, 16 Jan 2009 11:58:10 GMT sbb 2009-01-16T11:58:10Z https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-WHERE-vs-JOIN/m-p/69674#M20033 Hi to all,<BR /> I'm translating some queries that I had got from a previous non SAS app to proc SQL SAS. This queries used the WHERE construct to connect the queries, instead of the JOIN.<BR /> Usually, it's known that the JOIN statement in a RDBMS has got a much better performance than the WHERE statement, but I wanted to know if this is true also for SAS...in order to decide if it's useful or not to modify the queries manually.<BR /> Thanks<BR /> <BR /> Daniele Fri, 16 Jan 2009 10:32:29 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-WHERE-vs-JOIN/m-p/69674#M20033 DanieleTiles 2009-01-16T10:32:29Z https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-WHERE-vs-JOIN/m-p/69675#M20034 The SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> has several documentation and supplemental technical papers on this topic. Here's a Google advanced search argument that will yield several useful references:<BR /> <BR /> +"proc sql" +where +join +performance site:sas.com<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Fri, 16 Jan 2009 11:58:10 GMT https://communities.sas.com/t5/SAS-Procedures/PROC-SQL-WHERE-vs-JOIN/m-p/69675#M20034 sbb 2009-01-16T11:58:10Z