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?
Hi and welcome to the SAS online community. Do you want to solve this problem with SAS VA? Or SAS code?
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.
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.