https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-the-Proc-sql-join-is-differ-From-Oracle-database-sql-joins/m-p/67027#M904 Hi ,<BR /> I want to know about How the proc sql joins in sas differ from Oracle database joins and performance wise which one is better.<BR /> <BR /> Appreciate great Help<BR /> <BR /> Regards,<BR /> Govind. Tue, 23 Dec 2008 06:56:31 GMT deleted_user 2008-12-23T06:56:31Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-the-Proc-sql-join-is-differ-From-Oracle-database-sql-joins/m-p/67027#M904 Hi ,<BR /> I want to know about How the proc sql joins in sas differ from Oracle database joins and performance wise which one is better.<BR /> <BR /> Appreciate great Help<BR /> <BR /> Regards,<BR /> Govind. Tue, 23 Dec 2008 06:56:31 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-the-Proc-sql-join-is-differ-From-Oracle-database-sql-joins/m-p/67027#M904 deleted_user 2008-12-23T06:56:31Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-the-Proc-sql-join-is-differ-From-Oracle-database-sql-joins/m-p/67028#M905 This is not quite a MS Office question, is it?<BR /> Nevertheless, there are no simple yes/no answer to this. If you got a typical query, try it out in both SAS and Oracle.<BR /> <BR /> To look behind the curtains a bit, you could use _method option in Proc SQL for SAS joins. MESGLEVEL=I will tell you if index is used for join optimization. debug=',,,D' sastraceloc=SASLOG will give you the Oracle SQL when doing implicit SQL pass.tru using LIBNAME ORACLE.<BR /> <BR /> /Linus Wed, 31 Dec 2008 08:12:31 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/How-the-Proc-sql-join-is-differ-From-Oracle-database-sql-joins/m-p/67028#M905 LinusH 2008-12-31T08:12:31Z