Programming the statistical procedures from SAS

How to get R-square for individual time-series group

Reply
Occasional Contributor
Posts: 10

How to get R-square for individual time-series group

Hi! I am running a time series model with multiple firms with multiple years of observation (more than 10,000 observations). I want to get R-squares for  individual firms. I know that r-square will show up in the individual firms' output report.But I don't know how to obtain a data file includes both firm_id and also R-square for each firm. Any suggestion will be appreciated.

The following is my SAS data and code information.

my basic code is

PROC AUTOREG DATA=TS;

by firm_id;

MODEL price=bps;

OUTPUT OUT=OUT1;

RUN;

Original data sample:

image.png

Respected Advisor
Posts: 2,655

Re: How to get R-square for individual time-series group

Try using ODS to get a dataset with the R squared values:

PROC AUTOREG DATA=TS;

by firm_id;

MODEL price=bps;

OUTPUT OUT=OUT1;

ods output fitstatistics=fitstatistics;

RUN;

This will generate a dataset in your WORK library with the regression R squared values for each BY variable.

Steve Denham

Ask a Question
Discussion stats
  • 1 reply
  • 254 views
  • 0 likes
  • 2 in conversation