Hello All,
I have data that, essentially, takes the following form:
Date var1 var2
x/x/xx 2 3
x/x/xx 2 2
x/x/xx 2 1
x/x/xx 3 5
x/x/xx 2 1
and so on. What I want to do is regress one variable on another for the previous y periods, and then have the regression beta be output as a variable in the dataset. For example, if I picked y = 5, I would take an observation, regress var1 on var2 for the past 5 periods, and then the code would return that regression coefficient as a variable in the dataset.
I may have done a bad job explaining this, but if you have any questions, please let me know.
Thanks,
John
Create a new table for that previous y periods , like :
%let y=5 ;
data temp;
merge have(keep=date var1) have(firstobs=&y keep=var2);
run;
after that proc reg data=have .
But That might be a bad idea. You'd post it at Foreasting Forum for seeking a Auto Regression Model .
Xia Keshan
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.