How the Proc sql join is differ From Oracle database sql joins

[deleted_user]

Hi ,
I want to know about How the proc sql joins in sas differ from Oracle database joins and performance wise which one is better.

Appreciate great Help

Regards,
Govind.

[LinusH]

This is not quite a MS Office question, is it?
Nevertheless, there are no simple yes/no answer to this. If you got a typical query, try it out in both SAS and Oracle.

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.

/Linus