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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.