topic How do I replace . (missing) with 0 in a Aggregated Mesaure? in SAS Visual Analytics

How do I replace . (missing) with 0 in a Aggregated Mesaure?

Pili1100 — Wed, 01 Sep 2021 21:13:33 GMT

This is my simple calculation:

X = Sum [_ByGroup_] ('y'n) - Sum [_ByGroup_] ('z'n)

If either y or z is missing then x become missing. Here is an example

I want y = 9, z = 0 -> X = 9

Otherwise I will Group the vales in SAS EG before uploading to Viya.

japelin — Thu, 02 Sep 2021 02:17:39 GMT

try using ifn function.

for example

  x=y-ifn(missing(z),0,z);

Sam_SAS — Thu, 02 Sep 2021 13:41:43 GMT

In the Visual Analytics expression editor, you would use the Missing() operator, like this:

IF ( 'Invoice'n Missing )
RETURN 0
ELSE 'Invoice'n

Pili1100 — Fri, 03 Sep 2021 14:55:26 GMT

Thx! 🙂