Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Transform unbalanced data into cross-sectional data


From   Jingjing Niu <jingj.niu@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Transform unbalanced data into cross-sectional data
Date   Thu, 29 Sep 2011 11:10:22 -0400

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index