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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 636 views
  • 0 likes
  • 2 in conversation