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!!
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
Post your log from regression.
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
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
I removed the plots statement and it worked perfectly, thanks!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.