BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
xlingjin
Fluorite | Level 6

How many forecasting projects can SAS forecasting server run at the same time? If I have a database for 300,000 clients, and I would like to run a forecasting of sale for each of them. Will it be too much for the server to handle? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
mitrov
SAS Employee

The license for SAS Forecast Server is all you need. The install program will install everything needed. 

 

Try Googling "sas forecast server administrator's guide". That should bring you to the documentation. Chapter 11 is what you want to look at. 

View solution in original post

6 REPLIES 6
mitrov
SAS Employee

I am assuming you mean you have 300,000 series, one per each client? Each Forecast Studio project can handle many series. So all those 300,000 can go into one single project. Or you can split them into several projects.

In general, the answer depends on the data and the capacity of your server. Do you have, for example, 3 years of data at weekly interval for your 300,000 customers? Absolutely, FS can handle that on any modern machine.

Do you have 3 years of data at a nanosecond interval? Well, now we have to be a little bit more careful on how you organize it and the machine you are using.

xlingjin
Fluorite | Level 6

Thank you very much for your reply!

 

Yes, it's 300,000 series, one per each client. Each client will have its own time series. It will be ~5 years of data at a daily interval. So from your experience, it looks like FS server should be able to handle it. How about forecasting studio desktop version? Can it handle large-scale forecasting?

 

I found some demo for SAS server and desktop version of forecasting studio, but I did not find any for the batch program. How does the batch program run?

 


@mitrov wrote:

I am assuming you mean you have 300,000 series, one per each client? Each Forecast Studio project can handle many series. So all those 300,000 can go into one single project. Or you can split them into several projects.

In general, the answer depends on the data and the capacity of your server. Do you have, for example, 3 years of data at weekly interval for your 300,000 customers? Absolutely, FS can handle that on any modern machine.

Do you have 3 years of data at a nanosecond interval? Well, now we have to be a little bit more careful on how you organize it and the machine you are using.




mitrov
SAS Employee

Forecast Studio for desktop is limited to 1,000 series. It doesn't sounds that it would be suitable for your problem. 

 

The batch interface is composed by SAS macros and accesses the same APIs used buy the GUI. You can find the documentation here:

http://supportprod.unx.sas.com/documentation/onlinedoc/forecast/14.2/fsag.pdf#page=115

 

xlingjin
Fluorite | Level 6
Thanks a lot! It seems SAS forecasting server would be the best option for our application. Your link does not work. Are there any other way to access to the doc? To run SAS forecasting server, are there any other required software that we will need to purchase? we currently don't have any SAS products.
mitrov
SAS Employee

The license for SAS Forecast Server is all you need. The install program will install everything needed. 

 

Try Googling "sas forecast server administrator's guide". That should bring you to the documentation. Chapter 11 is what you want to look at. 

xlingjin
Fluorite | Level 6
Great! I really appreciate your help!!

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

Multiple Linear Regression in SAS

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.

Discussion stats
  • 6 replies
  • 1026 views
  • 3 likes
  • 2 in conversation