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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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
  • 1700 views
  • 3 likes
  • 3 in conversation