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
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
|