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
putexcel problem with double replace and local macrosI think this is probably a bug report, but I'll just show what happens and let others decide. Mostly…
Counting those in the same category as you, by groupDear all, Please take a look at the attached screenshot of a dummy dataset. How do I generate a var…
Moderating impactDear Statalist, Actually, I am bit confused between the joint effect and the moderating impact. I me…
Identifying events within a future time windowDear Statalist users -- Assume that we have the following toy example: Code: input firm_id year ev…
Multiple response analysisDear Experts I have been trying to analyse COVID-19 related data where each subject submits reports…
Subscribe to:
Post Comments (Atom)
0 Response to Drop or Keep Observations by title
Post a Comment