How to save values for predictions and residuals in my excel file using SAS STUDIO?

eltrigo21 — Sun, 16 Apr 2023 13:25:55 GMT

Hi I'm a new in SAS. First I'm practicing by SAS STUDIO to learn SAS codes.

This question might be silly, but when I used "Predictive Regression Models" in SAS STUDIO, I was practicing several options, and I found several values for rediction and residual was automatically saved in my Excel file (next to my original data colum) like below.

Then when I closed the program, and went back to Predictive Regression Models, I can't find and save the above data. I remember all those values (pred, MPred, resid, MResid, etc.,) was saved to Excel file.

1) Could you tell me how can I obtain these values in SAS Studio?

2) What concept is about these values? Is it about Predictive Regression Models, or other concepts? If you tell me the basic concept, I would be able to find and study more.

Many thanks!!

Re: How to save values for predictions and residuals in my excel file using SAS STUDIO?

JOL — Tue, 13 Jun 2023 18:40:19 GMT

You probably saved the scored data as a data set then exported to Excel.

SAS Studio does no create Excel tables automatically.

Right-Click on table in Library to Export

Go to INFORMATION tab for more resources on Predictive Regression Models

topic Re: How to save values for predictions and residuals in my excel file using SAS STUDIO? in SAS Studio

How to save values for predictions and residuals in my excel file using SAS STUDIO?

Re: How to save values for predictions and residuals in my excel file using SAS STUDIO?