Is it possible to produce residuals of a regression model source dataset in SAS

[Reeza · Accepted solution]

The dataset should exist in your work library, you now have the name. You should be able to use it as any other table.

[FeliciaFung]

Thanks so much

[Urban_Science]

I'm sorry to chime in after this thread has been marked as "Solved!", but the easiest way to use the residuals from a regression model as the target of another model is to:

1. Connect a Metadata node after the regression node.  

2. Click on "..." In the Train Property value

3. Find the column that has Role = "Target" and change New Role to "Rejected"

4. Find the column that has Role = "Residual" and change New Role to "Target" (This column should also start with R_ like Reeza said)

5. Click "OK" (in the lower right corner of the window)

Any nodes after the Metadata node will now use that residual column as the target variable.

Attached is an example picture of the options.

[Reeza]

Thanks for chiming in, always best to know the most efficient way to do something. I don't have access to EM anymore so most answers are off memory or documentation.