About illmatic

illmatic · ‎04-06-2023

Hi, Forecast Studio is actually in SAS Viya 3.5 under the Build Models module. I think you are referring to Forecast Visual Desktop that is SAS 9.4 based.

illmatic · ‎04-06-2023

Hi Xavier, I found the issue. I changed the 5.2 version to 1.0, but I have since changed it back and all is well.

illmatic · ‎04-06-2023

Hello, When working in the overrides section of Forecast Studio, I've noticed that the attributes shift around while I go through each section. This has been very frustrating as it increases the difficulty of managing my overrides as I try to select each section. Does anybody know how keep the attribute section static so that override management is easier or is this a bug?

illmatic · ‎04-05-2023

Unable to load the task due to one or more errors: 1: The version of this file is out of date. You can only run tasks that were created in SAS Studio 3.1 and later. Any guidance on how to work around this error on a new task? I'm using Studio 5.2

illmatic · ‎04-03-2023

I don't think I can do this in VA...?

illmatic · ‎04-03-2023

Hi Hunter, I started off this way, but the layout would constantly mess up on other people's monitors. I also need the gridlines since I am showing a forecast for many years across many channels. I can try it again sometime, but the floating graphs were a pain to upkeep, so I gave up. I was hoping there was some way to utilize the Rules section where I can have the background of the graph highlighted indicating an event...but even if that's possible, there is likely no way to have it show all the information I need. Thanks for your help! I'm assuming this is the only alternate solution that this point.

illmatic · ‎03-31-2023

Hi all, Is there a better way to show events as a backdrop in a timeseries graph? I'd like to make it easier for the reader to see what events were the backdrop to any possible fluctuations in sales. Here is the current visual coming from 2 separate datasets and 2 separate graphs stacked.

illmatic · ‎02-14-2023

That's it! Thanks Bruno!

illmatic · ‎02-04-2023

Hi all, I have a dataset where on the X-axis is a bunch of dates, Y-axis is an amount of sales, and Y2-axis is active events during that time period. Right now everything looks good, except for the Y2-axis values. I am categorizing my events into buckets 1-8. When added to the line graph, SAS VA automatically connects the lines, but I don't want them connected. How do I turn this off? Picture of a single y-axis line graph showing the connecting going on.

illmatic · ‎02-02-2023

Viya 3.5 Studio 5.2 Model Studio 8.5

illmatic · ‎01-31-2023

Hello all, I currently manage many forecasts and I'm utilizing the Batch API macro to refresh the pipelines when new data comes in. I share these forecasts with other demand planners in the project management area, but to refresh the pipelines, I have to make these projects private first. This can take some time and is a nuisance currently as I click through each one to privatize then publicize the project after updates. Is there a better way to do this? I am hoping for some code/macro that will use the project's UUID to identify it and make it private before pipelines are refreshed. Thanks!

illmatic · ‎01-31-2023

Hello all, I currently manage many forecasts and I'm utilizing the Batch API macro to refresh the pipelines when new data comes in. I share these forecasts with other demand planners in the project management area, but to refresh the pipelines, I have to make these projects private first. This can take some time and is a nuisance currently as I click through each one to privatize then publicize the project after updates. Is there a better way to do this? I am hoping for some code/macro that will use the project's UUID to identify it and make it private before pipelines are refreshed. Thanks!

illmatic · ‎01-19-2023

The lowest granularity of data for actual sales is daily. The lowest granularity for forecasted values in weekly, currently.

illmatic · ‎01-19-2023

The collection of daily data is no problem, but that only works for actuals. What about forecasted values? Right now I am getting predicted values for each week. That's when we use the ratios to break those predicted values into daily values for the roll-up. For numerators, are we still speaking of just the actuals then? If that's the case, I agree. And we can use a calendar dataset to make sure the correct denominators are used. Is that what you mean by this?

illmatic · ‎01-19-2023

Hi all, I am forecasting sales data on a weekly interval as is common for trend analysis and proper forecasting in my sector. Our sales team refers only to monthly numbers for their tracking. I am currently using a method that uses ratios of sales by day to bring the weekly forecasts to a daily value and then summing that up to create the monthly amount. This way the weekly forecasts (generally) match up with the monthly amounts. My question is this: Is there an easier/better way to do this? I am uneasy about using hardcoded ratios for daily sales and am unenthusiastic about having to update those values on a quarterly or annual basis. Example for ratio inputs to get day values (0=sunday, 6=Saturday) data weekly_ratio; input offset index; datalines; 0 0.112830357 1 0.12365025 2 0.121380371 3 0.126998287 4 0.133086871 5 0.168109228 6 0.213944636 ; run; Thanks for your input in advance!

Online Status	Offline
Date Last Visited	‎07-30-2024 04:30 PM

Re: LLM to review SAS coding? Which is best?

Re: LLM to review SAS coding? Which is best?

Re: SAS Extension for Visual Studio Code

Re: Promotion already exits when uploading a dataset to CAS

Promotion already exits when uploading a dataset to CAS

An error was encountered loading the data ...

When scheduling a SAS program as a job, changes to code do not save

Re: How do I assign a date value to a parameter from a linked action?

How do I assign a date value to a parameter from a linked action?

Re: Incorrect aggregation of ABS values

SAS Extension for Visual Studio Code

Re: When scheduling a SAS program as a job, changes to code do not sav...

Re: When scheduling a SAS program as a job, changes to code do not sav...

Re: How do I assign a date value to a parameter from a linked action?

Re: Date reference that always takes date of most recent Sunday?

Re: LLM to review SAS coding? Which is best?

Re: How do I assign a date value to a parameter from a linked action?

How do we get Visual Programming/Process Flows back? Viya 3.5

Re: Model Studio - Attributes keep shifting around

Re: Create a SAS Viya Job with a prompt using Task Prompts

Model Studio - Attributes keep shifting around

Re: Create a SAS Viya Job with a prompt using Task Prompts

Re: Is there a better way to show events in a time series?

Re: Is there a better way to show events in a time series?

Is there a better way to show events in a time series?

Re: How to stop datapoints from connecting in a line graph?

How to stop datapoints from connecting in a line graph?

Re: How to make models private before pipelines are refreshed?

How to make models private before pipelines are refreshed?

Managing many forecasts via Batch API Question - How to make projects ...

Re: Rolling up Weekly Forecasts to Monthly - Best Practices?

Re: Rolling up Weekly Forecasts to Monthly - Best Practices?

Rolling up Weekly Forecasts to Monthly - Best Practices?