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

Good day,

 

I would like to predict new variables based on the precious values. the data below shows the variables.

 

  
MonthAverage volume for month
September,1610510
October,1613288
November,1615841
December,1617535
January,1719415
February,1721221
March,1723321
April,1725314
May,1727240
June,1729430
July,1731300
August,1733090
September,1734983
October,1737065
November,17 
December,17 
January,18 
February,18 
March,18 
April,18 
May,18 

 

How can i best use the values from previous volumes to predict volumes in missing months.

 

thank you

1 ACCEPTED SOLUTION

Accepted Solutions
mitrov
SAS Employee

Kasharp provided above a possible way of generating predictions using PROC ESM which supports exponential smoothing models. 

Since you say you use SAS Studio, I suggest you look at the supplied Forecasting tasks on the left panel.  This short video gives you an introductory tutorial.

http://video.sas.com/detail/videos/how-to-tutorials/video/4414522302001/time-series-modeling-and-for...

 

View solution in original post

6 REPLIES 6
RW9
Diamond | Level 26 RW9
Diamond | Level 26

What is it your asking?  Its your data, so I assume you would know how you want to derive future values?  There are many possiblities, such as taking the last value and carrying it forward, lowest value, max value, mean/median value, previous minus current carried forward etc.  As I have no idea what your trying to achieve i don't see how I  could suggest one.

claytonk
Calcite | Level 5

i have sales volumes for the months stated. what i want is to predict future sales volumes for months without readings. in other ways h do i analyze the data above to draw patterns and predict the the future volumes

Ksharp
Super User

Suggest you to post it at Forecast forum,since it is about time series analysis.

 

data have;
infile cards expandtabs truncover dlm=' ';
input Month : anydtdte32.	Average;
format month monyy7.;
cards;
Sep16	10510
Oct16	13288
Nov16	15841
Dec16	17535
Jan17	19415
Feb17	21221
Mar17	23321
Apr17	25314
May17	27240
Jun17	29430
Jul17	31300
Aug17	33090
Sep17	34983
Oct17	37065
Nov17	 
Dec17	 
Jan18	 
Feb18	 
Mar18	 
Apr18	 
May18
;
run;
proc esm data=have out=nextyear ;
id month interval=month;
forecast average/model=addwinters ;
run;
proc sgplot data=nextyear;
series x=month y=average;
run;
claytonk
Calcite | Level 5

Thank you, your code has helped me clean and formart my data in preparation for Time series Forecasting

that informat to convert string values to dates . Thanx

 

claytonk
Calcite | Level 5
 

Good day,

 

I would like to predict new variables based on the precious values. the data below shows the variables.

 

  
Month volume for month
September,1610510
October,1613288
November,1615841
December,1617535
January,1719415
February,1721221
March,1723321
April,1725314
May,1727240
June,1729430
July,1731300
August,1733090
September,1734983
October,1737065
November,17 
December,17 
January,18 
February,18 
March,18 
April,18 
May,18 

 

How can i best use the values from previous volumes to predict volumes in missing months. Can this be aced using SAS Studio and how. Please assist

 

thank you

mitrov
SAS Employee

Kasharp provided above a possible way of generating predictions using PROC ESM which supports exponential smoothing models. 

Since you say you use SAS Studio, I suggest you look at the supplied Forecasting tasks on the left panel.  This short video gives you an introductory tutorial.

http://video.sas.com/detail/videos/how-to-tutorials/video/4414522302001/time-series-modeling-and-for...

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 1437 views
  • 1 like
  • 4 in conversation