proc forecast for group

Srigyan — Tue, 10 Jul 2018 12:33:01 GMT

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.

Re: proc forecast for group

ChanceTGardener — Tue, 10 Jul 2018 13:12:53 GMT

Use the BY statement. In your case:

by Product;

https://support.sas.com/documentation/onlinedoc/ets/132/forecast.pdf

topic Re: proc forecast for group in SAS Forecasting and Econometrics

proc forecast for group

Re: proc forecast for group