BookmarkSubscribeRSS Feed
mudassir
Calcite | Level 5

Hello,

I have a bank profit data for 3 years(2004,2005,2006).

I want to build forecasting model for next 12 months (year 2007).

Can some one guide me how to build this?

 

my forecast expectation is like below table

mudassir_0-1598293433645.png

 

1 REPLY 1
dw_sas
SAS Employee

Hi @mudassir 

 

What SAS products--such as Visual Forecasting in Viya, SAS Forecast Server, or SAS/ETS-- do you have access to?

 

If you are using SAS/ETS, then you will first need to fill in the gaps in your data prior to fitting a model.  PROC TIMESERIES is a useful procedure for that.  For example, the following code fills in the gaps in your data with missing values and then plots the resulting series:

 

proc timeseries data=monthly_profit out=monthly_profit_ts plots=series;
  id month1 interval=month setmissing=missing;
  var bank_profit;
run;

The series appears to have several outliers.  Are these values accurately entered?  If so, then do you want to treat one or more of these values as outliers?  Which ones?  Looking forward to any additional information you can provide!

 

DW

 

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Discussion stats
  • 1 reply
  • 934 views
  • 0 likes
  • 2 in conversation