https://communities.sas.com/t5/Statistical-Procedures/predicted-and-observed-values-in-one-dataset/m-p/669614#M31976 <P>The output from the OUTPUT statement in PROC GLM will contain the actual Y value, the predicted value and the residual value, if you use the proper options. P=PRED is the option that produces predicted values, R=RESID is the option that produces residual values.</P> Wed, 15 Jul 2020 17:39:49 GMT PaigeMiller 2020-07-15T17:39:49Z https://communities.sas.com/t5/Statistical-Procedures/predicted-and-observed-values-in-one-dataset/m-p/669611#M31975 <P>I have a regression model that I fitted with proc glm. I want to have both observed and predicted values of my response variable. Then I want to group each into 100 groups (by rank) and find AVERAGE and STD per group for each column:</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YRank&nbsp; &nbsp; &nbsp; &nbsp;Yhat&nbsp; &nbsp; &nbsp; &nbsp; YhatRank</P> <P>&nbsp; &nbsp; &nbsp;23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P> <P>&nbsp; &nbsp; &nbsp;22.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P> <P>&nbsp; &nbsp; &nbsp;15.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P> <P>&nbsp; &nbsp; &nbsp;11.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P> <P>&nbsp; &nbsp; &nbsp; 8.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P> <P>&nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...</P> <P>&nbsp;</P> <P>So then:</P> <P>&nbsp;</P> <P>group&nbsp; &nbsp; &nbsp;avg_Y&nbsp; &nbsp; &nbsp;std_Y&nbsp; &nbsp; &nbsp;avg_Yhat&nbsp; &nbsp; &nbsp;std_Yhat</P> <P>&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.1</P> <P>&nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.9</P> <P>&nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...</P> <P>&nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...</P> <P>&nbsp;</P> <P>Your help would be greatly appreciated!</P> Wed, 15 Jul 2020 17:45:45 GMT https://communities.sas.com/t5/Statistical-Procedures/predicted-and-observed-values-in-one-dataset/m-p/669611#M31975 mh2t 2020-07-15T17:45:45Z https://communities.sas.com/t5/Statistical-Procedures/predicted-and-observed-values-in-one-dataset/m-p/669614#M31976 <P>The output from the OUTPUT statement in PROC GLM will contain the actual Y value, the predicted value and the residual value, if you use the proper options. P=PRED is the option that produces predicted values, R=RESID is the option that produces residual values.</P> Wed, 15 Jul 2020 17:39:49 GMT https://communities.sas.com/t5/Statistical-Procedures/predicted-and-observed-values-in-one-dataset/m-p/669614#M31976 PaigeMiller 2020-07-15T17:39:49Z https://communities.sas.com/t5/Statistical-Procedures/predicted-and-observed-values-in-one-dataset/m-p/669616#M31977 Did you check the OUTPUT statement in PROC GLM? There's examples towards the bottom and then run a PROC MEANS on your output data set.<BR /><BR /><A href="https://documentation.sas.com/?docsetId=statug&amp;docsetTarget=statug_glm_syntax17.htm&amp;docsetVersion=15.1&amp;locale=en" target="_blank">https://documentation.sas.com/?docsetId=statug&amp;docsetTarget=statug_glm_syntax17.htm&amp;docsetVersion=15.1&amp;locale=en</A> Wed, 15 Jul 2020 17:39:52 GMT https://communities.sas.com/t5/Statistical-Procedures/predicted-and-observed-values-in-one-dataset/m-p/669616#M31977 Reeza 2020-07-15T17:39:52Z