Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Thomas, Anthony" <anthony_h_thomas@brown.edu> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: "stacking" a variable ? |
Date | Mon, 2 Dec 2013 11:28:28 -0500 |
Hi Nick, You can try using Stata's subscript notation "_n": replace q2 = q1[4] if _n == 1 replace q2 = q1[5] if _n == 2 *** where 4 and 5 are the observation number of what you want to move in q1 and so on. Of course it would be smarter to implement this in a loop if possible. Hope that helps, Anthony On Mon, Dec 2, 2013 at 11:03 AM, Nick Bornschein <nick.bornschein@gmail.com> wrote: > Hello, > > after some problems with my data, I have a final question to deal with them. Imagine the following example: > > clear > input q1 q2 > 2.05 . > 3.01 . > 0.75 . > . 1.99 > . 1.86 > . 0.44 > end > > How do I "move" column q2 upwards, so that finally 1.99 is in the same line as 2.05 in the first row, 1.86 is besides 3.01 and so on. > > Thanks a lot > -Nick > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/