Hi all, I have data in the following format (some has dates missing): ID Date 1 Date 2 Date 3 1201 11/29/2007 11/1/2007 11/1/2007 1220 6/1/2002 1230 8/1/2002 8/1/2002 8/1/2002 1230 4/1/2000 4/1/2000 4/1/2000 1237 7/1/2003 7/1/2003 7/1/2003 I want to do the following: If one ID has more than one date i's (for i = 1,2,3), I want to keep only the earlier date. ID Date 1 Date 2 Date 3 1201 11/29/2007 11/1/2007 11/1/2007 1220 6/1/2002 1230 4/1/2000 4/1/2000 4/1/2000 1237 7/1/2003 7/1/2003 7/1/2003 How can I do this? Thanks, Chris
... View more