Any suggestions on how to forecast in VA using a week? I can calculate a week field (1 thru 52) but it appears SAS does not recognize it as a date in the forecast. Any help is appreciated!
have you tried the week function?
you should be-able to at least create a new variable containing the week value and do the forecasting.
One way could be to create a date variable with the value of the first day in each week, so for everyday in the week you create the date of the first day in that week.
Don't know if it is possible, but one way to solve it.
The backdraw is that you can not display the week number in the report.
I had this issue (using v 7.4) and to solve it I created a data variable for the last day of the week. So in visualizations I can show both (or either) the date or the "week end date" for summaries. I could not find a way to set up weeks as summary periods for doing any periodic comparisons.
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.