[Gretl-users] Re: finding gaps in daily data
Am 16.03.2022 um 18:38 schrieb Sven Schreiber:
obs: 792, days in sample: 806
missing day-rows: 14
Gretl gets the sample span right and also automatically reverses the
data ordering. Fine! However, how do I find out which were the missing
days? It's a lot of data, and a time series plot doesn't show any gaps.
BTW, this is 7-day-daily. I also tried to use the missing() function,
but that doesn't give me anything different from zero.
OK, here's a workaround that I've found:
series d2 = 1 != diff(epochday($obsmajor,$obsminor,$obsmicro))
Then the series d2 holds 1 (ones) in those places where missing days are
in-between. If you want you can also apply the zeromiss() function on
top to get rid of the zeros, depending on your needs.
cheers
sven