topic Re: Mean of missing and unmissing obs in SAS Programming

Mean of missing and unmissing obs

ChuksManuel — Mon, 18 Nov 2019 12:46:21 GMT

Hello,

I am trying to find the mean of variables in an observation that has missing values.

for example, if T1 T2 T3 are the variables, their mean would be (t1 +t2+t3)/3= T_mean.

However, i discovered that SAS ouput a missing value for T_mean if any of the T1-T3 values are missing.

My question is how do i make sas treat the missing as zero in order to compute the mean.

PeterClemmensen — Mon, 18 Nov 2019 12:56:17 GMT

Can you show the code you have now?

Kurt_Bremser — Mon, 18 Nov 2019 13:00:09 GMT

The mean() function handles missing values correctly.

ChuksManuel — Mon, 18 Nov 2019 13:02:35 GMT

Thanks!

PeterClemmensen — Mon, 18 Nov 2019 13:08:21 GMT

@ChuksManuel just to add to this thread. The Mean Function ignores missing values. It does not treat them as zero. There is a big difference.