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 on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: rectangulizing data


From   Oliver Jones <ojones@wiwi.uni-bielefeld.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: rectangulizing data
Date   Thu, 26 May 2011 17:52:32 +0200

Hi,
your example data structure is a bit confusing since you have month
greater than 12... I'll assume you have at most 12 Month per person
per year.

Maybe this can help to drop people how have less than 12 observations
for one particular year. Let's assume this year is 2006.

bysort ID: egen obs = count(Month)
drop if year == 2006 & obs < 12

Dose it work?

Best
Oliver

Am 26.05.2011 17:19, schrieb Dmitriy Krichevskiy:
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/

--
Universität Bielefeld
Fakultät für Wirtschaftswissenschaften
Lehrstuhl für Ökonometrie und Statistik
- -
Bielefeld University
Faculty of Business Administration and Economics
Chair of Econometrics and Statistics
- -
Raum / room:  V9-110
Tel / phone:  +49 (0)521 106 4871
---
*
*   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