10-13-2017 01:03 PM
I'm using SAS VA 7.3.
I've created an Aggregated measure.
But If one of my measure's value is missing then aggregated formula is also returning a missing value.
In base SAS we can use Sum(var1,var2) function to avoid this problem.
But in VA it is giving me syntax error.
What should I modify in this formula to add numbers with missing value?
Sum [_ByGroup_] ('M1'n) / ( Sum [_ByGroup_] ('M2'n) + Sum [_ByGroup_] ('M3'n) )
10-16-2017 06:06 PM - edited 10-16-2017 06:07 PM
Thanks @FredrikE I tried but It didn't work.
I tried Sum [_ByGroup_] (max('C_B7'n)) but then got "Unknown Error" message.
10-16-2017 06:10 PM
Btw for a quick fix I replaced all missing values to 0 (zero).
It worked for now.
But I'll be looking for a good solution of this problem.
I'm sure there should be some way to negate missing value effect.