topic Re: How to extract intercept and residuals from a panel regression as a separate data file in SAS Data Science

How to extract intercept and residuals from a panel regression as a separate data file

Ahmad — Thu, 21 Mar 2013 00:08:18 GMT

Hi i am estimating a dummy panel regression to remove seasonality.

The equation goes something like this

Y = intercept + b mon + b2 tue + b3 wed + b4 thrsday + e

Now i want to calculate a variable which would be intercept+ e

i am using proc reg with a "by" variable

how to extract only the intercept and residual as a seperate data set.

I know how to extract residual , but extracting intercept is very tricky . By using outest command it gives me a very jumbled data set with alot of other observations too.

Is there any efficient way???

Thanks in advance for helping

Re: How to extract intercept and residuals from a panel regression as a separate data file

Ahmad — Thu, 21 Mar 2013 00:47:27 GMT

kindly help me on this need help urgently, sorry for bugging

Re: How to extract intercept and residuals from a panel regression as a separate data file

PGStats — Thu, 21 Mar 2013 01:45:46 GMT

It is quite straitforward to combine OUTEST= and OUT= datasets :

proc reg data=myData outest=myParms;
by myByVar;
model Y = mon tue wed thrsday;
output out=myRes r=resid;
run;

proc sql;
create table noSeason as
select R.myByVar, P.intercept + R.resid as Yp
from myParms as P inner join myRes as R on P.myByVar=R.myByVar
where P._TYPE_="PARMS";
quit;

Re: How to extract intercept and residuals from a panel regression as a separate data file

Ahmad — Thu, 21 Mar 2013 02:06:48 GMT

Thanks alot really appreciate

Re: How to extract intercept and residuals from a panel regression as a separate data file

Ahmad — Thu, 28 Mar 2013 21:39:22 GMT

Dear there is one little problem, all the out put tables delete the date variable and i want to include the date variable, is there any remedie for that.

Kindly reply as soon as you can . Really appreciate your help

Thanking you in anticipation

Re: How to extract intercept and residuals from a panel regression as a separate data file

PGStats — Fri, 29 Mar 2013 01:40:16 GMT

How is your date variable related to your other variables, especially to your BY variable(s)?

Re: How to extract intercept and residuals from a panel regression as a separate data file

Ahmad — Fri, 29 Mar 2013 01:45:06 GMT

it is a panel data basically, for 500 stocks , daily data over 7 years. so my by variable is the stock name, which is to say o am estimating regression for every stock seperately,

i managed to get the desired result by manipulating the code you provided , kindly check if i have done it right or if there is a more efficient way kindly suggest that

proc sql;

create table noSeason1 as

select R.codneg, P.intercept + R.resid as Yp ,date

from myres as R inner join Myparms as P on R.codneg=P.codneg

where P._TYPE_="PARMS";

quit;

Re: How to extract intercept and residuals from a panel regression as a separate data file

Ahmad — Fri, 29 Mar 2013 01:45:56 GMT

where codneg is the stock name variable, and rest is all the same as you suggested

Re: How to extract intercept and residuals from a panel regression as a separate data file

PGStats — Fri, 29 Mar 2013 01:56:20 GMT

That looks perfectly fine to me!

Re: How to extract intercept and residuals from a panel regression as a separate data file

Ahmad — Fri, 29 Mar 2013 01:58:22 GMT

thanks you are a great help