Dear Stata forum members,

I need advise on how to combine dates in 2 different columns in to one column and sort them.

I have a large data set of 40,000+ subjects. Each of them have about 6 to 10 dates of service (in one column) and date of first prescription (in another column) [similar to m:1, but same dataset]. I need to combine these dates to one column, so that I can sort them.

I very much appreciate your help.

With warm regards,
Sateesh