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;

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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