Date:         Tue, 20 Sep 2005 11:04:25 -0700
Reply-To:     "Pardee, Roy" <pardee.r@GHC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Pardee, Roy" <pardee.r@GHC.ORG>
Subject:      Re: Imputation
Comments: To: monal kohli <k_monal_99@YAHOO.COM>
Content-Type: text/plain; charset="US-ASCII"

Yep, MODIFY is going to be your friend here I think.

http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000173361.htm


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
monal kohli
Sent: Tuesday, September 20, 2005 10:59 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Imputation

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