--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:/stata17/Replication_paper/Logfile_forReg/Analysis_相关性分析_中心外围指标.txt
  log type:  text
 opened on:  26 Jan 2026, 14:59:24

. 
. ***************
. * Run
. ***************
. 
. 
. use "$DATA\sourcedata\2010popdensity.dta ",clear

. 
. *combine 县区地价
. rename countycode countyid

. merge 1:1 countyid using "$DATA\sourcedata\landprice_countyAdjust.dta"
(variable countyid was long, now double to accommodate using data's values)

    Result                      Number of obs
    -----------------------------------------
    Not matched                           183
        from master                       113  (_merge==1)
        from using                         70  (_merge==2)

    Matched                             2,669  (_merge==3)
    -----------------------------------------

. keep if _merge == 3
(183 observations deleted)

. drop _m

. 
. 
. * combine 全国城市群设定,筛选全国17个城市群样本
. rename countyid countycode

. merge 1:1 countycode using "$DATA\sourcedata\distanceBetweenCounty.dta " //修改地理距离计算：粤港澳城市群双中心

    Result                      Number of obs
    -----------------------------------------
    Not matched                           717
        from master                       652  (_merge==1)
        from using                         65  (_merge==2)

    Matched                             2,017  (_merge==3)
    -----------------------------------------

. keep if _merge == 3
(717 observations deleted)

. drop _merge

. 
. replace km = km - 1 //调整县区到所在中心县区的距离基准点为0，原有数据+ 1km，现在调整回去
(2,017 real changes made)

. rename km distance 

. 
. 
. ********************************************************************************
. ********** 附录表III2 : 计算3个指标间的相关系数
. pwcorr distance popdensity indPrice2010,sig 

             | distance popden~y ind~2010
-------------+---------------------------
    distance |   1.0000 
             |
             |
  popdensity |  -0.2220   1.0000 
             |   0.0000
             |
indPrice2010 |  -0.1053   0.3280   1.0000 
             |   0.0000   0.0000
             |

. 
. 
. 
. *****************
. * close log txt
. *****************
. 
. log close
      name:  <unnamed>
       log:  D:/stata17/Replication_paper/Logfile_forReg/Analysis_相关性分析_中心外围指标.txt
  log type:  text
 closed on:  26 Jan 2026, 14:59:24
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
