<>
So the end result is that you end up with only panel 4? If you throw out
observations due to missingness beforehand, that is the inevitable
conclusion...
*************
clear*
inp year id var1
1998 1 .
1999 1 .
2000 1 34
2001 1 23
2002 1 25
1998 2 56
1999 2 45
2000 2 67
2001 2 47
2002 2 .
1998 3 11
1999 3 13
2000 3 .
2001 3 .
2002 3 23
1998 4 44
1999 4 24
2000 4 33
2001 4 36
2002 4 41
1999 5 24
2000 5 35
2002 5 45
end
drop if mi(var1)
tempvar length
bys id (year): gen `length'=_N
su `length', mean
bys id: drop if `length'!=r(max)
*************
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Christian
Bustamante
Gesendet: Freitag, 3. April 2009 04:15
An: [email protected]
Betreff: Re: st: How to balance an unbalanced panel data set
Hi Martin
This is a better example:
---------------
| year id var1|
|---------------|
| 1998 01 . |
| 1999 01 . |
| 2000 01 34 |
| 2001 01 23 |
| 2002 01 25 |
|---------------|
| 1998 02 56 |
| 1999 02 45 |
| 2000 02 67 |
| 2001 02 47 |
| 2002 02 . |
|---------------|
| 1998 03 11 |
| 1999 03 13 |
| 2000 03 . |
| 2001 03 . |
| 2002 03 23 |
|---------------|
| 1998 04 44 |
| 1999 04 24 |
| 2000 04 33 |
| 2001 04 36 |
| 2002 04 41 |
|---------------|
| 1999 05 24 |
| 2000 05 35 |
| 2002 05 45 |
|---------------|
In this example I only want the panel with id 04 with data in all the
years, and drop the panels 01, 02 and 03 with a missing value in at
least one year for var1. I also want to drop the panel 05 with doesn't
have values in all years.
On Thu, Apr 2, 2009 at 4:37 PM, Martin Weiss <[email protected]>
wrote:
<>
You ought to give a much clearer excerpt of your data.
If it is really as simple as the one below, use -egen myrowmiss,
rowmiss()-
and you can easily drop depending on whether the row has any missings by
-drop if myrowmiss >0 & !mi(myrowmiss)-.
HTH
Martin
_______________________
----- Original Message ----- From: "Christian Bustamante"
<[email protected]>
To: <[email protected]>
Sent: Thursday, April 02, 2009 10:50 PM
Subject: Re: st: How to balance an unbalanced panel data set
Hi and thanks for your response. That's not what I'm looking for. I
will be more explicit.
Supose the folliwing data set with each row represents a panel
observations for a variable:
1 2 3 4 5 6 7 8
. . 3 4 5 6 7 8
1 2 3 . 5 6 7 8
1 2 3 4 5 6 7 .
1 2 3 4 5 . . .
I want to keep only the observations like the first one and drop the
others.
Bests
On Thu, Apr 2, 2009 at 3:31 PM, Philipp Rehm <[email protected]>
wrote:
.
http://www.stata.com/support/faqs/data/panel.html
HTH,
Philipp
Christian Bustamante wrote:
Hi Statalisters,
I have a very unbalanced panel data set, composed for a lot of panel
and 12 years. I'm interested in "balance" this panel, keeping only
the
panel tha have information for a set of variables in all the period.
How can I do that?
Thanks
*
* 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/
--
CdeB
*
* 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/
--
CdeB
*
* 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/
