topic Re: How to combine all intercepts from 30+ regression models into a single dataset/table? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713872#M220309 <P>Yes, if you used a BY statement in your code, then all the intercepts ought to be placed in a single output file. But to give you exact code to do this, we need to see what code you are using.</P> Mon, 25 Jan 2021 11:43:21 GMT PaigeMiller 2021-01-25T11:43:21Z How to combine all intercepts from 30+ regression models into a single dataset/table? https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713839#M220298 <P>Hi,</P><P>&nbsp;</P><P>I am currently working on multiple CAPM models and i have to calculate the returns for each of the stock by using the intercept result from each regression output. Is SAS able to output a new dataset that summarizes only intercept results from the regression output? If so, what is the code?</P><P>&nbsp;</P><P>Thank you for all the help rendered.</P> Mon, 25 Jan 2021 07:58:56 GMT https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713839#M220298 igsteo 2021-01-25T07:58:56Z Re: How to combine all intercepts from 30+ regression models into a single dataset/table? https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713841#M220299 <P>Show us your current code.</P> Mon, 25 Jan 2021 08:00:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713841#M220299 PeterClemmensen 2021-01-25T08:00:04Z Re: How to combine all intercepts from 30+ regression models into a single dataset/table? https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713872#M220309 <P>Yes, if you used a BY statement in your code, then all the intercepts ought to be placed in a single output file. But to give you exact code to do this, we need to see what code you are using.</P> Mon, 25 Jan 2021 11:43:21 GMT https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713872#M220309 PaigeMiller 2021-01-25T11:43:21Z Re: How to combine all intercepts from 30+ regression models into a single dataset/table? https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713873#M220310 Using option PROC REG + OUTEST= get these estimator,<BR />And use PROC APPEND to combine all these estimator. Mon, 25 Jan 2021 11:47:29 GMT https://communities.sas.com/t5/SAS-Programming/How-to-combine-all-intercepts-from-30-regression-models-into-a/m-p/713873#M220310 Ksharp 2021-01-25T11:47:29Z