Dear Statalist,

I am a new user of Stata and I use it for my master thesis. I have created a dataset of European firms for the years 2006-2015. The number of observations is 3.136.622, but not every firm reported every year. My goal is to keep only the firms that reported their financials for the whole 10-year period and drop everything else. An idea I had was to create a dummy and then sum the total of the dummies for every company, and then say "drop if dummy<10" but cannot get it right. I upload a screenshot with the dataset. Could you help me with the coding? Any working solution is welcome.

Thank you in advance!

Array