Hello all,
I have Var1, which is postal codes, and Var2, dissemination area codes, for which there are multiple dissemination areas assigned to each postal code. I also have Var 3, which is the total population of each dissemination area.
I would like to choose and only keep the most populous dissemination area for each postal code. In other words, I'd like to remove repeated values in my postal code variable, keeping only the postal code which corresponds to the most populous dissemination area.
Note also that some dissemination areas are also repeated among different postal codes; the same dissemination area may be found to be the most populous for multiple postal codes.
Any help greatly appreciated, thank you.
Related Posts with Choosing the highest value of a variable in each category corresponding to another variable
Exporting tabulation from stata to excel including a column with and another without value labelsHi All, I'd like to export a simple descriptive frequency table from stata to excel. My variable is…
Should i use fixed effects or random effects for my paneldata ??Hello, I am currently writing a thesis on democratization in Latin America and the Caribbean. I have…
Changing the level of significance in CorrelationDear all, I would like to get an excel output related to correlation analysis. I ran the following c…
Problem with panel data - data that is on different columns to be on the same row to stop duplications.Dear all, I am attempting to manipulate the panel data as time series data using the command: ‘tsse…
Partial dependence plotsHello, I'd like to ask if partial dependence plots are available in stata and how to get it? https:/…
Subscribe to:
Post Comments (Atom)
0 Response to Choosing the highest value of a variable in each category corresponding to another variable
Post a Comment