Desktop productivity for business analysts and programmers

Regression with set interval for x-value

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Regression with set interval for x-value

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;

Accepted Solutions
Solution
‎06-27-2018 12:20 PM
Frequent Contributor
Posts: 117

Re: Regression with set interval for x-value

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;

 

View solution in original post


All Replies
Solution
‎06-27-2018 12:20 PM
Frequent Contributor
Posts: 117

Re: Regression with set interval for x-value

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;

 

Frequent Contributor
Posts: 89

Re: Regression with set interval for x-value

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;
Frequent Contributor
Posts: 117

Re: Regression with set interval for x-value

You can only have one WHERE statement

(where=( Month in (6,7,8) AND Weekday in (1,2,3,4,5) ) );
☑ This topic is solved.

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

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