Generate the output of a regression

[Mathis1]

Hello !

I have a table with multiple categorical variables in input and a continuous variable in output. I ran a Proc glm on this table, which gives me coefficients for all the modalities. Now i'm trying to "apply" all those coefficients to my real observations and add a column "regression output" to my table that gives me the "predicted" output for every observation. So I can compare the real output and the predicted one. 

Thank you for your help 🙂

[ed_sas_member · Accepted solution]

Hi @Mathis1 

You can add the predicted option to the output statement:

proc glm data=have;
   class x1 x2 ...;
   model y = x1 x2 ... / solution;
   output out=want predicted=predicted_varname;
run;

Best,

[PaigeMiller]

Adding to the already correct solution ... you may want

output out=want predicted=predicted_varname residual=residual_varname;