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.
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;
Have you tried the OUTEST= option on the PROC REG statement?
proc reg data=mydata OUTEST=WANT;
by id;
model height = weight;
run;
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!
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.