topic How to use BY statement along with OUTPUT in PROC GLM to save several output data sets ? in SAS Programming

How to use BY statement along with OUTPUT in PROC GLM to save several output data sets ?

stan — Fri, 29 Sep 2017 17:58:11 GMT

Dear SAS users,

I want to run PROC GLM several times on the same data set using BY statement. This works fine.

But how to save different output data sets of residuals (with OUTPUT) each time ?

Thank you.

Re: How to use BY statement along with OUTPUT in PROC GLM to save several output data sets ?

PaigeMiller — Fri, 29 Sep 2017 18:08:45 GMT

If you use a BY statement, the residuals still get written into the OUTPUT data set. Does your question mean that you want each BY group's residuals in a different data set? Generally, I would advise against doing this, as I don't see the benefit, but you can certainly take the output data set and in a following data step, split it up by the value of the BY variable (but again, I don't see any benefit to doing this).