Date: Tue, 16 Nov 2004 20:40:08 GMT
Reply-To: Rob <gofyself@WRONG.ADDRESS.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Rob <gofyself@WRONG.ADDRESS.COM>
New to this ng and to SAS so please excuse a naive question:
I have two tables a and b. Both have the same common key. All I want to
do is match a to b returning a row for all rows in a that have a match in b.
I'm only trying to pull off one extra field from b.
A looks like this
ID Name Address
1 Fred 1 Road Road
1 Jim 94 Road Road
2 George 91 Road Road
3 Barney 104 Road Road
B looks like this
So what I'd like to see is:
1 Fred 1 Road Road Athlon
2 Jim 94 Road Road P4
3 Barney 104 Road Road n/a
[sorry if the tabs don't show up correctly on your servers]
I've been doing this via a proc sql with and without a left join on ID but
I'm not ending up with 3 rows in the table I create. It's doing something
else. I've also tried using merge instead but again I end up with more
than the 3 rows I'm expecting.
Advice please - this is so simple in Excel, but with 15 million rows, it's
not going to be Excel friendly.