topic Re: Procx12 question in SAS Forecasting and Econometrics

Procx12 question

Johnsewell22 — Mon, 30 Oct 2017 16:27:16 GMT

Hello,

I am trying to do a seasonal adjustment on a data set using procX12. My error is as follows:

ERROR: Interval of date variable does not match INTERVAL=YEAR

The data set is an excel document that was properly imported (I know this because I have made a time series plot with the data).

The year is a 4 digit year such as 1999.

My code is as follows:

data seasonlogsun;
set logsunspots;
date=year;
format date Year;
run;

proc x12 data=seasonlogsun date=date interval=year;
var logsun;
x11;
ods select d11;
run;

Any help would be greatly appreciated.

Re: Procx12 question

solarflare — Mon, 30 Oct 2017 18:31:23 GMT

Hello,

To clarify, are your date variable values before formatting are something like 01JAN1999, 01JAN2000, 01JAN2001, ... ?

In other words, does the date variable contain month and day information that is consistent and the interval of that data is one year? If you have monthly data then it would need to be accumulated yearly first using proc timedata.

A sample of the data before formatting would be helpful

Re: Procx12 question

Johnsewell22 — Mon, 30 Oct 2017 18:46:04 GMT

The data are in 4 digit year format

1700

1701

1702

2004

Re: Procx12 question

solarflare — Mon, 30 Oct 2017 19:17:24 GMT

I think the problem is that your input is not in a SAS date format in which the numeric value represents the number of days since Jan 1, 1960. So each successive year is being interpreted as the next day rather than the next year.

To input the data correctly you need to use an informat.

Try using date = mdy (1,1,year); in your data step instead of date = year;

EDIT: In addition, to have the date display correctly, you will want to change your format statement to the following:

format date year4.;