Desktop productivity for business analysts and programmers

Summary Tables tool has no Distinct function

Reply
Frequent Contributor
Posts: 104

Summary Tables tool has no Distinct function

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

PROC Star
Posts: 7,429

Re: Summary Tables tool has no Distinct function

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

Frequent Contributor
Posts: 104

Re: Summary Tables tool has no Distinct function

Thank you

Super User
Posts: 19,023

Re: Summary Tables tool has no Distinct function

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

Ask a Question
Discussion stats
  • 3 replies
  • 293 views
  • 3 likes
  • 3 in conversation