Date:         Tue, 9 Sep 2008 05:48:48 -0500
Reply-To:     "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Subject:      Re: Replacing with minimum
Comments: To: Sierra Info Services <sfbay0001@aol.com>
In-Reply-To:  <eead9755-1f99-4eb4-b012-f2cd415dbd65@r66g2000hsg.googlegroups.com>
Content-Type: text/plain; charset=UTF-8

Indeed it is...

data a;
   input a @@;
   cards;
10 . 2 31 . 42 1 3 .
;;;;
   run;
proc stdize method=range reponly out=min;
   run;
proc print;
   run;


On 9/9/08, Sierra Info Services <sfbay0001@aol.com> wrote:
> I think this functionality is available in PROC STDIZE, added to SAS/
> STAT in V 8
>
>
> Hope this helps...
>
> Andrew
>
> On Sep 9, 3:48�am, shashi <shashi2...@gmail.com> wrote:
> > Hi,
> > Here I have a query.
> > My data contains a variable 'a' alone. I want to replace the missings
> > with the minimum of all the values(Assume there are no 0's in the
> > data) among all the observations.
> >
> > a
> >
> > 10
> > .
> > 2
> > 31
> > .
> > 42
> > 1
> > 3
> > .
> >
> > That is my data should look like:
> >
> > a
> >
> > 10
> > 1
> > 2
> > 31
> > 1
> > 42
> > 3
> > 1
> >
> > where I replaced the missings with the minimum i.e. 1 here.
> > Could anybody help a way in this regard?
>