topic Re: return missing if one of the addends is missing using proc means sum in SAS Programming

return missing if one of the addends is missing using proc means sum

Quodly — Sat, 18 Jul 2020 08:35:26 GMT

data a;
  input x y z;
  datalines;
1 2 3
4 5 .
6 . .
;

proc means sum;
run;

have:

x = 11, y = 7, x = 3

want:

x = 11, y = ., x = .

is it possible to enforce this behaviour?

Re: return missing if one of the addends is missing using proc means sum

Kurt_Bremser — Sat, 18 Jul 2020 09:16:33 GMT

I would use a data step:

data want;
set have;
retain sum_x sum_y sum_z 0;
sum_x = sum_x + x;
sum_y = sum_y + y;
sum_z = sum_z + z;
drop x y z;
run;

Re: return missing if one of the addends is missing using proc means sum

Quodly — Sat, 18 Jul 2020 11:39:18 GMT

as my actual dataset is much bigger than my example above, i was wondering if one can imitate the missing behaviour of the plus operator in proc means. using a simple data step with some form of loop over the variables is a good idea, though. thanks, kurt!

Re: return missing if one of the addends is missing using proc means sum

PaigeMiller — Sat, 18 Jul 2020 11:55:21 GMT

I assume by "bigger" you mean that you have a lot more variables.

If so, you can use an array

data want;
    set have;
    array x(*) var1-var200;
    array sum(*) sum1-sum200 (200*0);
    do i=1 to dim(x);
        sum(i)=sum(i)+x(i);
    end;
    drop i;
run;