I have panel data for 850 companies between 2001 and 2019. In case a company had revenue < USD 100 million in any of the years, I would like to categorise it as an SME (Small and Medium Enterprise.) Is there any suitable command in STATA for doing this? (Please note that even if in one of the years between 2001 and 2019 the revenue was < USD 100 MM, I would like to categorise the company as SME and exclude it in my analysis.)
Thanks very much.