Date:         Thu, 29 Jan 1998 09:10:16 -0800
Reply-To:     Scott Carl <SCARL@THECREEK.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Scott Carl <SCARL@THECREEK.COM>
Subject:      Datastep implementation of an inner join.
Content-Type: text/plain

Hi,
 
Can anyone give me a simple example that illustrates an inner join using
a datastep, rather than proc sql? E.g.
 
data one;
        input key a;
lines;
1 1
2 3
3 4
5 5
6 6
;run;
 
data two;
        input key b;
lines;
0 2
1 4
2 5
3 6
6 7
8 9
;run;
 
proc sql;
        select i.*,j.b
        from one i,two j
        where i.key=j.key
        order by key;
quit;