topic Re: How to Interpret Fit Diagnostic Plots for Proc Panel in SAS Forecasting and Econometrics

How to Interpret Fit Diagnostic Plots for Proc Panel

jim_wong — Thu, 19 May 2022 06:45:41 GMT

Hi Everyone,

I am a new user, currently completing panel regression analysis for a university paper. The data I am using is a sample taken from the US Panel Study of Income Dynamics (PSID), with 23 variables and ~220k observations.

When I run a simple panel model, such as below, I do not get the observation plots, and the colored set of residual plots seem incomprehensible. Is it simply a case of so many observations making the plots over-complicated? Are these plots "normal" for proc panel, and if so how do I interpret them?

Thank you for any advice.

proc panel data=data plots=ALL;
id year id;
model ARSINH_wealth = pd age male white black hispanic otherrace education income employed divorce
marriage childbirth familydeath laidoff missedwork studentloan collegedegree ARSINH_socioeconomic / pooled;
title 'Model One - Pooled (OLS) Model (negative)';
run;

This question was originally posted to 'New Users' but I was advised to post it here instead.

How to Interpret Fit Diagnostic Plots for Proc Panel

jim_wong — Wed, 18 May 2022 21:02:59 GMT

Hi Everyone,

Thank you for any advice.

proc panel data=data plots=ALL;
id year id;
model wealth = pd age male white black hispanic otherrace education income employed divorce
marriage childbirth familydeath laidoff missedwork studentloan collegedegree ARSINH_socioeconomic / pooled;
title 'Model One - Pooled (OLS) Model (negative)';
run;

Re: How to Interpret Fit Diagnostic Plots for Proc Panel

Ksharp — Thu, 19 May 2022 01:22:03 GMT

Better post it at Forecasting Forum, since proc panel is under SAS/ETS .

https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/bd-p/forecasting_econometrics

Re: How to Interpret Fit Diagnostic Plots for Proc Panel

jim_wong — Thu, 19 May 2022 06:45:20 GMT

Ok, thanks.

Re: How to Interpret Fit Diagnostic Plots for Proc Panel

Kurt_Bremser — Thu, 19 May 2022 06:49:41 GMT

When you need a post moved, call out to a Super User. We can do that for you.

I merged your posts.

Re: How to Interpret Fit Diagnostic Plots for Proc Panel

sbxkoenk — Thu, 19 May 2022 08:01:17 GMT

Hello @jim_wong ,

@SASCom1 can help you with this.

Thanks,

Koen

Re: How to Interpret Fit Diagnostic Plots for Proc Panel

acordes — Thu, 19 May 2022 08:21:05 GMT

Perhaps the visuals get more meaning if you work with a sample of the data.

You could try subsetting your data.

data want;
set data;
sample_filter=rand("integer", 1, 20);
run;

proc panel data=want plots=ALL;
where sample_filter = 1;   /* in this case you would work with a sample rate of 5% */ 
id year id;
model wealth = pd age male white black hispanic otherrace education income employed divorce
marriage childbirth familydeath laidoff missedwork studentloan collegedegree ARSINH_socioeconomic / pooled;
title 'Model One - Pooled (OLS) Model (negative)';
run;