I ran into a challenge, hope experts can advise. In a data set, we have case IDs (1, 2, etc), and the next column is dates of accident: 1.00 06/04/2008 1.00 06/08/2008 2.00 06/14/2008 3.00 08/23/2008 3.00 08/23/2008 4.00 08/23/2008 Here, if the date is the same withing the same ID, it is the same accident. So for ID=3, it will be the same accident, just 2 records for different aspects of the accident. We need to assign a number to each unique accident. So for ID=1, it will be 1 and 2. For ID=2, will be 1. For ID=3, 1 and 2. And for ID=4, 1. The issue is that when I use a rank function to rank dates by ID, the result is weird. For some cases, the rank is 11.5, 23.5 etc. Is there a way to make it work so that for each case ID it will rank order just the dates within that ID?
... View more