我的问题是想实现gdp数据的更新,由于是从不同库中得到的数据所以按地名排序不同(且有缺漏值),所以想能不能通过判断地名是否一致再将gdp2016赋值给gdp。数据节选如下(以dataex导出):
- input str33 place long ppp str24 place_province int number double gdp str21 place1 double gdp2016
- "兰州市" 2100000 "甘肃省" 8 . "" .
- "嘉峪关市" 2500000 "甘肃省" 36 . "嘉峪关市" 153.41
- "天水市" 938611 "甘肃省" 10 . "金昌市" 207.82
- "定西市" 2800000 "甘肃省" 66 . "白银市" 442.21
- "平凉市" 1500000 "甘肃省" 18 . "天水市" 590.51
- "庆阳市" 5900000 "甘肃省" 23 . "武威市" 461.73
- "张掖市" 2400000 "甘肃省" 27 . "张掖市" 399.94
- "武威市" 5900000 "甘肃省" 63 . "平凉市" 367.3
- "甘南藏族自治州" 5100000 "甘肃省" 18 . "酒泉市" 577.93
- "甘肃省本级" 13000000 "甘肃省" 10 . "庆阳市" 597.83
- "白银市" 7300000 "甘肃省" 99 . "定西市" 331.08
- "酒泉市" 1500000 "甘肃省" 41 . "陇南市" 339.89
- "金昌市" 84040 "甘肃省" 7 . "临夏回族自治州" 230.11
- "陇南市" 453727 "甘肃省" 15 . "甘南市" 135.95
- "东莞市" 4400000 "广东省" 5 . "" .
- "中山市" 1900000 "广东省" 6 . "" .
复制代码
自己想的命令如下:
- forvalues i= 31/46 {
- 2. forvalues j = 31/46 {
- 3. replace gdp[`j'] = gdp2016[`i'] if place[`j'] == place1[`i']
- 4. }
- 5. }
复制代码
但是结果是error:weights not allowed