- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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