https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40497#M654 Hi Cynthia,<BR /> <BR /> In DI STUDIO Generally which library we are store our taget datasets.Is There any specific library to store our taget datasets.<BR /> <BR /> Appreciate Great Help<BR /> <BR /> Regards,<BR /> Govind Thu, 21 Aug 2008 05:34:41 GMT deleted_user 2008-08-21T05:34:41Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40494#M651 Hi All,<BR /> I think that Performance wise Proc sql joins take the higher priority when compare to datastep joins.Otherthan this there is any difference <BR /> <BR /> Appriciate great help <BR /> <BR /> Regards,<BR /> Govind Wed, 20 Aug 2008 12:20:13 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40494#M651 deleted_user 2008-08-20T12:20:13Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40495#M652 Hi:<BR /> As this paper points out:<BR /> <A href="http://www2.sas.com/proceedings/forum2007/042-2007.pdf" target="_blank">http://www2.sas.com/proceedings/forum2007/042-2007.pdf</A> (page 4)<BR /> <BR /> "In most cases, a DATA step MERGE statement generally outperforms an SQL outer join, even taking sort resources into account. One exception is a very sparse match join when you only want the observations with matching key values. Also, keep in mind that the SQL procedure and the DATA step MERGE do not provide the same results if you have a many-to-many match."<BR /> <BR /> It really depends on your data and the type of join you want to do. Also, I don't know what you mean by "take the higher priority" -- you have to decide whether you want to optimize your programs and processes for clock time; for CPU resources; for I/O resources; for programmer resources; etc, etc. One technique may be more efficient on one set of data and join conditions, but less efficient on another set of data and join conditions. <BR /> <BR /> You may need to benchmark different techniques to see which programming method works better for your data. Other resources for information are the SAS documentation and user group papers such as these:<BR /> <A href="http://www.ats.ucla.edu/stat/sas/library/nesug99/bt150.pdf" target="_blank">http://www.ats.ucla.edu/stat/sas/library/nesug99/bt150.pdf</A><BR /> <A href="http://www2.sas.com/proceedings/sugi28/096-28.pdf" target="_blank">http://www2.sas.com/proceedings/sugi28/096-28.pdf</A><BR /> <A href="http://analytics.ncsu.edu/sesug/2007/IS02.pdf" target="_blank">http://analytics.ncsu.edu/sesug/2007/IS02.pdf</A><BR /> <BR /> cynthia Wed, 20 Aug 2008 12:36:16 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40495#M652 Cynthia_sas 2008-08-20T12:36:16Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40496#M653 Hi Cynthia,<BR /> <BR /> In DI STUDIO Generally which library we are store our taget datasets.<BR /> <BR /> Appreciate Great Help<BR /> <BR /> Regards,<BR /> Govind Message was edited by: govind_sas@yahoo.co.in Thu, 21 Aug 2008 05:20:05 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40496#M653 deleted_user 2008-08-21T05:20:05Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40497#M654 Hi Cynthia,<BR /> <BR /> In DI STUDIO Generally which library we are store our taget datasets.Is There any specific library to store our taget datasets.<BR /> <BR /> Appreciate Great Help<BR /> <BR /> Regards,<BR /> Govind Thu, 21 Aug 2008 05:34:41 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Difference-B-n-Proc-sql-joins-and-datastep-joins/m-p/40497#M654 deleted_user 2008-08-21T05:34:41Z