https://communities.sas.com/t5/SAS-Programming/Grouping/m-p/508136#M136432 <PRE>Dear All: &nbsp; May data is as follows Date ID Time 22OCT2018 A 9:00 22OCT2018 A 9:00 22OCT2018 A 9:01 22OCT2018 A 9:02 22OCT2018 B 9:08 22OCT2018 B 9:09 22OCT2018 B 9:10 22OCT2018 B 9:10 I want to construct a variable that groups the ID's by time Date ID Time Group 22OCT2018 A 9:00 1 22OCT2018 A 9:00 1 22OCT2018 A 9:01 2 22OCT2018 A 9:02 3 22OCT2018 B 9:08 1 22OCT2018 B 9:09 2 22OCT2018 B 9:10 3 22OCT2018 B 9:10 3</PRE><P>&nbsp;</P><P>Please Help.</P><P>&nbsp;</P><P>Thanx</P><P>&nbsp; Randy</P> Sun, 28 Oct 2018 17:31:34 GMT RandyStan 2018-10-28T17:31:34Z https://communities.sas.com/t5/SAS-Programming/Grouping/m-p/508136#M136432 <PRE>Dear All: &nbsp; May data is as follows Date ID Time 22OCT2018 A 9:00 22OCT2018 A 9:00 22OCT2018 A 9:01 22OCT2018 A 9:02 22OCT2018 B 9:08 22OCT2018 B 9:09 22OCT2018 B 9:10 22OCT2018 B 9:10 I want to construct a variable that groups the ID's by time Date ID Time Group 22OCT2018 A 9:00 1 22OCT2018 A 9:00 1 22OCT2018 A 9:01 2 22OCT2018 A 9:02 3 22OCT2018 B 9:08 1 22OCT2018 B 9:09 2 22OCT2018 B 9:10 3 22OCT2018 B 9:10 3</PRE><P>&nbsp;</P><P>Please Help.</P><P>&nbsp;</P><P>Thanx</P><P>&nbsp; Randy</P> Sun, 28 Oct 2018 17:31:34 GMT https://communities.sas.com/t5/SAS-Programming/Grouping/m-p/508136#M136432 RandyStan 2018-10-28T17:31:34Z https://communities.sas.com/t5/SAS-Programming/Grouping/m-p/508137#M136433 <PRE><CODE class=" language-sas"> data have; input Date : date9. ID $ Time :time5.; format date date9. Time time5.; cards; 22OCT2018 A 9:00 22OCT2018 A 9:00 22OCT2018 A 9:01 22OCT2018 A 9:02 22OCT2018 B 9:08 22OCT2018 B 9:09 22OCT2018 B 9:10 22OCT2018 B 9:10 ; data want; set have; by id time; if first.id then group=1; else if first.time then group+1; run; </CODE></PRE> Sun, 28 Oct 2018 17:39:47 GMT https://communities.sas.com/t5/SAS-Programming/Grouping/m-p/508137#M136433 novinosrin 2018-10-28T17:39:47Z