master data:文件名 hgm2001.dta
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input float panelid int year strL name str21 area str11 zip str21 phone
- 1 2001 "无锡市第二齿轮厂" "0510" "" "515806"
- 2 2001 "长春石材股份合作公司" "0431" "130103" "515034"
- 4 2001 "四会市罗源水泥厂" "0758" "" "738282"
- 6 2001 "上海拆车厂" "021" "" "692318"
- 7 2001 "南阳希望饲料有限责任公司" "0377" "473000" "555762"
- 10 2001 "重庆润丰纺织机械有限公司" "023" "401321" "271548"
- 11 2001 "福州市饲料工业公司" "0591" "" "614820"
- 12 2001 "宁波金鱼电器有限公司" "0574" "315613" "186319"
- 13 2001 "中山市恒发染织厂有限公司" "0760" "" "807811"
- 15 2001 "汾阳市晋阳钢铁公司" "0575" "" "222369"
- 19 2001 "新会市会城镇城西羽绒服装厂" "0750" "" "695361"
- 20 2001 "阳江市阳春市春磷化工有限公司" "0662" "" "732471"
- 22 2001 "北京铁路伊捷瑞技术开发公司" "010" "" "241044"
- 26 2001 "开原市中固电熔镁厂" "0410" "112319" "371067"
- 27 2001 "扬州金利机械有限责任公司" "0514" "225006" "236054"
- 29 2001 "津市市经纶绢麻纺织有限公司" "0736" "" "211396"
- 30 2001 "美而光(深圳)有限公司" "0755" "518109" "700648"
- 35 2001 "黄梅县粮油总公司饲料工贸公司" "0713" "" "321358"
- 36 2001 "常州市江南塑料集团" "0519" "" "231280"
- 40 2001 "金坛华金机械有限公司" "0519" "" "822163"
- 42 2001 "扬州玩具三厂" "0514" "225007" "345403"
- 43 2001 "温州市瓯海氟硅实业公司" "0577" "" "362236"
- 44 2001 "唐山钢铁集团金恒企业发展总公司福利总厂" "0315" "63016" "703301"
- 46 2001 "国营广元织布厂" "0839" "" "223257"
- 47 2001 "四会市恒生实业有限公司(工业)" "0758" "" "283929"
- 49 2001 "福建省泉州市闽东南地质大队印刷厂" "0595" "" "685506"
- 50 2001 "广西壮族自治区南宁肉类联合加工厂" "0771" "530003" "820538"
- 52 2001 "马钢江东企业公司第四轧钢厂" "0574" "" "882480"
- 53 2001 "铜仁市酒厂" "0856" "" "230544"
- 54 2001 "南通华宁工艺服装有限公司" "0513" "" "890341"
- end
using data: 文件名 hg2001_1.dta
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input int year byte month str48 name str9 zip str6 phone double valperunit
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23999999463558197
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23999999463558197
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .30000001192092896
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .260305255651474
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .3199999928474426
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .30589449405670166
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .5672250390052795
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .2308020442724228
- 2001 1 "中国包装国际贸易公司" "100020" "818020" 46.28545379638672
- 2001 1 "中国包装国际贸易公司" "100020" "818020" 1.8529132604599
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .10999968647956848
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .33594653010368347
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .24002398550510406
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23016194999217987
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23435750603675842
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .36500000953674316
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23999612033367157
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .509998619556427
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23999737203121185
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23999999463558197
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .2199767380952835
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .20994850993156433
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .30000001192092896
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .20998333394527435
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .746268630027771
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .8695651888847351
- 2001 1 "中国包装国际贸易公司" "100020" "818020" 4.876404285430908
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .23616264760494232
- 2001 1 "中国包装国际贸易公司" "100020" "818020" .22002002596855164
- 2001 1 "中丝生丝进出口公司" "100006" "222507" 30
- end
已有代码:
- use hgm2001.dta,replace
- drop if mi(panelid)
- drop if mi(name)
- duplicates drop name,force
- duplicates report name
- merge 1:m name using hg2001_1.dta, keepusing(month valperunit companytype )
我自己运行上述代码,得到的结果是
- . duplicates drop name,force
- Duplicates in terms of name
- (0 observations are duplicates)
- . duplicates report name
- Duplicates in terms of name
- --------------------------------------
- copies | observations surplus
- ----------+---------------------------
- 1 | 156694 0
- --------------------------------------
- . merge 1:m name using hg2001_1.dta, keepusing(month valperunit companytype)
- variable name does not uniquely identify observations in the master data
- r(459);
因为是截取的数据,所以样本数据可能互相无法匹配,也不确定能不能出现我描述的报错。但是还是把需要的东西放上来(为避免某些不必要的回复),求各位指导。谢谢!