- data test;
- retain Stkcd date sumx;
- format date yymmdds10.;
- input Stkcd / date yymmdd10. / sumx;
- cards;
- 1
- 2014/1/4
- 3
- 1
- 2014/3/6
- 9
- 2
- 2015/7/1
- 4
- 2
- 2015/8/6
- 2
- ;
- run;
- proc timeseries data=test out=want;
- by stkcd;
- id date interval=day accumulate=average
- format=yymmdd10.
- setmissing=previous
- start='01jan2014'd
- end='31dec2015'd;
- var sumx;
- run;