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: RE: Transform unbalanced data into cross-sectional data


From   Nick Cox <n.j.cox@durham.ac.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Transform unbalanced data into cross-sectional data
Date   Thu, 29 Sep 2011 16:44:46 +0100

It is not clearly that any change is needed. You just treat your data differently. Thus 

regress income age 

pools data. Of course, you might want to allow in some way for persons as clusters. 

Nick 
n.j.cox@durham.ac.uk 

Jingjing Niu

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


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