Hello 🙂 I have this data:
interval |
sales |
1 |
2,564,303,150 |
2 |
2,549,961,650 |
3 |
2,505,588,400 |
4 |
2,657,071,900 |
5 |
2,661,563,300 |
6 |
2,710,006,000 |
7 |
2,576,194,550 |
8 |
2,747,461,050 |
9 |
2,695,094,300 |
10 |
2,755,230,050 |
11 |
2,623,167,350 |
12 |
2,850,129,800 |
13 |
2,849,498,000 |
14 |
2,947,182,650 |
15 |
2,629,371,850 |
On excel, "=FORECAST.ETS(A17,B2:B16,A2:A16,,,)" achieves the following result:
Interval |
Sales |
16 |
2,917,825,906 |
However, when I forecast on SAS, I achieve a different result:
data have;
input interval sales;
datalines;
1 2564303150
2 2549961650
3 2505588400
4 2657071900
5 2661563300
6 2710006000
7 2576194550
8 2747461050
9 2695094300
10 2755230050
11 2623167350
12 2850129800
13 2849498000
14 2947182650
15 2629371850
;
proc forecast data=have lead=1
method=expo trend=3
out=pred outfull outresid;
var sales;
id interval;
run;
SAS forecast result:
How do I modify the SAS code to replicate excel's forecast for interval 16 ($2,917,825,906 sales)?
Any help is appreciated, thank you.