st: RE: foreach question

[Nick Cox <n.j.cox@durham.ac.uk>]

This sparked a thread to which Eric Booth, Scott Merryman and Martin Weiss contributed. 

I concur with the view that -reshape long- is often the best advice. 

That said, one program mentioned was -sortrows- from Jeffrey Arnold at SSC. 

The help of -sortrows- refers to a program of the same name by myself, but there is no such program. That is a slip for my -rowsort-. For a broader review of working row-wise, see 

SJ-9-1  pr0046  . . . . . . . . . . . . . . . . . . .  Speaking Stata: Rowwise
        (help rowsort, rowranks if installed) . . . . . . . . . . .  N. J. Cox
        Q1/09   SJ 9(1):137--157
        shows how to exploit functions, egen functions, and Mata
        for working rowwise; rowsort and rowranks are introduced

Nick 
n.j.cox@durham.ac.uk 

David Diego Torres

Is there a way to sort or reorder dates using the foreach  
command--perhaps using the egen function in the loop or something?

How do I get:

Date1          Date2         Date3         Date4

23July1997    01Jan1997     12Sept1997     03Feb1997

to be ordered thusly:

Date1          Date2         Date3         Date4
01Jan1997     03Feb1997     23July1997     12Sept1997


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/