Hi to all,
I'm translating some queries that I had got from a previous non SAS app to proc SQL SAS. This queries used the WHERE construct to connect the queries, instead of the JOIN.
Usually, it's known that the JOIN statement in a RDBMS has got a much better performance than the WHERE statement, but I wanted to know if this is true also for SAS...in order to decide if it's useful or not to modify the queries manually.
The SAS support website http://support.sas.com/ has several documentation and supplemental technical papers on this topic. Here's a Google advanced search argument that will yield several useful references: