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]
st: rectangulizing data
From
Dmitriy Krichevskiy <[email protected]>
To
statalist <[email protected]>
Subject
st: rectangulizing data
Date
Thu, 26 May 2011 11:19:11 -0400
Dear Listers,
I am trying to figure out the simplest way to covert a large panel
dataset from monthly to annual income. The income is only reported
monthly and I would want to clean the data of anyone missing a month
in a particular year. I would like to drop observations for that
person-year only and keep that person if they are fully present in
some other year. Here is an equivalent data structure. As always, that
a lot for your help.
Dmitriy
ID Month Income
1 1 1000
1 2 500
1 3 1000
1 13 0
1 14 0
1 15 0
1 16 0
1 17 600
1 18 1000
1 19 1000
1 20 1000
1 21 1000
1 22 1000
1 23 660
1 24 800
1 25 1200
2 1 2400
2 2 2400
2 5 2600
*
* 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/