LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 9 Feb 2004 09:38:45 +0100
Reply-To:     Lars Wahlgren <Lars.WahlgrenRemove@THIS.STAT.LU.SE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lars Wahlgren <Lars.WahlgrenRemove@THIS.STAT.LU.SE>
Organization: Lund university
Subject:      Re: Picking Common records

or you could use merge in a data step like

data ab ; merge a (in=a_flag) b (in=b_flag) ; by id ; if a_flag & b_flag ; run ;

hth

/LWn

"Maand M" <maand_n_dune@YAHOO.COM> skrev i meddelandet news:20040209044651.38587.qmail@web21504.mail.yahoo.com... > Hi, > I have different datasets from which I need to pick common records (ie on common ID variable) > > The Data set looks something like this > > Dataset a > > id var1 var2 var3 > 10 a 4 6 > 12 t 5 9 > 14 p 1 0 > 16 h 5 8 > 17 u 12 6 > > Dataset b > > id var1 var2 var3 > 9 a 5 16 > 11 f 12 8 > 14 p 1 0 > 16 h 5 8 > 21 d 9 9 > > so the common records will be > > id var1 var2 var3 > 14 p 1 0 > 16 h 5 8 > > Can someone please help me > > Thanks > > Maand > > __________________________________ > Do you Yahoo!? > Yahoo! Finance: Get your refund fast by filing online. > http://taxes.yahoo.com/filing.html


Back to: Top of message | Previous page | Main SAS-L page