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: Transform unbalanced data into cross-sectional data
From
Neesha Harnam <[email protected]>
To
[email protected]
Subject
Re: st: Transform unbalanced data into cross-sectional data
Date
Thu, 29 Sep 2011 11:17:50 -0400
Hi
I'm not too clear on your question but perhaps you could transform it
from long to wide form? If I have misinterpreted your question, I
apologize.
Best,
Neesha
On Thu, Sep 29, 2011 at 11:10 AM, Jingjing Niu <[email protected]> wrote:
> Dear List
>
> I have an unbalanced data and I want to transform it into
> cross-sectional data, because the drop out rate is high and I am
> interested in the cross-sectional comparison. This data includes 3
> waves, and new observations were added each year to maintain a
> reasonable sample size. Some individual were measured once out of the
> 3 waves, some twice and some three times. An simple example of the
> data is pasted below.
> person year income age sex
> 1 2003 1500 27 1
> 1 2004 1700 28 1
> 2 2003 2100 41 2
> 2 2004 2100 42 2
> 2 2005 2200 43 2
> 3 2004 3000 35 1
>
> Any comment or suggestion is appreciated! Thank you very much for your
> consideration!
> Jingjing Niu
> *
> * 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/