BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
1 REPLY 1
LinusH
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 630 views
  • 0 likes
  • 2 in conversation