topic Re: Generate the output of a regression in Statistical Procedures

Generate the output of a regression

Mathis1 — Mon, 20 Apr 2020 09:24:37 GMT

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 🙂

Re: Generate the output of a regression

ed_sas_member — Mon, 20 Apr 2020 09:38:10 GMT

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,

Re: Generate the output of a regression

PaigeMiller — Mon, 20 Apr 2020 11:07:10 GMT

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

output out=want predicted=predicted_varname residual=residual_varname;