topic Re: how to succesfully summarize using the Count Distinct option in EG in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122238#M10111 <HTML><HEAD></HEAD><BODY><P>It didn't help, eventhough my date variables (Hour, day and month) the summary table keeps on counting repeating IDemployee numbers.</P></BODY></HTML> Fri, 11 Jan 2013 16:32:37 GMT CesarOmarHR 2013-01-11T16:32:37Z how to succesfully summarize using the Count Distinct option in EG https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122235#M10108 <HTML><HEAD></HEAD><BODY><P>I'm trying to generate a summary table consisting of number of employees involved in tasks at certain hour ranges. But when creating the table, an employee that made a task twice in the hour range gets counted double.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; January&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sunday&nbsp;&nbsp;&nbsp;&nbsp; Monday&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tuesday&nbsp;&nbsp;&nbsp;&nbsp; Wednesday&nbsp;&nbsp;&nbsp;&nbsp; Thursday&nbsp;&nbsp;&nbsp;&nbsp; Friday&nbsp;&nbsp;&nbsp;&nbsp; Saturday</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; 8:00-8:59&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 47</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 9:00-9:59</P><P> 10:00-10:59</P><P></P><P>And the correct</P><P>count is&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42</P><P></P><P></P><P>Using EG, how it is possible to get a non repeating count of IDEmployee?</P><P></P><P>Thanks in advance</P><P></P><P></P><P>César</P></BODY></HTML> Fri, 11 Jan 2013 00:01:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122235#M10108 CesarOmarHR 2013-01-11T00:01:41Z Re: how to succesfully summarize using the Count Distinct option in EG https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122236#M10109 <HTML><HEAD></HEAD><BODY><P>It would be helpful to show generated code, but from your description you may have included time in the criteria. If the actual times are different, i.e. 8:15 and 8:30 they are distinct records. You may get around this by including something like Hour(time) in the distinct criteria.</P></BODY></HTML> Fri, 11 Jan 2013 15:37:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122236#M10109 ballardw 2013-01-11T15:37:26Z Re: how to succesfully summarize using the Count Distinct option in EG https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122237#M10110 <HTML><HEAD></HEAD><BODY><P>Thanks, instead of using a reduced form with the time format (time2.) i'll make the format you suggest to see if summary table avoids repeating IDemployee when counting.</P></BODY></HTML> Fri, 11 Jan 2013 15:51:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122237#M10110 CesarOmarHR 2013-01-11T15:51:49Z Re: how to succesfully summarize using the Count Distinct option in EG https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122238#M10111 <HTML><HEAD></HEAD><BODY><P>It didn't help, eventhough my date variables (Hour, day and month) the summary table keeps on counting repeating IDemployee numbers.</P></BODY></HTML> Fri, 11 Jan 2013 16:32:37 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-succesfully-summarize-using-the-Count-Distinct-option-in/m-p/122238#M10111 CesarOmarHR 2013-01-11T16:32:37Z