Slope output for multiple PROC REG

[matt23]

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?

[PaigeMiller · Accepted solution]

Use the OUTEST= option

http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=statug&docsetTarget=statug_reg...

[Reeza]

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