topic Re: proc reg output option not creating new dataset in SAS Procedures

proc reg output option not creating new dataset

arigarza — Fri, 30 Sep 2016 04:01:47 GMT

Hello all!

I'm trying to perform a proc reg procedure and add an output dataset with residuals, predicted values, confidence intervals etc,

Here is my code:

ods graphics on;
title "Preliminary Regression model on Systolic Blood Pressure data";
proc reg data=work.assignment42 plots=predictions(X=AGE smooth);
model SYSBP=AGE/clb clm;
plot SYSBP*AGE;
output out=new3 predicted=pred residual=resid lclm=lowerbndm uclm=upperbndm;
run;
ods graphics off;
quit;

after I run this program, the regression is performed and i get all the parameters/plots, etc... however my new dataset is not created, I get an error message saying: "the table "work.new3" cannot be opened because it does not contain any colums"

Any idea why this might be?

Thanks!!

Re: proc reg output option not creating new dataset

Reeza — Fri, 30 Sep 2016 04:14:31 GMT

Post your log from regression.

Re: proc reg output option not creating new dataset

arigarza — Fri, 30 Sep 2016 05:01:24 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

NOTE: ODS statements in the SAS Studio environment may disable some output features.

57 ods graphics on;

58 title "Preliminary Regression model on Systolic Blood Pressure data";

59 proc reg data=work.assignment42 plots=predictions(X=AGE smooth);

60 model SYSBP=AGE/clb clm;

61 plot SYSBP*AGE;

62 output out=new3 predicted=pred residual=resid lclm=lowerbndm uclm=upperbndm;

63 run;

ERROR: Appendage SASXGANO not found, unable to produce graphics.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.NEW3 may be incomplete. When this step was stopped there were 0 observations and 0 variables.

WARNING: Data set WORK.NEW3 was not replaced because this step was stopped.

NOTE: PROCEDURE REG used (Total process time):

real time 3.39 seconds

cpu time 1.88 seconds

64 ods graphics off;

65 quit;

67 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: proc reg output option not creating new dataset

Reeza — Fri, 30 Sep 2016 05:37:53 GMT

The log clearly indicates an issue.

Note the error message.

Are you using SAS UE?

If so, the PLOT statement is not supported in this edition as it requires the SAS GRAPH license which is not included.

Workarounds are indicated here:

https://communities.sas.com/t5/SAS-Analytics-U/Appendage-SASXGANO-not-found/td-p/145480

Re: proc reg output option not creating new dataset

arigarza — Fri, 30 Sep 2016 14:00:54 GMT

I removed the plots statement and it worked perfectly, thanks!