Hi Paige, so here is my actual data. This looks like trend right, linear trend?
and I can use the below to predict values for 12 months
proc forecast data=tt interval=month lead=12 out=yyy;
id date;
var sum_x sum_y; run;
I also looked it up and saw proc forecast with hold,stepar,ses methods...
Would you recommend some of those?
date sum_x sum_y ---------------------------- 201511 3088 7828 201512 2312 7260 201601 2415 5331 201602 2498 5411 201603 3001 6470 201604 3383 7333 201605 3709 8078 201606 4670 10331 201607 4070 9153 201608 4092 9194 201609 3780 8299 201610 3239 6871 201611 3270 7044 201612 2528 5295 201701 1831 4062 201702 1810 3832 201704 2119 4845 201705 6156 13772 201706 3784 8590 201707 3149 7437 201708 3188 7587 201709 2801 6726 201710 2702 6234 201711 2548 5746 201712 2382 5506 201801 1482 3455 201802 1412 3475 201803 1644 4031
... View more