08-26-2016 06:01 AM
I have a data in such format:
And I want to do seasonal adjustment and just to draw graph with raw data+seasonal adjusted.
However, When my total_nr is less than 100, i have some issues with data variable: "Unable to detremine the interval of Time ID variable" or "Time ID variable contains gaps".
all my data have all months and there is no missing data. everything works when total_nr value is bigger.
Can someone help or explain what is wrong?
09-01-2016 09:44 AM
For which records are you producing errors?
Are you trying to create a date with invalid values like 30FEB2010 or something?
Do you have some sample code please?
- Cheers -
09-05-2016 03:58 AM
My date variable is in this format monyy7. and the outcome in total_nr represent number or admissions per month.
the code i used is this:
proc x12 data=adm date=date;
output out=adm_seas a1 d10 d11 d12 d13;
when i just plot original series vs seasonal adjusted (this is what i want)
proc sgplot data=adm_seas;
series x=date y=total_nr_a1;
series x=date y=total_nr_d11;
However, then i have small numbers of admissions per month (around 40 to 100 per month), proc x12 does not run.
09-06-2016 04:52 AM
This could be data driven, if you have a large increase of seasonal factors from year to year, check this "identifiable seasonality"
Contact the SAS support, they may be able to confirm why SAS is not running the adjustment when var<100. Unfortunately I can not test by myself.
- Cheers -