topic Re: how to use R² from multiple regressions as a variable in another regression in SAS Programming

how to use R² from multiple regressions as a variable in another regression

Ahmad — Thu, 05 Jul 2012 01:14:50 GMT

hi i am estimating regressions for stock prices on monthly basis, i want to creat a timeseries variable of R² from each regression , How to do it????

Re: how to use R² from multiple regressions as a variable in another regression

PGStats — Thu, 05 Jul 2012 01:37:30 GMT

Like this :

proc reg data=have outest=want;

by myStock myWhatever;

model myPrice = myXvariable / rsquare;

run;

proc print data=want;

var myStock myWhatever _RSQ_;

run;

Re: how to use R² from multiple regressions as a variable in another regression

Ahmad — Thu, 05 Jul 2012 01:42:52 GMT

Thanks for the quick reply , i have another question how can i calculate weekly standard deviation from my daily price series and use it in a regression as a variable??

Thanks

Regards

Re: how to use R² from multiple regressions as a variable in another regression

PGStats — Thu, 05 Jul 2012 14:38:21 GMT

If I get it right, what you want is something like (untested) :

proc sql;

create table myWstd as

select stock, intck("WEEK", '01JAN2000'd, myDate) as weekNo, std(price) as priceStd

from myData

group by stock, calculated weekNo;

and then regress priceStd on weekNo, by stock.