Undated or dated panel regression?
Posted: Tue Apr 19, 2016 9:17 am
Hi everyone,
I'm really new to EViews (9.5) and I hope you can help me to figure out which test would be best to use.
I'm not sure if it is best to perform an OLS regression or to use an undated or dated panel regression.
My sample consists out of 1000 acquisitions between 2005 and 2010. Around half of the sample only did one acquisition in this time frame, where the other half did more than one acquisitions. My dependent variable is the acquiring companies dividends in t=0, where I have around 5 independent/control variables.
In the first column I numbered all the acquisitions from 1 to 1000, and in the second column I gave the firm's firmid's (around 600 different firm's), the third column includes the year of the acquisition, and the following columns the dependent and independent variables.
I would think that a dated panel would be best for my study. In step 3 I fill in the firmid as cross section ID series, and the year as date series, however then I get the following error: Repeated values found in source id series.
When I select the acquisition number as cross section ID series, I get another error: Illegal panel structure DATEID is nested within ACQUISITION.
Could somebody please explain me what these errors mean, and maybe give me tips on what would be the best regression to do in my case.
Thank you so much for taking the time to read this!
Kind regards,
Amy
I'm really new to EViews (9.5) and I hope you can help me to figure out which test would be best to use.
I'm not sure if it is best to perform an OLS regression or to use an undated or dated panel regression.
My sample consists out of 1000 acquisitions between 2005 and 2010. Around half of the sample only did one acquisition in this time frame, where the other half did more than one acquisitions. My dependent variable is the acquiring companies dividends in t=0, where I have around 5 independent/control variables.
In the first column I numbered all the acquisitions from 1 to 1000, and in the second column I gave the firm's firmid's (around 600 different firm's), the third column includes the year of the acquisition, and the following columns the dependent and independent variables.
I would think that a dated panel would be best for my study. In step 3 I fill in the firmid as cross section ID series, and the year as date series, however then I get the following error: Repeated values found in source id series.
When I select the acquisition number as cross section ID series, I get another error: Illegal panel structure DATEID is nested within ACQUISITION.
Could somebody please explain me what these errors mean, and maybe give me tips on what would be the best regression to do in my case.
Thank you so much for taking the time to read this!
Kind regards,
Amy