Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Panel Data Regression for Unbalanced Data

  • 30-11-2023 11:53AM
    #1
    krithikasharon
    Registered Users, Registered Users 2 Posts: 1 ✭


    Hi Guys,

    I have been working with panel data for my research. One of the problem I faced is that. My dataset is monthly based from 2010 to 2023. I was able to do a yearly analysis but for monthly analysis I had to create panel ID's for each month. But the problem is that my data is not balanced.

    Meaning that, I have data for around 50 firms. Some of the firms have been merged, closed or dissolved during some years between 2010-2023, this creates a dataset with only few rows for such firms. I have realized that due to panel ID's they are supposed to be a fixed or balanced data for all firm. The pooled OLS, FE or RE models do not work and I get an error every time. Is there any work around for this??

    Just a simple representation of the dataset: ( I am using Firm and Panel ID as my multi-index)

    Firm Panel ID Datetime

    A 1 02-2010

    A 2 03-2010

    A 3 04-2010

    B 1 02-2010

    B 2 03-2010

    C 1 02-2010

    C 2 03-2010

    C 3 04-2010

    Tagged:


Advertisement