Hi starnassi, Did you ever work out a solution, I just came across a problem that now has this problem too. I was thinking you could do the distinct count -1 but not sure I can be sure there will always be a MISSING value. I too need to do in SASVA rather than data prep as I am looking to do the distinct count on an calculated item with an IF ELSE statement. Thanks
... View more