BookmarkSubscribeRSS Feed
sdang
Quartz | Level 8

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.

Capture.PNG

Capture.PNG

3 REPLIES 3
art297
Opal | Level 21

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".

sdang
Quartz | Level 8

Thank you

Reeza
Super User

If your question is answered (any/all of them) please mark them as answered.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1611 views
  • 3 likes
  • 3 in conversation