BookmarkSubscribeRSS Feed
Lopa2016
Fluorite | Level 6

Hi ,

 

I have monthly data sets which look like this:

 

dismonthprossActual
JUL15AUG154415822.77
JUL15SEP1633578.75
JUL15NOV15408408.93
JUL15JUL153347038.23
JUL15JUN1659340
JUL15OCT175526.5
JUL15MAR16112341.58
JUL15JUL174363
JUL15SEP151611128.75
JUL15APR174426
JUL15JAN16140840.5
JUL15JAN1711595.75
JUL15OCT1621883.75
JUL15JUL1661080.5
JUL15OCT15696127.06
JUL15DEC172350
JUL15APR1689935.1
JUL15SEP172544.5
JUL15JUN174731.5
JUL15MAR1715919
JUL15DEC1613774
JUL15DEC15300524.3
JUL15AUG1658034.25
JUL15MAY1680908.5
JUL15NOV179548.4
JUL15AUG177095.36
JUL15FEB16157373.5
JUL15MAY173204
JUL15FEB178664.25
JUL15NOV1615808

 

I want to forecast for the next 5 years but when I use proc arima few of the forecasts are negative & look incorrect & there are a few warnings :

 

Warning: There are gaps in the interval for observation 2 according to ID variable PROSS_DATE.

 

Can some one help out?

 

Thanks in advance.

 

 

2 REPLIES 2
Lopa2016
Fluorite | Level 6
I believe proc expand is the solution
DougWielenga
SAS Employee

It is not clear to me what you are trying to do.  You said you have monthly data sets that look like your example (presumably DISMONTH which in your data only shows observations for July 2015), so what is the PROSS date?   Are you trying to analyze the monthly files separately or was the data you showed just one month from a large set of monthly data which has many observations?   Either way, the EXPAND procedure can help you interpolate any missing values and or accumulate your data to the desired level.  It would be easier if you sorted the data by date as needed to be able to more easily see patterns.  There seems to be some wild fluctuations in ACTUAL but it is hard to see if any patterns are present when the data is not sorted.   Were you able to get what you needed using the EXPAND procedure?

 

Cordially,

Doug

 

 

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!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 810 views
  • 0 likes
  • 2 in conversation