Data visualization with SAS programming

Organizing PROC REG Data

Reply
N/A
Posts: 1

Organizing PROC REG Data

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;

SAS Super FREQ
Posts: 3,225

Re: Organizing PROC REG Data

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;

Post a Question
Discussion Stats
  • 1 reply
  • 122 views
  • 0 likes
  • 2 in conversation