SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

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

Reply
N/A
Posts: 0

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

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.
Esteemed Advisor
Posts: 5,094

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

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
Data never sleeps
Post a Question
Discussion Stats
  • 1 reply
  • 128 views
  • 0 likes
  • 2 in conversation