I cannot access sas viya in these moments.
But the steps are:
I think after creating the count distinct variable you'll need to "fix" it by creating an aggregated table with this variable.
The aggregated table allows you to make calculations with it, in the original table it will result most likely in an error saying "you cannot do this with a aggregated measure"
this trick iften helps.
Hi acordes
I have created a new distinct count from my ID category. and it has placed it under aggregate measure. I now created a new calculated item using aggregate table. I am getting errors. I am not sure if i am doing it the correct way.
Your assistance is greatly appreciated
That's what I meant when saying that it will throw out an error.
You have to make an aggregated table carrying over this newly created distinct count variable (plus the other variables you need).
There you can use it as a static variable in your calculations.
Hi Acordes
Can you provide me with an example on how to perform this?
I cannot access sas viya in these moments.
But the steps are:
In older versions of SAS you didn't have to create a whole different data table just to create a simple distinct count. There should be an easier way to do this.
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 16. 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.