Please see the image below. Under the heading "GuestNumber" I want the statistics to be Distinct not 'N'. Can I do that in Summary Tables. Our data set is like this: A guest plays multiple times in a month, each row contains information for that day when they played, please see the second image.
I don't use EG, but the following indicates that you do have that option: http://support.sas.com/resources/papers/proceedings14/1890-2014.pdf
Search that pdf for the string "distinct".
Thank you
If your question is answered (any/all of them) please mark them as answered.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.