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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.