This is an example of the data I have. ID date obs 100 01Jan2014 45 100 02Jan2014 74 100 03Jan2014 . 100 04Jan2014 . 100 05Jan2014 20 100 06Jan2014 43 100 07Jan2014 23 100 08Jan2014 . 100 09Jan2014 456 100 10Jan2014 23 200 01Jan2014 . 200 02Jan2014 . 200 03Jan2014 . 200 04Jan2014 . 200 05Jan2014 42 200 06Jan2014 56 200 07Jan2014 32 200 08Jan2014 . 200 09Jan2014 32 200 10Jan2014 . 300 01Jan2014 556 300 02Jan2014 . 300 03Jan2014 . 300 04Jan2014 . 300 05Jan2014 . 300 06Jan2014 . 300 07Jan2014 . 300 08Jan2014 52 300 09Jan2014 12 300 10Jan2014 45 I want output that reports each occasion of missing values (coded as '.') for the variable obs. Each observation in the output dataset should represent an occasion when obs is missing for either a single day or consecutive days. Each observation in the new output needs to include the ID variable, a variable that identifies the occassion of missing data and the number of consecutive days that obs was missing. So the new count variable should equal 1 for single day of missing data or >1 for consecutive days of missing data. Thank you in advance for any help you can offer on this problem.
... View more