topic Re: Regression with set interval for x-value in SAS Enterprise Guide

Regression with set interval for x-value

matt23 — Wed, 27 Jun 2018 15:21:43 GMT

How can I edit my code to create regression model for where the temperature is between 60-70 degrees.

I have this so far:

proc reg data=matt (where=(Month in(6,7,8)));
model Load=Temperature;
label Load="Load (MW)" Temperature="Temperature (degrees F)";
title 'Load vs Temperature (Summer)';
run;

Re: Regression with set interval for x-value

Haris — Wed, 27 Jun 2018 16:16:32 GMT

proc reg data=matt (where=(Month in(6,7,8) AND Temperature between 60 and 70));
model Load=Temperature;
label Load="Load (MW)" Temperature="Temperature (degrees F)";
title 'Load vs Temperature (Summer)';
run;

Re: Regression with set interval for x-value

matt23 — Wed, 27 Jun 2018 17:46:02 GMT

Can you tell me why this does not work? I added new condition

proc reg data=matt (where=(Month in(6,7,8))) AND (where=(Weekday in(1,2,3,4,5)));
model Load=Temperature;
by Hour;
label Load="Load (MW)" Temperature="Temperature (degrees F)";
title 'Load vs Temperature (Summer)';
run;

Re: Regression with set interval for x-value

Haris — Wed, 27 Jun 2018 18:16:51 GMT

You can only have one WHERE statement

(where=( Month in (6,7,8) AND Weekday in (1,2,3,4,5) ) );