topic Re: Return missing in aggregated measure in SAS Visual Analytics in SAS Visual Analytics

Return missing in aggregated measure in SAS Visual Analytics

MM88 — Tue, 27 Jun 2023 15:29:51 GMT

Hi experts,

Is it possible to return missing value in an aggregated measure in SAS Visual Analytics?

Example:

IF ( Max [_ByGroup_] (TreatAs(_Number_, 'Date1'n[Raw])) <= Max [_ByGroup_] (TreatAs(_Number_, 'Date2'n[Raw])) )
RETURN ( Sum [_ByGroup_] ('myvar1'n) / Sum [_ByGroup_] ('myvar2'n) )
ELSE .

SAS gives an error saying that there is an element that cannot be aggregated (the missing .)

I don't like to return 0. Are there any options to return missing?

Thanks

Re: Return missing in aggregated measure in SAS Visual Analytics

Madelyn_SAS — Tue, 27 Jun 2023 15:42:43 GMT

Did you try the MISSING function instead of .

Re: Return missing in aggregated measure in SAS Visual Analytics

MM88 — Tue, 27 Jun 2023 15:53:22 GMT

@Madelyn_SAS, coould you please give an example? SAS VA gives error because MISSING function return bool, instead of numeric.

Re: Return missing in aggregated measure in SAS Visual Analytics

MM88 — Thu, 29 Jun 2023 06:26:44 GMT

Hi community,

Perhaps there is a better solution. I made it work creating a 'dummy' integer variable containing only missing in the data source.

Applying any function (Min [_ByGroup_], Max [_ByGroup_]) to this variable in SAs Visual Analytics you can obtain the missing value.

Any other ideas, please share.

Regards.