Visual Analytics Distinct Count

[kselboe]

Hi!

I have a problem with my distinct count in SAS VA. It returns 1 when I should get 0. It seems like the value is increased by 1 when I only have "missing fields" in the variable I performs the count on.

I found this in the documentation:

Do anybody have a fix for this?

Best

Kristian

[Madelyn_SAS · Accepted solution]

There is an IgnoreMissingInCountDistinct property that you can enable to tell SAS Visual Analytics to ignore missing values in distinct counts. In Visual Analytics on SAS Viya, the property is set in sas.reportdata.properties

sas.reportdata properties

In Visual Analytics 7.x, the property is set in SAS Management Console. 

Properties Reference