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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.