topic Re: Convert Zeros to NULL in SAS Programming

Convert Zeros to NULL

JayCompany — Fri, 01 Dec 2017 16:43:40 GMT

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!

Re: Convert Zeros to NULL

Kurt_Bremser — Fri, 01 Dec 2017 16:51:05 GMT

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

if variable = 0 then variable = .;

Re: Convert Zeros to NULL

ballardw — Fri, 01 Dec 2017 18:44:39 GMT

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;

Re: Convert Zeros to NULL

SuryaKiran — Fri, 01 Dec 2017 21:30:37 GMT

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;