Help using Base SAS procedures

proc reg output option not creating new dataset

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

proc reg output option not creating new dataset

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!!


Accepted Solutions
Solution
‎09-30-2016 10:01 AM
Super User
Posts: 19,815

Re: proc reg output option not creating new dataset

[ Edited ]

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

 

View solution in original post


All Replies
Super User
Posts: 19,815

Re: proc reg output option not creating new dataset

Post your log from regression. 

New Contributor
Posts: 3

Re: proc reg output option not creating new dataset

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

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

56         

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;

66         

67         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

79         

Solution
‎09-30-2016 10:01 AM
Super User
Posts: 19,815

Re: proc reg output option not creating new dataset

[ Edited ]

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

 

New Contributor
Posts: 3

Re: proc reg output option not creating new dataset

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 542 views
  • 0 likes
  • 2 in conversation