topic Re: PROC REG by group output help in ODS and Base Reporting

PROC REG by group output help

pwang33 — Fri, 04 Dec 2015 16:30:07 GMT

Hi, I am having trouble making a output table for my regression.

My dataset would look like

id height weight

1 100 200

2 200 300

3 100 400

1 200 300

2 100 130

3 200 400

If I run the regression

proc reg data=mydata; by id; model height = weight; run;

It will generate a report for each id group. I am only interested in parameter estimates table. How can I bring different groups of parameter estimate tables into one table? Thank you.

Re: PROC REG by group output help

Reeza — Fri, 04 Dec 2015 16:31:39 GMT

Have you tried the OUTEST= option on the PROC REG statement?

proc reg data=mydata OUTEST=WANT; 
by id; 
model height = weight; 
run;

Re: PROC REG by group output help

pwang33 — Fri, 04 Dec 2015 16:49:06 GMT

Hi Reeza, thank you for the quick reply.

This is a super silly question, but OUTEST option does not report me with t value. How can I add it into the WANT table?

Thank you!

Re: PROC REG by group output help

Reeza — Fri, 04 Dec 2015 16:53:14 GMT

You can look at the options under proc reg to add different statistics/values to the dataset, in this case TABLEOUT.

You can also, use the ODS table instead (ODS OUTPUT).

proc sort data=sashelp.class out=class;
by sex;
run;

proc reg data=class outest=want tableout;
by sex;
model height=weight age;
ods output parameterestimates=want2;
run;

proc print data=want;
run;
proc print data=want2;
run;