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]
RE: st: Right to Left Column Cascade or Adjustment
From
Nick Cox <[email protected]>
To
"'[email protected]'" <[email protected]>
Subject
RE: st: Right to Left Column Cascade or Adjustment
Date
Tue, 24 May 2011 17:38:59 +0100
There is a fairly systematic discussion in
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
There is (now) not much difference in effect between my -rowsort- and Jeff Arnold's -sortrows-; note that there is also -rowranks- as well.
Nick
[email protected]
Scott Merryman
You could use Jeffrey Arnold's -sortrows- (use -findit- to locate download).
input col1 col2 col3 col4 col5
101 101 . . .
. 111 333 . .
. . . . 935
. . . 23 16
405 .295 . .
end
l
sortrows, replace
l
On Tue, May 24, 2011 at 10:08 AM, David Torres <[email protected]> wrote:
> There's probably a proper name for the process I'd like to carry out.
>
> Say I have five columns of information with staggard cell inputs. How do I go about moving all the information in a subsequent column back through to the first column for which no information is missing on the row?
>
> I'd like to go from something like this:
>
> Col1 Col2 Col3 Col4 Col5
>
> 101 101
> 111 333
> 935
> 023 016
> 405 295
>
>
> to something like this
>
> Col1 Col2 Col3 Col4 Col5
>
> 101 101
> 111 333
> 935
> 023 016
> 405 295
>
*
* 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/