I have a dataset with property ID, longitude, latitude, listing date and closing date (sale of property). I would like to assign a cluster/neighbor ID to the houses within 5miles from each other that have been listed on the market within 3 months from each other. I would appreciate if you suggest a code with and without the listing date being within 30-days requirement.
An example of pseudo-data
list id longitude latitude listing_date closing_date in 1/10
+--------------------------------------------------+
| id longitude latitude listin~e closin~e |
|--------------------------------------------------|
1. | 1 -67.24793 105.056 22839 23143 |
2. | 2 20.15248 81.45157 22800 22947 |
3. | 3 157.7826 121.4579 22716 22946 |
4. | 4 85.07596 189.9353 22881 23130 |
5. | 5 -110.7333 167.5668 22862 23151 |
|--------------------------------------------------|
6. | 6 -109.7496 245.5592 22725 22988 |
7. | 7 162.3455 -101.3925 22860 23069 |
8. | 8 -75.43965 -82.76 22714 22893 |
9. | 9 114.8696 -254.7969 22975 23051 |
10. | 10 -4.244534 76.7684 22976 23065 |
+--------------------------------------------------+
Related Posts with Tagging neighborhood houses within timeframe
Adding 'proportion' to esttab command.Dear All, I am estimating a logistic fixed effects regression to estimate the effect of a policy ch…
Update to -iscogen- available from SSCAn update to the iscogen package is now available from SSC. Type Code: . ssc install iscogen, repl…
stata doesn't recognize missings in string variableI want to delete observations that have missing data for a particular variable but stata does not re…
Equivalent of 'exposure' variable for xtlogit regression for diff-in-diffDear All, I am running a logistic FE regression to estimate a the effect of a 'treatment' using a g…
Update to -kmatch- available from SSCA maintenance update to kmatch is now available from SSC. Type Code: . ssc install kmatch, replace…
Subscribe to:
Post Comments (Atom)
0 Response to Tagging neighborhood houses within timeframe
Post a Comment