BookmarkSubscribeRSS Feed
jony123
Fluorite | Level 6

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?

 

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

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

jony123
Fluorite | Level 6
Hi,
Thank you,
I want to solve it by using VA

Best Regards

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1099 views
  • 0 likes
  • 2 in conversation