topic Re: Visual Analytics Distinct Count in SAS Visual Analytics

Visual Analytics Distinct Count

kselboe — Tue, 29 Sep 2020 07:21:31 GMT

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

Re: Visual Analytics Distinct Count

Madelyn_SAS — Tue, 29 Sep 2020 13:24:58 GMT

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