DATA Step, Macro, Functions and more

Converting nulls to zero

Reply
Contributor
Posts: 20

Converting nulls to zero

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!
Super Contributor
Posts: 673

Re: Converting nulls to zero

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;
Contributor
Posts: 20

Re: Converting nulls to zero

Ah, yes. That looks familiar. Worked like a charm. Thank you!
Ask a Question
Discussion stats
  • 2 replies
  • 140 views
  • 0 likes
  • 2 in conversation