Re: st: Right to Left Column Cascade or Adjustment

[David Torres <torresd@umich.edu>]

Thanks.
--
David Diego Torres, MA(Sociology)
PhD Candidate in Sociology

2044 Population Studies Center
University of Michigan Institute for Social Research
Ann Arbor MI  48106-1248
Tel 734.763.4098
Fax 734.763.1428
torresd at umich dot edu


Quoting Scott Merryman <scott.merryman@gmail.com>:

> 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 <torresd@umich.edu> 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/

*
*   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/