Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: foreach question

From   Nick Cox <>
To   "''" <>
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


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:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index