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;
Use the OUTEST=EST, TABLEOUT, and EDF options, as documented in the syntax for the PROC REG statement:
proc print data=EST;
where _TYPE_="PARMS" | _TYPE_="T";
var _MODEL_ _TYPE_ Intercept X1 X2 X3 _RSQ_;
run;
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.
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.