Hi, I have a data set as; Id Date 1 2005 2 2008 3 2004 3 2012 4 2001 5 2016 5 2007 5 2010 I want to order the data so that it is sorted by date order, but keep the same id's together, so it would look like this; Id Date 4 2001 3 2004 3 2012 1 2005 5 2007 5 2010 5 2016 2 2008 The only way i have found to do his so far is using proc sort, but this seems to either order by date which muddles the ids, or I can sort by dates within id but this doesn't reorder the id's so that the earliest is first. Any help is really appreciated, thanks in advance 🙂
... View more