Hi, I need to create some cycle or something else in SAS proc-sql which divide data into groups. I have data: ID1 ID2 TIME 1234 12 22MAY2015:16:10:00.000 1234 12 22MAY2015:16:15:00.000 1234 12 12JUN2015:6:35:00.000 1234 12 12JUN2015:16:35:00.000 6549 45 15APR2015:16:10:00.000 6549 45 18APR2015:13:15:00.000 6549 45 18APR2015:13:18:00.000 6549 12 22MAY2015:14:15:00.000 6549 12 22MAY2015:14:20:00.000 and I need create new column GROUP where will be the same id for those rows which have same ID1, same ID2 and difference between TIME is max 10 minutes. Result will be: ID1 ID2 TIME GROUP 1234 12 22MAY2015:16:10:00.000 1 1234 12 22MAY2015:16:15:00.000 1 1234 12 12JUN2015:6:35:00.000 2 1234 12 12JUN2015:16:35:00.000 3 6549 45 15APR2015:16:10:00.000 4 6549 45 18APR2015:13:15:00.000 5 6549 45 18APR2015:13:18:00.000 5 6549 12 22MAY2015:14:15:00.000 6 6549 12 22MAY2015:14:20:00.000 6 Thank you.
... View more