Help using Base SAS procedures

PROC SQL: WHERE vs JOIN

Reply
Contributor
Posts: 58

PROC SQL: WHERE vs JOIN

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.
Thanks

Daniele
Super Contributor
Super Contributor
Posts: 3,174

Re: PROC SQL: WHERE vs JOIN

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:

+"proc sql" +where +join +performance site:sas.com

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 195 views
  • 0 likes
  • 2 in conversation