The SAS Output Delivery System and reporting techniques

PROC REG by group output help

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

PROC REG by group output help

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.

 

 


Accepted Solutions
Solution
‎12-04-2015 03:11 PM
Grand Advisor
Posts: 17,338

Re: PROC REG by group output help

[ Edited ]

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;

 

View solution in original post


All Replies
Grand Advisor
Posts: 17,338

Re: PROC REG by group output help

[ Edited ]

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

proc reg data=mydata OUTEST=WANT; 
by id; 
model height = weight; 
run;
New Contributor
Posts: 2

Re: PROC REG by group output help

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! 

Solution
‎12-04-2015 03:11 PM
Grand Advisor
Posts: 17,338

Re: PROC REG by group output help

[ Edited ]

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;

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 496 views
  • 0 likes
  • 2 in conversation