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
Destring to decimal numerical variableI am trying to destring a variable to one decimal numerical variable but when I run this command: d…
Help with esttab equations optionI am just getting my feet wet with Latex, and I am trying to use esttab to create Latex tables. When…
best way to "set obs" when the number of obs is not clearly known?Hi Fellow Listers, I am trying to generate a sequence of values based on a numlist from 1 to X in a…
problems with seg package for calculating segregation measuresHi, I am using seg package to calculate different education segregation measures (dissimilarity, ex…
generate new variables ( dividing variable by specific obs) Code: * Example generated by -dataex-. To install: ssc install dataex clear input float(date amzn …
Subscribe to:
Post Comments (Atom)
0 Response to Drop or Keep Observations by title
Post a Comment