PROC REG by group output help

[pwang33]

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.

[Reeza]

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

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

[pwang33]

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! 

[Reeza · Accepted solution]

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;