topic Re: Regression numbers on SGPLOT in SAS Enterprise Guide

Regression numbers on SGPLOT

matt23 — Tue, 10 Jul 2018 15:34:14 GMT

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;

Re: Regression numbers on SGPLOT

Reeza — Tue, 10 Jul 2018 15:46:12 GMT

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;

Re: Regression numbers on SGPLOT

TomKari — Tue, 10 Jul 2018 20:09:51 GMT

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/