BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mscherst
Calcite | Level 5

Hi,

I'm doing a replication of an empirical paper examining the effects of bus transit on various economic measures.  I have panel data for about 80 counties over 16 years, and for this particular model I'm regressing the unemployment rate against operating expenses of the bus systems.  There are many missing values, which makes this data unbalanced, and I am aware that this is problematic for some measures of autocorrelation.  What I'm more concerned about is just making sure I understand the process, rather than necessarily getting correct values.

Working with non-panel time series data, I know how to use AUTOREG to find a Durbin-Watson score for the original model, and then set a lag time to correct, then get a new DW score reflecting the corrected model.  So maybe the uncorrected model gives DW=.3, then corrected shows DW=2 (approximately).

Now, I'm not sure exactly how to implement this in PROC PANEL.  I have run the following code:

proc panel data=full plots=none;

  id county_id year;

  model unemployment_rate = real_oe_percap/ dw;

  model unemployment_rate = real_oe_percap/ FIXONE dw;

  model unemployment_rate = real_oe_percap/ FIXONE hccme=4 dw;

  model unemployment_rate = real_oe_percap/ FIXONE hac dw;

run;

A note: the DW score in PANEL is experimental, and didn't even seem to be available in SAS Studio until after I spoke to customer service today.  However, I've done this with non-experimental tests and gotten the same results, so I think I still have some kind of a problem.

The first model defaults to random effects, which I don't want, but am including for debugging purposes. The next three use a fixed effects model, with what I intend to be corrections for autocorrelation in the last two.  So here's the thing:  the three FixOne models give identical results for fit statistics and parameter estimates, with the last two having a slightly different standard errors from the second.  However, all four of them have identical DW scores of .44, which suggests positive autocorrelation.  Am I implementing these incorrectly?  Shouldn't I be able to perform a correction as in AUTOREG that will result in a DW score closer to 2?

Also, I have performed a test for heteroskedasticity as follows:

proc model data=full plots=none;

      parms a1 b1;

      unemployment_rate = a1 + b1 * real_oe_percap;

      fit unemployment_rate / white;

      title 'Test for Heteroskedasticity';

   run;

This gives me a score for White's Test, indicating heteroskedasticity in the basic model, which I am attempting to correct for here.  How can I tell if I have successfully corrected for that?  PROC PANEL doesn't take white as an option.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
gergely_batho
SAS Employee

Hi,

To solve the AR issue look at this example, how to include lagged variables in proc panel:

SAS/ETS(R) 13.2 User's Guide

Hope this helps.

View solution in original post

4 REPLIES 4
BeverlyBrown
Community Manager

Hi , I moved your inquiry over to the SAS Statistical Procedures Community, whose experts can help you.

Register now for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

SteveDenham
Jade | Level 19

Mike, you need to cross post this again into the SAS Forecasting and Econometrics Community, where the ETS procedures are routinely addressed.  Look for responses from , , , and , and do a search on their responses that are already posted.

Steve Denham

BeverlyBrown
Community Manager

Per your advice, Steve, I've moved Mike's inquiry to the SAS Forecasting and Econometrics Community. Grateful for your help in here!

Register now for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

gergely_batho
SAS Employee

Hi,

To solve the AR issue look at this example, how to include lagged variables in proc panel:

SAS/ETS(R) 13.2 User's Guide

Hope this helps.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 4416 views
  • 0 likes
  • 4 in conversation