Date:         Fri, 24 Mar 2006 16:28:10 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: a dataset merging question TIA
Comments: To: kiki886@GMAIL.COM
In-Reply-To:  <200603241617.k2OFwOnL002614@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

Lei ,

Yes there is but it requires more code and cpu and real time:

rather than reposting the code check out :

http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0511B&L=sas-l&P=R33793



Toby Dunn





From: Lei Yu <kiki886@GMAIL.COM>
Reply-To: Lei Yu <kiki886@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: a dataset merging question TIA
Date: Fri, 24 Mar 2006 11:17:52 -0500

one approach is sth like this

proc sql noprint;
create table temp1 as
select A.*, B.*
from  a A left join b B
on A.score=B.score;

but I am kinda wondering is there a way to do it in data step using merge
statement, thanks again