topic Re: Converting nulls to zero in SAS Programming

Converting nulls to zero

jawon — Fri, 08 May 2009 17:52:32 GMT

I have about 20 numeric variables that can potentially have a null value. I'd like to convert all of them into zero. I don't want to list out each variable individually. I know I've done this before with just a few lines of code, maybe with an array, but can't seem to remember exactly.

Suggestions? Thanks!

Re: Converting nulls to zero

SASPhile — Fri, 08 May 2009 18:43:21 GMT

Here it goes!
data abc;
set xyz;
array test (*) _numeric_;
do i= 1 to dim(test);
if test(i)=. then test(i)=0;
end;
run;

Re: Converting nulls to zero

jawon — Fri, 08 May 2009 18:54:54 GMT

Ah, yes. That looks familiar. Worked like a charm. Thank you!