st: Forming risksets in matched case control studies

[Nasheed Moqueet <nsmoqueet@gmail.com>]

My exposure and outcome of interest are both binary. The plan is to do
a conditional logistic regression analysis after matching case and
controls on time and ethnicity. My data is stacked and longitudinal
and I am having trouble figuring out how to code for cases.

A case is someone who is clear for atleast 2 successive visits, so two
0s in visits that are next to each other. However, the problem is as
below. Please help. Thanks.

For example, ID 5 and 7 are both cases, even though ID 7's visits are
not strictly successive.
ID visits status
5   3       1
5   4       0
5   5       0
7   2       0
7   4       0

ID 8 is NOT a case, however, because the 0s are not in successive visits

ID visits status
8  1        1
8  2        0
8  5        1
8  6        0
8  7        1
8  8        0
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/