Help using Base SAS procedures

Proc ARIMA fitting problem

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 88
Accepted Solution

Proc ARIMA fitting problem

I have a data set of time series observations with a seasonal trend.

I have de-trended and de-seasonalized it using by first differencing and also taking the log of observations. However, when I want to fit an ARIMA model, It is almost impossible to have a proper fit.

This is my code and I have attached the data set.

proc import datafile="liquor.csv"

out=liquor

dbms=csv

replace;

getnames=no;

run;

data liquor (rename=(var1=sales));

set liquor;

t = _n_ ;

*The log transformation is predeferencing transformation to make constant seasonal variation;

LogSales=log(sales);

*These are three different differencing transformation to make the data stationary;

SALES1=logsales-lag(logsales);

SALES2=logsales-lag12(logsales);

SALES3=logsales-lag(logsales)-lag12(logsales)-lag13(logsales);

x=sales1-lag12(sales1);

run;

proc timeseries data=liquor

                   out=series

                   outtrend=trend

                   outseason=season print=seasons;

      id date interval=month accumulate=avg;

      var x;

   run;

proc arima data=LIQUOR ;

      identify var=x esacf ;

      estimate  p=2 q=3;

   run;

Any suggestions and help is greatly appreciated.

Attachment

Accepted Solutions
Solution
‎05-01-2013 08:09 PM
Frequent Contributor
Posts: 88

Re: Proc ARIMA fitting problem

I am closing this discussion due to inactivity.

View solution in original post


All Replies
Solution
‎05-01-2013 08:09 PM
Frequent Contributor
Posts: 88

Re: Proc ARIMA fitting problem

I am closing this discussion due to inactivity.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 209 views
  • 0 likes
  • 1 in conversation