Hello,

I have a dataset where each row corresponds to a specific interval during which an event occurred (the day the event occurred is captured by the variable, "intlag," which can take on values 1-180 corresponding to the 180 days during which the person was followed). I also have 180 day variables (day1, day2, day3 etc) that can take on values 0, 1, 2, 3, or 7. I am interested in finding the first "1" that occurs after the event date (so the number of days between the day specified by intlag and the first "1").

I have included a dataex example below. Here, person 1000048 has an event date of 10 and then the next "1" does not occur until day23. I am looking for a variable that would give me the value "13" for this row.

Any help is much appreciated!

Sarah

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long pid float intlag byte(day1 day2 day3 day4 day5 day6 day7 day8 day9 day10 day11 day12 day13 day14 day15 day16 day17 day18 day19 day20 day21)
1000008 112 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 1 0 0
1000008 128 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 1 0 0
1000048  10 0 0 0 0 1 1 1 2 2 2 0 2 2 2 2 2 2 2 2 7 0
1000048  20 0 0 0 0 1 1 1 2 2 2 0 2 2 2 2 2 2 2 2 7 0
1000048  80 0 0 0 0 1 1 1 2 2 2 0 2 2 2 2 2 2 2 2 7 0
1000048  83 0 0 0 0 1 1 1 2 2 2 0 2 2 2 2 2 2 2 2 7 0
1000063  18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 2 0 1 1
1000063 145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 2 0 1 1
1000081  68 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0
1000081 113 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0
1000089  30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0
1000098 175 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
1000111  92 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1
1000115 136 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000130  32 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000130 144 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000157  68 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 0
1000157 103 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 0
1000157 118 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 0
1000157 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 0
1000160  21 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 4
1000160 118 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 4
1000180  70 0 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 1 1 0
1000213  16 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 7 0 0 0 0 0
1000213  53 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 7 0 0 0 0 0
1000213 136 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 7 0 0 0 0 0
1000271   3 0 0 6 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0
1000271  24 0 0 6 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0
1000271  31 0 0 6 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0
1000271  58 0 0 6 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0
1000271  83 0 0 6 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0
1000296  54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1
1000312 145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000319  17 0 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 4 0 0 0 0
1000319 125 0 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 4 0 0 0 0
1000319 138 0 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 4 0 0 0 0
1000319 173 0 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 4 0 0 0 0
1000334  43 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0
1000334  55 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0
1000334  87 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0
1000334 136 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0
1000334 173 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0
1000346  31 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 1 1 1 1 1
1000354  37 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 2 7 2 2 2
1000354  73 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 2 7 2 2 2
1000385  20 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 0
1000385 124 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 0
1000385 131 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 0
1000390 163 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
1000391 144 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 1 0 0 1 1
1000391 164 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 1 0 0 1 1
1000399  31 0 0 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1000399  49 0 0 0 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1000434  79 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000434  88 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000434 111 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000434 162 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000441  55 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000441  61 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000488  23 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 2 2 2
1000488  67 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 2 2 2
1000512  43 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
1000512  85 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
1000512 100 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
1000512 107 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
1000525 143 0 0 0 0 0 0 0 1 0 1 1 1 1 1 1 1 1 1 1 0 1
1000549  12 0 0 0 0 0 0 1 1 1 2 2 2 1 0 0 1 1 1 1 1 1
1000549 150 0 0 0 0 0 0 1 1 1 2 2 2 1 0 0 1 1 1 1 1 1
1000598  31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598  47 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598  61 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598  69 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598 109 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598 114 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598 126 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598 164 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000598 176 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1000627   3 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627  12 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627  21 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627  31 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627  37 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627  76 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627  99 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627 139 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000627 175 0 0 6 0 0 0 0 0 2 2 2 2 0 0 0 0 2 2 2 2 2
1000653  70 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1
1000679 154 0 0 0 0 0 0 0 0 1 0 0 1 1 1 1 1 1 1 1 0 1
1000698  19 0 0 0 0 0 0 0 0 1 0 1 1 0 0 1 1 0 1 4 1 1
1000698  45 0 0 0 0 0 0 0 0 1 0 1 1 0 0 1 1 0 1 4 1 1
1000698  70 0 0 0 0 0 0 0 0 1 0 1 1 0 0 1 1 0 1 4 1 1
1000698  84 0 0 0 0 0 0 0 0 1 0 1 1 0 0 1 1 0 1 4 1 1
1000740  38 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1000740 138 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1000742 157 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1 0 1
1000742 163 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1 0 1
1000796  13 0 0 1 1 1 1 1 1 1 1 2 2 7 0 0 1 1 1 1 2 2
1000796  24 0 0 1 1 1 1 1 1 1 1 2 2 7 0 0 1 1 1 1 2 2
1000796  52 0 0 1 1 1 1 1 1 1 1 2 2 7 0 0 1 1 1 1 2 2
end