I want to run proc forecast on mentioned below data
Sr No | Product | Date | Unit |
1 | P1 | 01-Jan-18 | 88 |
2 | P1 | 02-Jan-18 | 82 |
3 | P1 | 03-Jan-18 | 149 |
4 | P1 | 04-Jan-18 | 151 |
5 | P1 | 05-Jan-18 | 177 |
6 | P1 | 06-Jan-18 | 307 |
7 | P1 | 07-Jan-18 | 179 |
8 | P1 | 08-Jan-18 | 148 |
9 | P1 | 09-Jan-18 | 139 |
10 | P1 | 10-Jan-18 | 105 |
11 | P2 | 01-Jan-18 | 115 |
12 | P2 | 02-Jan-18 | 75 |
13 | P2 | 03-Jan-18 | 52 |
14 | P2 | 04-Jan-18 | 128 |
15 | P2 | 05-Jan-18 | 50 |
16 | P2 | 06-Jan-18 | 61 |
17 | P2 | 07-Jan-18 | 49 |
18 | P2 | 08-Jan-18 | 42 |
19 | P2 | 09-Jan-18 | 36 |
20 | P2 | 10-Jan-18 | 89 |
As you see, there is two product and their date and unit is there, I want to forecast with proc forecast for next 5 days for both the product in the same table. The actual scenario we have more than 40K product so I want to know how can I forecast for next 5 days in the same table with smaller code.