|
proc stdize data=have out=want method=sum reponly missing=0;
var _numeric_; *or other list;
run;
On 5/7/12, Randy <randistan69@hotmail.com> wrote:
> I have many variables that have missing value that I want to set to zero.
> Is it possible to do it in a shorter way
>
> I wrote:
>
> data want ; set have ;
> if VarA = 2 and VarB = . then VarB = 0 ;
> if VarA = 3 and VarB = . then VarB = 0;
> /* and so on*/
> run;
>
> VarA goes from 2-50 and I have 10 other Vars. Unfortunately they are not
> numbered.
> Randy
>
| 
