topic Re: SQL join in SAS Programming

SQL join

SASPhile — Fri, 15 Feb 2013 16:07:07 GMT

when performing a inner join a where or On will yeild same results?

from INDIV a , acct b ,char c,tads d

where a.id=b.id and

a.id=d.id and

a.id1=d.id1

Idea is to get columns where there are common id's

Reeza — Fri, 15 Feb 2013 16:18:28 GMT

The above may be very helpful.

You can always get to where your going by more than one path, but some are faster than others