How can i change the date format on the graph in forecasting view and the range? for example i would it to be Jan 13 instead of 01/01/2013 and also i am forecasting up to march 2016 but on the graph it shows up to Jun 2016 fir some reason (dates up to June no data points)
It is possible to change the format of Time ID. From inside the project select, Project > Forecasting Settings. This will open the "Forecasting Settings" dialog. A screenshot is also attached for help.
In the "Forecasting Settings" dialog select the "Time ID" card on the left hand side. This will show you all the settings related to Time ID. There is "Format" field and associated Edit button, click on the Edit button which will bring up "Edit Time ID Format" dialog. Choose the "Select from list" radio button. You can select various types of time ID formats including MONYY which you are looking for.
Press OK in all dialogs to save your choice. Once you are back to project, you will be able to see the format on every view of Forecast Server. Let me know if it helps.
Regarding the data truncation issue, the forecasts begin after the last non missing date for the dependent variable and it is same for the whole project. Need to check the last date against the dependent variable. If you still see the issue can you share the data with me?
What you are seeing is very strange indeed. Unfortunately I can not help you more unless i have more information. I would suggest you to open a tech support track for the issue you are seeing.
What does the raw data look like? I am specifically interested in the time ID column. The periodicity you are trying to generate your forecasts? a snapshot of the data may help.
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.