topic Re: Saving Residuals in Proc Mixed in ODS and Base Reporting

Saving Residuals in Proc Mixed

deleted_user — Wed, 16 Sep 2009 20:19:52 GMT

Hi all,

I am using proc mixed to analyse multilevel data. For a simple example

data survey;
input group id money satisfaction;
datalines;
1 1 5 3
1 2 4 2
1 3 9 4
2 1 2 6
2 2 5 4
2 3 7 4
;

proc mixed data=survey covtest noclprint noitprint noinfo; class Group;
model satisfaction = money/ DDFM=bw solution CL; Random intercept/ sub=group;
run;

When I use ods listing to see what output I can get, there were only "covariance parameter estimates", "fit statistics", and "solution for fixed effects". However, I am interested in the residuals at both levels of analysis (group-level and individual-level).

How can I save those?

Thank you very much for your help!

sliu

Re: Saving Residuals in Proc Mixed

sfleming — Thu, 17 Sep 2009 19:11:00 GMT

You can add options to get the residuals.

To the MODEL statement add the RESIDUAL and OUTP= options to create a SAS dataset with the residuals for each individual.

To the RANDOM statement add the SOLUTION option. This will print a table of the random effects for each group which you can capture with ODS. The ODS name for the table is SOLUTIONR

proc mixed data=survey covtest noclprint noitprint noinfo;
class Group;
model satisfaction = money/ DDFM=bw solution CL residual outp=predresid;
Random intercept/ sub=group solution;
run;

Re: Saving Residuals in Proc Mixed

deleted_user — Fri, 18 Sep 2009 14:45:23 GMT

It works! Thanks a lot!

sliu

Re: Saving Residuals in Proc Mixed

daaesteban — Wed, 03 Aug 2022 19:37:01 GMT

How can I view the residual table generated?