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
Problem with correcting a heteroskedasticity and serial correlation on panel data with fixed effect- identify repeated observation within variable by id
- Declaring data to be time-series data
- Multinomial logit models and vce(cluster) option. How to study the within group variance
- Which test for between multiple groups and frequencies?
Subscribe to:
Post Comments (Atom)
0 Response to Drop or Keep Observations by title
Post a Comment