I have a SGPLOT and I would like to include some regression info on the SGPLOT. I have seen some examples online that include slope R-squared or RMSE. I have a code for SGPLOT and REG separately but I don't know how to display info from PROC REG on the SGPLOT.
Here's what I have:
proc sgplot data=have; where Month in (6,7,8) and Weekday in (1,2,3,4,5) and hour in (4, 17); scatter x=Temperature y=Load / group=hour; title '5 P.M. vs 4 A.M. Load vs Temperature(summer)'; run;
proc reg data=have; where Month in (6,7,8); where also Hour in (4); where also Weekday in (1,2,3,4,5); model Load = Temperature; title 'Weekday Regression at 4 AM'; run;
Extract them to a data set, add them to your master data set and use MARKER or TEXT to plot them on the graph.
https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html
If you search on here I'm 99% sure there are examples.
@matt23 wrote:
I have a SGPLOT and I would like to include some regression info on the SGPLOT. I have seen some examples online that include slope R-squared or RMSE. I have a code for SGPLOT and REG separately but I don't know how to display info from PROC REG on the SGPLOT.
Here's what I have:
proc sgplot data=have; where Month in (6,7,8) and Weekday in (1,2,3,4,5) and hour in (4, 17); scatter x=Temperature y=Load / group=hour; title '5 P.M. vs 4 A.M. Load vs Temperature(summer)'; run;proc reg data=have; where Month in (6,7,8); where also Hour in (4); where also Weekday in (1,2,3,4,5); model Load = Temperature; title 'Weekday Regression at 4 AM'; run;
Extract them to a data set, add them to your master data set and use MARKER or TEXT to plot them on the graph.
https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html
If you search on here I'm 99% sure there are examples.
@matt23 wrote:
I have a SGPLOT and I would like to include some regression info on the SGPLOT. I have seen some examples online that include slope R-squared or RMSE. I have a code for SGPLOT and REG separately but I don't know how to display info from PROC REG on the SGPLOT.
Here's what I have:
proc sgplot data=have; where Month in (6,7,8) and Weekday in (1,2,3,4,5) and hour in (4, 17); scatter x=Temperature y=Load / group=hour; title '5 P.M. vs 4 A.M. Load vs Temperature(summer)'; run;proc reg data=have; where Month in (6,7,8); where also Hour in (4); where also Weekday in (1,2,3,4,5); model Load = Temperature; title 'Weekday Regression at 4 AM'; run;
Here's a link to a bunch of SAS suggestions for people using regression; you might find them useful.
Take a look at Number 26 in terms of your question.
Tom
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.