BookmarkSubscribeRSS Feed
uvachick
Calcite | Level 5

I need assistance organizing my regression data when using PROC REG. I basically want to organize outputs for 6 regressions into one table showing the coefficients, the T Statistic and the R Square. I tried using ODS OUTPUT ParameterEstimates but I was only able to retrieve the coefficient and the T statistic (see below).  I also tried ODS OUTPUT FitStatistics but that only shows the r squared data.  What else can I do to organize my data?

proc reg data  = master;

model fcinv = unrate homeprice;

model fcinv = unrate homeprice jud;

model fcinv=unrate homeprice nonjud;

model fcinv = unrate homeprice nonjud emp;

model fcinv = unrate homeprice nonjud unemp;

model fcinv= unrate homeprice nonjud hpi;

run;

ods output close;

proc print data = a;

run;

proc tabulate data = a;

class model variable;

var estimate tvalue;

table variable =  ' ' *(estimate  = ' ' *sum = ' '

                              tvalue = ' ' * sum = ' '),

model = ' '

/box = [label = "Parameter"] rts=15 row = float misstext = ' ' ;

run;

1 REPLY 1
Rick_SAS
SAS Super FREQ

Use the OUTEST=EST, TABLEOUT, and EDF options, as documented in the syntax for the PROC REG statement:

http://support.sas.com/documentation/cdl/en/statug/63962/HTML/default/viewer.htm#statug_reg_sect007....

proc print data=EST;

where _TYPE_="PARMS" | _TYPE_="T";

var _MODEL_ _TYPE_ Intercept X1 X2 X3 _RSQ_;

run;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1076 views
  • 0 likes
  • 2 in conversation