Hi Experts,
I want to calculate the number of distinct daily users logged in during the quarter.
The calculation formula is as follows: Daily average (Count distinct users each day of the quarter).
But the problem is that I don't know how to apply the AggregateTable in this case.
Thank you in advance for your help.
Betty
Hi Betty,
In general, VA does not do nested aggregations and distinct count is a type of aggregation.
If you are able to precalculate the distinct count as part of your data preparation, that would simplify things. I believe it should be possible with PROC SQL.
Sam
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.