topic Re: How to get regression results out? in SAS Procedures

How to get regression results out?

deleted_user — Sat, 21 Jun 2008 20:21:51 GMT

I am now running regression using proc reg function. My data set is a panel dataset. It contains 16 years data and for each year, it has thousands of observations. What I want to do is to run regression by each year first and after I get all the regression results out (16 groups of coefficients), I need to get the average of all the coefficients and R-squares. Now by the following statement, I am able to get the average of all the coefficients, but I am not able to get the average of R-squares. Is it possible to get averaged R-squares? Could anyone help me with it? Thanks very much.

ods listing close;
ods output parameterestimates=pe;
proc reg data=dset;
by year;
model depvar = indvars; run;
quit;
ods listing;

proc means data=pe mean std t probt;
var estimate; class variable;
run; Message was edited by: GingerLee

Re: How to get regression results out?

Olivier — Mon, 23 Jun 2008 07:35:48 GMT

Hi.
You should create a second dataset containing R-squares.
[pre]
ods output parameterestimates=pe fitStatistics=fs ;
[/pre]
And then process it in the same way as you did with the coefficients.
Regards.
Olivier

Re: How to get regression results out?

deleted_user — Mon, 23 Jun 2008 16:42:35 GMT

Thanks very much, Olivier. I followed what you told me and got the results.

Best,

gingerLee