topic Re: Can SAS do exclude/hide like JMP in SAS Programming

Can SAS do exclude/hide like JMP

leonzheng — Wed, 01 Aug 2018 18:30:20 GMT

I have to operate a DateSet like below:

Fit a 4th polynomial on some observations that satisfy conditions. Then I need to calculate residual for all observations, including the observations not satisfy conditions. In JMP I can exclude/high those obs, but in SAS I don't know how to do it, I can only delete obs and create a new table, but then the deleted obs will not have residual.

Can anyone give me advice on this?

Thanks!

Re: Can SAS do exclude/hide like JMP

PaigeMiller — Wed, 01 Aug 2018 19:16:47 GMT

Exclude means that the observation is not used in the calculation of the model fit, so you will not get a residual value for it. Yes, SAS can do this. Simply don't include the variable in the procedure that fits the plot (you can use the WHERE data set option to exclude specific rows from a data set).

Hide means that a data point is not shown on a plot. Yes, SAS can do this. When you produce the plot, use the WHERE option to not include the observations.

Re: Can SAS do exclude/hide like JMP

leonzheng — Wed, 01 Aug 2018 19:19:19 GMT

if I use WHERE and do the fit, will SAS calculate residual for me on those excluded points?

Re: Can SAS do exclude/hide like JMP

PaigeMiller — Wed, 01 Aug 2018 19:23:07 GMT

Not directly, but you can either trick SAS to do this by making the real Y variable missing to get a predicted value, or use PROC SCORE on the excluded points to generate predicted values and residuals.

Re: Can SAS do exclude/hide like JMP

leonzheng — Wed, 01 Aug 2018 19:24:40 GMT

thx, let me try