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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.