I have a dataset in which the data are identified by state, county, and ZIP code - each of these is a different variable.
My problem is that some ZIP codes span over more than one county, so I need to be able to identfy which observation of the variable "ZIP: have different values on the variable "county". Fow example, below, I need to be able to identify that 00112 is a ZIP that has different values (1 and 2) on the variable "county", because it spans across two counties:
County - ZIP
1 - 00111
1 - 00112
2 - 00112
2 - 00113
2 - 00114
What code would allow me to do that for the entire dataset? Thank you in advance!
Related Posts with Identifying observations of var1 that have different values for var2
Weighted average means in a rolling fashionHi I am not sure how to calculate weighted average means in a rolling fashion. I can only calculat…
Testing for structural break: Contradicting resultsI am analyzing prices data using ARIMA model. Stata's video clip availabel at https://www.youtube.co…
How to construct data for survival analysis?Dear Statalist members, I manually constructed duration data for survival analysis. However, I coul…
How to make a graph with confident intervals?Dear all, I would like to make a graph of several concentration indices and their confident interva…
Loop for weighted medianGood morning, I have a dataset containing indicators for each country for each election year. The in…
Subscribe to:
Post Comments (Atom)
0 Response to Identifying observations of var1 that have different values for var2
Post a Comment