| Date: | Wed, 23 May 2007 12:14:44 -0400 |
|---|
| Reply-To: | "data _null_;" <datanull@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "data _null_;" <datanull@GMAIL.COM> |
|---|
| Subject: | Re: Missing Value to Zero(0) |
|---|
|
| In-Reply-To: | <1179932533.090536.193580@u30g2000hsc.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1; format=flowed |
|---|
proc stdize missing=0 reponly method=sum out=<myDataWithMissings2Zeros>;
run;
On 5/23/07, Sasi <pl.sasikumar@gmail.com> wrote:
> Hi,
>
> How to assign missing value to zero, if i am having lots of variable.
> Any easy way to do it..
>
> Data new;
> set old;
> if ab eq . then ab = 0;
> if ts eq . then ts = 0;
> if b5 eq . then b5 = 0;
> if q6 eq . then q6 = 0;
> ....................
> ..................
> ................
> run;
>
> In common I want to check all the variables in the dataset for the
> missing condition to assign it as zero.
>
> Thanks in advance,
> Sasikumar
>
|
