We created a project in Forecast Studio that was working fine with all the models generated. Suddenly all the values for this project were displayed empty.
For more details please check the attached file
We would like to know the reason that cause this issue in the FStudio Project and how to solve it.
After executing a DIAGNOSE the FStudio generated a LOG>
Could it be a corruption in the RECSTAT data set?
27669 proc datasets library=_HPF6 nolist;
27670 modify recstat;
27671 index delete _nodeKey_ ;
WARNING: No key variables have been defined for file RECSTAT.
WARNING: No index named _nodeKey_.
27672 index create _nodeKey_ = (sSALESORG sDISTR_CHAN sMATL_GRP_1 sMAT_DESCR CL3_NAME CL4_NAME CL5_NAME) ;
ERROR: Variable SSALESORG is not on file _HPF6.RECSTAT.
ERROR: Variable SDISTR_CHAN is not on file _HPF6.RECSTAT.
ERROR: Variable SMATL_GRP_1 is not on file _HPF6.RECSTAT.
ERROR: Variable SMAT_DESCR is not on file _HPF6.RECSTAT.
ERROR: Variable CL3_NAME is not on file _HPF6.RECSTAT.
ERROR: Variable CL4_NAME is not on file _HPF6.RECSTAT.
ERROR: Variable CL5_NAME is not on file _HPF6.RECSTAT.
The connection is fine. The problem is specific with the project.
Other projects are workign fine. Even when trying the option diagnose, fit or forecast over the project the system does't do anything for this specific project. For other projects it's working fine.
It looks like something got corrupted. Like Alex said, unarchiving a saved version should restore it to a working state. If the problem comes up again, could you please contact tech support about the issue? They will guide you to providing the information we need to look at it. Thank you.
Are the tables you are using having the same table name and variables? If they are not the same, forecast studio will invalid all the existing models (including the custom models) and run full diagnose process. If you still have the original project archived, you can try to unarchieve it and update the project with full diagnose without resetting all series to "automatic selection".
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.