I'm having +4000 periods and corresponding measurement for that period. I'd like to create a time series, but also need to add data for some missing periods. I know the corresponding value is 0 in that case.
Is there an efficient way to add these missing cases to SPSS? And preferably only using SPSS? With other tools I can manage, but can't imagine there's no feature in SPSS that handles this (without the need to import/export to something else).
Eg. I have:
Date - Count
2006/01/01 - 12
2006/01/02 - 4
2006/01/04 - 10
Where I need:
Date - Count
2006/01/01 - 12
2006/01/02 - 4
2006/01/03 - 0
2006/01/04 - 10