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;
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!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.