topic Re: Turning missing value to zero value in SAS Procedures

Turning missing value to zero value

mei — Thu, 14 Jun 2012 02:55:23 GMT

Hi, I have a variable numrec, I wish to turn the missing value into zero. How do i do it?

I have used a long way like this:

data want;

set base;

if numrec=. then numrec1=0;

run;

data want;

set want;

numrec2=sum(numrec,numrec1);

run;

Re: Turning missing value to zero value

SteveNZ — Thu, 14 Jun 2012 03:11:49 GMT

Try:

new_num = sum(numrec,0) ;

Re: Turning missing value to zero value

Ksharp — Thu, 14 Jun 2012 03:12:01 GMT

Do you want all the variables which are missing to be zero ?

data class;

set sashelp.class;

if ranuni(-1) lt .4 then call missing(of _numeric_);

run;

proc stdize data=class out=new_class reponly missing=0;run;

Ksharp

Re: Turning missing value to zero value

MikeZdeb — Thu, 14 Jun 2012 03:42:32 GMT

hi ... if it's only one variable ...

data x;

input numrec @@;

datalines;

. 1 2 3 0 . 7 8

;

data x;

set x;

numrec+0;

run;

Re: Turning missing value to zero value

shivas — Thu, 14 Jun 2012 04:07:27 GMT

Hi,

Try this..

data have;

input no no1 no2;

cards;

2 . 4

. 3 6

2 8 .

. . .

;

run;

data want;

set have;

array xx[3] no no1 no2;

do i=1 to dim(xx);

if xx=. then xx=0;

end;

run;

Thanks,

Shiva