topic Re: Total Score without counting rows with missing data in SAS Programming

Total Score without counting rows with missing data

RNscientist — Tue, 05 Dec 2023 16:15:34 GMT

Hello.

I am trying to sum 5 columns to get a total score for each participant (row); however, I don't want SAS to sum rows with missing data, but I also don't want to delete those participants as I have data for them on a different variable.

So far I have tried

data want;
set have;
sum_W1= sum(var1, var2, var3, var4, var5);

run;

however this sums across the row even if I'm missing data in 4 out of the 5 columns.

For instance

var 1 var 2 var 3 var 4 var 5

. . 3 . .

This is giving me a total score of 3 but I want it to read .

Thanks for any help!

Re: Total Score without counting rows with missing data

Astounding — Tue, 05 Dec 2023 16:34:03 GMT

This might suit what you are asking for:

if n(of var1-var5) = 5 then sum_W1=sum(of var1-var5);

Make sure you include that key word "of". Without it, SAS will compute var1 minus var5.

Re: Total Score without counting rows with missing data

RNscientist — Tue, 05 Dec 2023 16:45:55 GMT

YES! Thank you so much!!!

Re: Total Score without counting rows with missing data

ballardw — Tue, 05 Dec 2023 17:25:09 GMT

Admittedly long to type for many variables but the + operator will return missing if any of the variables are missing:

sum_W1= var1+ var2+ var3+ var4+ var5;