Dear Researchers, hope everyone blessed with healthy life.

I've a column (in Excel) with different unique titles (in textual form) =187,000. The number of total observation of this column is 342,000 (non-structured panel). I want to keep only the top 10 headings that are assigned maximum number of observations in the panel.

i generate the group ID by the following command, but next i don't know how to drop or keep for the top 10 maximum number of observation:

egen id=group( title )

Thanks Researchers and Admin