I want to calculate Surprise_A = (Act - SurvA)/ STD. But there are missing values in each of Act, SurvA and STD. And, STD can also be 0. If there is a missing value in any of these, or STD = 0, I would not calculate Surprise_A for that observation. So I coded the following way: if Act NE 9999 or SurvA NE 9999 or STD NE 9999 or STD NE 0 then
Surprise_A=(Act-SurvA)/STD;
else Surprise_A=9999; I am not getting desired results. I still get note for division by 0, and I don't see any Surprise_A having 9999. Where am I wrong? I much appreciate your time as always. Thank you.
... View more