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

Similar questions and discussions