forecasting of credit card bank profit for next 12 months

[mudassir]

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

[dw_sas]

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