topic Re: Making a new data set from results. in SAS Enterprise Guide

Making a new data set from results.

matt23 — Wed, 27 Jun 2018 20:59:01 GMT

I want to run PROC REG hourly like in the code below:

proc sort data=matt (where=(Month in(6,7,8)));
by Month Hour;
run;

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

Now, is there a way I can get out a new data out of this that records just the intercept value for every hour. Like this:

input hour intercept;

datalines;

0 1234

1 1333

2 1400

...;

Re: Making a new data set from results.

pau13rown — Wed, 27 Jun 2018 21:04:00 GMT

"ods output parameterestimates=getintercept;" https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_reg_sect051.htm

if that doesn't work let me know

Re: Making a new data set from results.

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

Sorry, I am not a pro at SAS, Do you have an example of a code that uses this to give me an idea how to implement this?

Re: Making a new data set from results.

pau13rown — Wed, 27 Jun 2018 21:11:59 GMT

there was a recent post that covered ods in general: https://communities.sas.com/t5/Base-SAS-Programming/Extracting-variables-from-statistical-results-for-use-in-other/m-p/473223#M121406

for your particular code it would be:

ods output parameterestimates=get_intercept (where=(parameter=''));

proc reg data=matt (where=(Month in(6,7,8)));

model Load=Temperature;

by Hour;

label Load="Load (MW)" Temperature="Temperature (degrees F)";

title 'Load vs Temperature (Summer)';

run;

i'm not sure about this bit: (where=(parameter='')) because i'm not sure what the variable name will be and what the text will be, maybe you want parameter='Intercept', but you'll have to look at the dataset created (called get_intercept) to see what it contains and to confirm that you have the intercept estimate for each hour