Convert Zeros to NULL

[JayCompany]

Hello,

   I have a very large dataset with multiple variables. Some of these variables have a value of zero, which I'd like to convert to 'NULL'. How would I go about doing this? 

Eg:

Desciprtion, VariableA#, VariableB#.......VariableZ#

Thanks! 

[Kurt_Bremser]

In SAS, missing numerical values are represented by a dot. So do

if variable = 0 then variable = .;

[ballardw]

One way assuming all the variables are numeric:

data want;
   set have;
   array v var1 var2 varx;   /* add variables as needed*/
   do i=1 to dim(v);
     if v[i]=0 then v[i]=.;
   end;
   drop i;
run;

[SuryaKiran]

If the variables are numeric then try this:

PROC FORMAT;
value Null .="NULL";
run;
data want;
set Have ;

array Change _numeric_;
do over change;
if change>10 then change=.;
end;
FORMAT _NUMERIC_ Null.;
run;