BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi
Hope someone out there would help me.

I have 7 years historical data on hospital separations and want to forecast the future hospital demand for the next decade by selected variables such as category of disease, place of residence and place of treatment, using SAS/ETS.
A sample of data look like:

TimeID Separations Categories of disease, place of residence
01Jan2001 800,000 1 1
01Jan2002 900,000 1 1
.
.
01Jan2007 1,110,000 1 1

01Jan2001 900,000 1 2
01Jan2002 950,000 1 2
.
.
01Jan2007 1,120,000 1 2
01Jan2001 800,000 2 1
01Jan2002 900,000 2 1
.
.
01Jan2007 1,110,000 2 1

01Jan2001 900,000 2 2
01Jan2002 950,000 2 2
.
.
01Jan2007 1,120,000 2 2


The above is a simplified version of my data, just wanted to find out (i) how I can include the explanatory variables into forecasting models using Time Series Forecasting System (TSFS) and (ii) if I choose the 'fit the model automatically' option in the TSFS, does that mean the computer will then automatically select the best fit model for my data so that I don't have to test and compare each individual models such as using PROC ARIMA, PROC EXPAND, PROC VARMAX etc.

Thanks.

Paris
4 REPLIES 4
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Suggest you check the SAS support website http://support.sas.com/ and the SEARCH FACILITY using the forum post subject to start. I found several references on the topic / subject posted.

Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
Sbb

I didn't find the answers from the website that you have directed me to. Can you please be more specific?

Paris
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Using your SUBJECT, I used the website search facility and also Google advanced search with lowercase parameter site:sas.com to limit the search to the SAS.COM website, and found these two papers related to SAS/ETS software:

http://support.sas.com/rnd/app/papers/tsfs.pdf


Also, an acronym TSFS (Time Series Forecasting System) may help reveal additional reference materials.

The link below references a technical paper on PROC MDC, if useful:

http://support.sas.com/rnd/app/papers/mdc.pdf


Scott Barry
SBBWorks, Inc.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 4 replies
  • 954 views
  • 0 likes
  • 2 in conversation