proc expand to calculate moving avg exlcuding current data point

a_khedekar — Wed, 08 Jan 2020 21:21:55 GMT

I am using proc expand to calculate moving average for 12 weeks of data. But my requirement is to calculate moving average for 12 weeks (excluding current week) and compare that with current week. Is there any way to achieve that using proc expand?

Basically I want to calculate moving avg for 12 weeks excluding current week.

proc expand data=alerttable out=base_y method=none factor=(1:11);
   id weekstart;
   by strategynm;
   convert weekcount=MovAv30  / transformout=(movave 12);
   convert weekcount=CurrVal  / transformout=(movave 01);
   convert weekcount=Std      / transformout=(movstd 12); 
   convert weekcount=PreVal	  / transformout=(lag 1);
   convert weekcount=pctdiff  / transformout=(PCTDIF);
run;

Thanks

Re: proc expand to calculate moving avg exlcuding current data point

unison — Wed, 08 Jan 2020 22:24:31 GMT

Do you have daily observations? Weekly? To better assist, please provide sample data in a data step.

Re: proc expand to calculate moving avg exlcuding current data point

a_khedekar — Thu, 09 Jan 2020 14:04:30 GMT

Observations are weekly with weekcount for each week.

topic Re: proc expand to calculate moving avg exlcuding current data point in SAS Procedures

proc expand to calculate moving avg exlcuding current data point

Re: proc expand to calculate moving avg exlcuding current data point

Re: proc expand to calculate moving avg exlcuding current data point