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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.