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