Count Distinct Issue

jony123 — Fri, 21 Sep 2018 08:19:10 GMT

Hi ,

When we are using Count Distinct for a measure , and using the measure in A cross table, the sum for the count distinct is for all table and not the different categories .

For example, a table with Males and Females

The Total count distinct will be for all ( Male + Female ) and will be total of 19 .

But in the table (F, M) you will have more cases. lets say 9 females and 11 males.( One Female is also a Male ) .

I want the ability to show Total of 20 using only the count distinct measure

gender countdistinct count

M 10 10

F 9 10

TOTAL 19 20

Is it possible?

Re: Count Distinct Issue

PeterClemmensen — Fri, 21 Sep 2018 12:22:47 GMT

Hi and welcome to the SAS online community. Do you want to solve this problem with SAS VA? Or SAS code?

Re: Count Distinct Issue

jony123 — Fri, 21 Sep 2018 12:47:32 GMT

Hi,
Thank you,
I want to solve it by using VA

Best Regards

topic Count Distinct Issue in SAS Visual Analytics

Count Distinct Issue

Re: Count Distinct Issue

Re: Count Distinct Issue