I want to use tsfill to generate daily time between each spell from the first date (t0) and ending at the end date (t1) of the spell.
I can't seem to find an option for tsfill to end at the last date for each spell, the command just fills daily dates until the next id.
For instance, for id=1 and spell=1 I want to have dates generated from 06feb2012 and end at 27sep2012, and for id=1 spell=2 to have dates filled only from 10oct2012 to 09dec2012...
is this possible with tsfill?
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int id float(spell t0 t1) 1 1 19029 . 1 1 . . 1 1 . . 1 1 . . 1 1 . 19263 1 2 19276 19336 1 3 19343 . 1 3 . . 1 3 . . 1 3 . 19493 1 4 19495 . 1 4 . 19612 2 1 19036 19096 2 2 19121 19181 2 3 19185 . 2 3 . . 2 3 . . 2 3 . . 2 3 . 19387 2 4 19394 . 2 4 . . 2 4 . 19474 2 5 19482 . 2 5 . 19567 2 6 19588 19648 2 7 19674 . 2 7 . . 2 7 . 19778 2 8 19804 . 2 8 . 19875 2 9 19887 19947 2 10 19967 . 2 10 . 20033 2 11 20063 . 2 11 . . 2 11 . 20174 2 12 20202 . 2 12 . . 2 12 . 20316 2 13 20346 . 2 13 . 20453 2 14 20462 . 2 14 . 20525 2 15 20537 . 2 15 . . 2 15 . 20652 3 1 19455 . 3 1 . 19516 3 2 19543 19603 3 3 19631 19691 3 4 19706 . 3 4 . 19802 3 5 20008 . 3 5 . . 3 5 . 20118 3 6 20309 20369 3 7 20371 20431 3 8 20449 . 3 8 . . 3 8 . . 3 8 . . 3 8 . . 3 8 . . 3 8 . 20747 4 1 20620 . 4 1 . . 4 1 . 20723 4 2 20746 20806 5 1 19016 . 7 1 19015 . 7 1 . . 7 1 . 19141 7 2 19151 19211 7 3 19221 . 7 3 . 19308 7 4 19328 . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . . 7 4 . 19757 7 5 19763 . 7 5 . . 7 5 . . 7 5 . . 7 5 . . 7 5 . . 7 5 . . 7 5 . 20099 7 6 20123 20183 7 7 20209 20269 7 8 20270 20330 9 1 19068 19128 end format %td t0 format %td t1
0 Response to tsfill for time series data, ending fill at specific dates by subgroups
Post a Comment