topic Re: Forecasts as a Time Series Plot - How to remove predicted values? in SAS Visual Analytics

Forecasts as a Time Series Plot - How to remove predicted values?

illmatic — Wed, 02 Nov 2022 03:44:32 GMT

Hi all,

Pretty simple question, just wondering what best practices are here.

I have a simple Time-Series forecast built in Build Models.

When imported into Visual Analytics, the time series always includes predicted values, even when actuals are already posted.

I'd actually like to build a view where the Predicted Values only show up after the current date where Actual Values are posted. I'd also enjoy having the line there showing the end of the Actuals and beginning of the Predicted.

Thanks in advance!

Re: Forecasts as a Time Series Plot - How to remove predicted values?

illmatic — Thu, 03 Nov 2022 18:55:45 GMT

This forum is pretty dead 😞

Re: Forecasts as a Time Series Plot - How to remove predicted values?

Sam_SAS — Fri, 04 Nov 2022 12:33:22 GMT

The problem may be that we don't have many Model Studio users here.

It would also help if you post a screen capture of the output you are getting, and if you tell us what version of Visual Analytics you are using.

When you build a forecasting object directly in Visual Analytics, there is normally a line to show where the predicted values begin. But I'm not sure if this is the case for an imported model.

Sam

Re: Forecasts as a Time Series Plot - How to remove predicted values?

Stu_SAS — Fri, 04 Nov 2022 13:33:38 GMT

Hey @illmatic! I do this all the time when producing forecasts. The simplest way is to create a new calculated item for your predicted values:

if(notmissing('actual'n) ) return .
    else 'predict'n

This will set Predict to missing wherever there are actuals, but you'll have a line break. If you do not want to have a line break, you just need to do a little bit of data prep. Let's use an example of a forecast from PROC ESM:

proc esm data=sashelp.air outfor=outfor;
    id date interval=month;
    forecast air / model=multseasonal;
run;

Let's scroll down to where actuals end.

DATE	ACTUAL	PREDICT
OCT1960	461	433
NOV1960	390	390
DEC1960	432	429
JAN1961	.	445
FEB1961	.	419
MAR1961	.	469

To make the lines connect, we need to set predict to missing before the last date of actuals. In other words, we want this:

DATE	ACTUAL	PREDICT
OCT1960	461	.
NOV1960	390	.
DEC1960	432	429
JAN1961	.	445
FEB1961	.	419
MAR1961	.	469

With a little SQL and DATA Step logic, we can do this:

/* Read the last actual date into a macro variable */
proc sql noprint;
    select max(date)
    into :last_actual_date
    from outfor
    where actual NE .
    ;
quit;

/* Set predict to missing before the last actual date */
data outfor2;
    set outfor;
    
    if(date < &last_actual_date.) then predict = .;
run;

When you load your data into Visual Analytics, you'll have no fitted values in the past and a connecting line once predictions begin.

Re: Forecasts as a Time Series Plot - How to remove predicted values?

illmatic — Fri, 04 Nov 2022 16:36:51 GMT

thanks @Stu_SAS !

My current issue is that I still get predicted values after realized dates with that logic. I believe it is because of the hierarchies. I'll try to breakout the dataset more and tweak the logic from there.

Since you have some experience with visualizing models, do you have a current best method in regard to automating a refresh?

I'm noticing that I have to reload the dataset, re-run the pipelines, export the dataset, and only then do my visuals have refreshed data. Wondering if it's possible to script it all, current code output scheduling from the pipeline section doesn't seem complete, but I may be wrong.

Re: Forecasts as a Time Series Plot - How to remove predicted values?

Stu_SAS — Fri, 04 Nov 2022 19:06:39 GMT

In Viya I would register the model to Model Manager, then save the scoring code as a .sas file in a folder within SAS Studio. From there, you can schedule it to run as a job in Environment Manager. Your code can then run on a regular batch schedule.

In SAS 9.4 we would use a dedicated scheduler, like Cron in Linux, to run SAS jobs. Since Viya has a built-in batch code runner, we don't need to use it anymore. A great paper on best practices for scheduling in Viya can be found below:

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4248-2020.pdf

How to run a pipeline in batch can be found here:

https://go.documentation.sas.com/doc/en/vfcdc/v_015/vfug/n194n9wnp2xokzn15f9gwn3ejtjo.htm

Your general code flow would look like this:

<copied batch score code goes here>

caslib _ALL_ assign;

proc casutil incaslib='myvacaslib';
    droptable casdata='mytable';
quit;

data myvacaslib.mytable(promote=yes);
    set modeloutputcaslib.mymodeldata;
run;

proc casutil incaslib='myvacaslib';
    save casdata='mytable' replace;
quit;