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 (September 2005, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 20 Sep 2005 10:59:17 -0700
Reply-To:     monal kohli <k_monal_99@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         monal kohli <k_monal_99@YAHOO.COM>
Subject:      Re: Imputation
Comments: To: Premalatha T <mailprems@yahoo.com>
In-Reply-To:  <20050920175202.74874.qmail@web30607.mail.mud.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1

Just merge them: data new; merge bad(in=a) good(in=b); by "your variables common to both datasets"; if a and b; run;

You can also use set statements and modify option. If you have index defined,you can merge them both by using KEY option and _IORC_ .

HTH Mona

--- Premalatha T <mailprems@YAHOO.COM> wrote:

> Hi, > > > > I have two data sets named ‘good’ and ‘bad’. I want > to impute values for the data in the ‘bad’ data set > based on the ‘good’ set. I have variables like model > year, make and type which can be used to compare the > datasets. > > Actually, I want to retrieve values from the ‘good’ > data set based on model year, make and type and > assign it to the ‘bad’ data set. > > > > I request you to help me in this issue. > > > > Thank you for your help. > > > > Regards, > Premalatha > > > --------------------------------- > Yahoo! for Good > Click here to donate to the Hurricane Katrina > relief effort. >

__________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com


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