I have a data set like below. PTID new_stdt new_end P3747440 02Nov2011 29Dec2011 P3747440 03Nov2011 02Dec2011 P3747440 01Dec2011 30Dec2011 P3747440 30Dec2011 31Dec2011 I want to line up the dates .So that my new data looks like below. PTID new_stdt new_end P3747440 2-Nov-11 2-Nov-11 P3747440 3-Nov-11 30-Nov-11 P3747440 1-Dec-11 1-Dec-11 P3747440 2-Dec-11 29-Dec-11 P3747440 30-Dec-11 30-Dec-11 P3747440 31-Dec-11 31-Dec-11 How can I do this ?Any leads will be appreciated. Regards, Aninda
... View more