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
Related Posts with Drop or Keep Observations by title
Regressions by industry - quarterDear users, I hope that you may help me with the following issue. I'm running regressions by indust…
Firthlogit, marginal effects and interactionsDear all, I tried to run a logit model with an interaction effect which unfortunately does not work…
Hypothesis testing between regression coefficientsHi everyone! So I created this regression table using the following commands Code: areg logincome l…
Stata coding (DID, Event study and Triple differences)Hello! I am doing DID, Event study and Triple differences, but it is not easy for me to make the ri…
Change label, color, and font for "by(category)" graphDear Statalist user, I use a very similar visualization to this: Code: use https://www.stata-pres…
Subscribe to:
Post Comments (Atom)
0 Response to Drop or Keep Observations by title
Post a Comment