topic Re: Forecasting by Weeks in SAS Visual Analytics

Forecasting by Weeks

ldenney — Fri, 11 Oct 2019 00:02:33 GMT

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!

Re: Forecasting by Weeks

VDD — Fri, 11 Oct 2019 00:43:21 GMT

have you tried the week function?

https://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n1ka2ulrvrjlasn0z7beco2yrgas.htm

you should be-able to at least create a new variable containing the week value and do the forecasting.

Re: Forecasting by Weeks

Reeza — Fri, 11 Oct 2019 02:22:55 GMT

Leave it as a date field but apply a date format and then try that.

Re: Forecasting by Weeks

FredrikE — Fri, 11 Oct 2019 07:59:32 GMT

Hi!

To be able to do forecast you need a date variable. On that variable you can assign different formats, but (at least in v7.4) there are no week format and you can't do forecast on week...

As far as I know :0

//Fredrik

Re: Forecasting by Weeks

ldenney — Tue, 15 Oct 2019 00:54:50 GMT

Thank you for your suggestions. V7.5 doesn't offer a week format...there are many other format types but not week as an option. I can create a calculated field but VA doesnt recognize it as a date only a number. I'm considering building the forecast in Base SAS and bringing it in as part of my dataset. Just thought I would check to see anyone else has this issue.

Re: Forecasting by Weeks

Reeza — Tue, 15 Oct 2019 01:12:07 GMT

That sucks. If you go to Find a Community>SAS Ballotware>New you can add this as a feature request to have it considered/added to a future version, if it already hasn't been added.

Re: Forecasting by Weeks

FredrikE — Tue, 15 Oct 2019 09:00:31 GMT

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.

//Fredrik

Re: Forecasting by Weeks

mskatymay — Tue, 15 Oct 2019 16:50:14 GMT

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.