Regression numbers on SGPLOT

[matt23]

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;

[Reeza · Accepted solution]

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;

---

[TomKari]

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

http://iainpardoe.com/arm2e/sas-code/