Return missing in aggregated measure in SAS Visual Analytics

[MM88]

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

[Madelyn_SAS]

Did you try the MISSING function instead of .

[MM88]

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

[MM88]

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.