topic Re: Summary Tables tool has no Distinct function in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186878#M14306 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Sat, 28 Feb 2015 00:58:51 GMT sdang 2015-02-28T00:58:51Z Summary Tables tool has no Distinct function https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186876#M14304 <HTML><HEAD></HEAD><BODY><P>Please see the image below.&nbsp; Under the heading "GuestNumber" I want the statistics to be Distinct not 'N'.&nbsp; Can I do that in Summary Tables.&nbsp; Our data set is like this:&nbsp; A guest plays multiple times in a month, each row contains information for that day when they played, please see the second image.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/9393_Capture.PNG" /></P><P></P><P><IMG alt="Capture.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/9394_Capture.PNG" /></P></BODY></HTML> Sat, 28 Feb 2015 00:10:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186876#M14304 sdang 2015-02-28T00:10:11Z Re: Summary Tables tool has no Distinct function https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186877#M14305 <HTML><HEAD></HEAD><BODY><P>I don't use EG, but the following indicates that you do have that option: <A href="http://support.sas.com/resources/papers/proceedings14/1890-2014.pdf" title="http://support.sas.com/resources/papers/proceedings14/1890-2014.pdf">http://support.sas.com/resources/papers/proceedings14/1890-2014.pdf</A></P><P></P><P>Search that pdf for the string "distinct".</P></BODY></HTML> Sat, 28 Feb 2015 00:48:36 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186877#M14305 art297 2015-02-28T00:48:36Z Re: Summary Tables tool has no Distinct function https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186878#M14306 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Sat, 28 Feb 2015 00:58:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186878#M14306 sdang 2015-02-28T00:58:51Z Re: Summary Tables tool has no Distinct function https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186879#M14307 <HTML><HEAD></HEAD><BODY><P>If your question is answered (any/all of them) please mark them as answered. </P></BODY></HTML> Sat, 28 Feb 2015 03:23:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Summary-Tables-tool-has-no-Distinct-function/m-p/186879#M14307 Reeza 2015-02-28T03:23:46Z