Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: foreach question
From
Nick Cox <[email protected]>
To
"'[email protected]'" <[email protected]>
Subject
st: RE: foreach question
Date
Mon, 23 Aug 2010 12:44:17 +0100
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
[email protected]
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/