Statalist


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

Re: st: How to balance an unbalanced panel data set


From   Philipp Rehm <philipp.rehm@gmx.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: How to balance an unbalanced panel data set
Date   Thu, 02 Apr 2009 18:28:03 -0300

.
How about -tsfill-?
In particular: -tsfill, full-

Ph

Christian Bustamante wrote:
That's solve the problem if the data set has all years for all panels,
but it isn't. The data set is about firm's financial information, thus
the firms that not reported information before 2000 (for example)
doen't have a time period associated to it's id. The same occur with
firms that have information since the begining of panel, but in 2003
there isn't data an then a row with 2003 in the year variable for this
firm and missing in all other values.

I supose that it would be solved creating this "years" with missing
data for all firms that hasn't information in this period, but I don't
know how to do that.

Thanks


On Thu, Apr 2, 2009 at 4:09 PM, Philipp Rehm <philipp.rehm@gmx.de> wrote:
.
Nick Cox's -dropmiss- may be useful. You may want to check out -findit
dropmiss-

It seems your panel data-set is in wide format. For most purposes, that's
very inconvenient, at best. You may want to -reshape- your data-set to long
format.

HTH,
Philipp

Christian Bustamante wrote:
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 <philipp.rehm@gmx.de> 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/



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



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index