I'm fitting batch forecasts in Forecast Studio. For example:
Fiscal Yr | YearMo | Total | Series 1 | Series 2 | Series 3 | Series 4 |
2006 | 200510 | 26338 | 16979 | 5293 | 10509 | 1177 |
2006 | 200511 | 24133 | 15026 | 4211 | 9708 | 1107 |
2006 | 200512 | 27442 | 16378 | 5184 | 10068 | 1126 |
2006 | 200601 | 25831 | 15533 | 4351 | 10104 | 1078 |
2006 | 200602 | 26873 | 15395 | 2954 | 11257 | 1184 |
2006 | 200603 | 32136 | 19377 | 4093 | 13789 | 1495 |
2006 | 200604 | 58889 | 49849 | 36822 | 11929 | 1098 |
2006 | 200605 | 72679 | 62809 | 48554 | 13008 | 1247 |
2006 | 200606 | 37749 | 27585 | 12171 | 14169 | 1245 |
2006 | 200607 | 32967 | 24055 | 10258 | 12543 | 1254 |
2006 | 200608 | 30900 | 19856 | 3972 | 14202 | 1682 |
2006 | 200609 | 27756 | 17866 | 3026 | 13350 | 1490 |
2007 | 200610 | 27915 | 18024 | 2987 | 13440 | 1597 |
2007 | 200611 | 24968 | 15801 | 2646 | 11784 | 1371 |
2007 | 200612 | 25051 | 15096 | 2575 | 11289 | 1232 |
2007 | 200701 | 27525 | 15833 | 2405 | 12142 | 1286 |
2007 | 200702 | 27436 | 15634 | 2641 | 11788 | 1205 |
2007 | 200703 | 30060 | 17432 | 3515 | 12712 | 1205 |
2007 | 200704 | 125015 | 113958 | 98665 | 13978 | 1315 |
2007 | 200705 | 33470 | 22134 | 5020 | 15486 | 1628 |
2007 | 200706 | 32546 | 21665 | 4678 | 15077 | 1910 |
2007 | 200707 | 34519 | 22897 | 4887 | 16224 | 1786 |
2007 | 200708 | 26916 | 16899 | 3603 | 11938 | 1358 |
2007 | 200709 | 27510 | 17369 | 2900 | 12901 | 1568 |
Without editing out dates prior to import, is it possible to adjust individual time series so that some forecasts begin on different dates than other time series in the same batch? For example, Series 1 and 2 Begin on 200610, while all other series begin on 200510?
Thanks!
I am not sure I fully understand your question. Do you want to set the forecasts to missing values for some dates?
If so, it would have to be done outside Forecast Studio. Forecast Studio generates a forecast for the first date for which it is feasible. You can create a stored process to do that and then run it within Forecast Studio. But that would still require manual coding.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.