Desktop productivity for business analysts and programmers

Regression numbers on SGPLOT

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Regression numbers on SGPLOT

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
Solution
‎07-10-2018 01:53 PM
Super User
Posts: 23,937

Re: Regression numbers on SGPLOT

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;

 

 

View solution in original post


All Replies
Solution
‎07-10-2018 01:53 PM
Super User
Posts: 23,937

Re: Regression numbers on SGPLOT

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;

 

 

PROC Star
Posts: 1,332

Re: Regression numbers on SGPLOT

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/

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 85 views
  • 0 likes
  • 3 in conversation