Dropping panel members which don't have consecutive observations of dependent variable

[Josh Dyson]

I have a panel data set of UK firms from 1990-2015. How do I drop panel firms that don't have at least 3 consecutive observations of my dependent variable (capx)?

[Nick Cox]

See the FAQ https://www.stata.com/support/faqs/d...-observations/ for how to generate a variable holding the maximum run length, which lets you drop panels that are too fragmentary.