topic Re: Slope output for multiple PROC REG in SAS Enterprise Guide

Slope output for multiple PROC REG

matt23 — Mon, 02 Jul 2018 17:42:59 GMT

If I run this code:

proc sort data=dataname;
where Month in (1,2,3);
where also Day in (1,2,3);
by Hour;
run;

proc reg data=dataname;
where Month in (1,2,3);
where also Day in (1,2,3);
model Y=X;
by Hour;
run;

And I get Regression results for every hour.

Is there a way I can output slope of X for every hour into a new table or whatever? Anything just so I don't have to manually copy the slope (Parameter Estimates) into notepad?

Re: Slope output for multiple PROC REG

PaigeMiller — Mon, 02 Jul 2018 18:25:23 GMT

Use the OUTEST= option

http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=statug&docsetTarget=statug_reg_syntax01.htm&locale=en

Re: Slope output for multiple PROC REG

Reeza — Mon, 02 Jul 2018 20:07:57 GMT

ods output ParameterEstimates=PE_Table;
proc reg data=dataname;
where Month in (1,2,3) and Day in (1,2,3);
by Hour;
model Y=X;
run;

Another method is using the ODS OUTPUT statement, this approach allows you to capture almost any ODS output and then reformat into the output you'd like.

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html