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
Scott Merryman <[email protected]>
To
[email protected]
Subject
Re: st: Right to Left Column Cascade or Adjustment
Date
Tue, 24 May 2011 11:15:35 -0500
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
Scott
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
>
>
> Thanks,
> Diego
> *
> * 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/
*
* 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/