你怎能不爱 Stata (2): 2019.02.22

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

• 这个是从这里来的：https://bbs.pinggu.org/forum.php ... ;page=1#pid57044671。
• 其问题：以进出口为例，A对B的出口恰好就是B对A的进口，所以按照贸易顺差/逆差来看的话A国和B国的对外贸易差额绝对值其实是一样的。现在我希望保留唯一的配对（比如B-A和A-B视为一对），请问在stata里面要怎么操作才能实现啊？
• 资料与程序 (感谢 Romalpa Akzo 的 brilliant 建议)：
  1. // https://bbs.pinggu.org/forum.php?mod=viewthread&tid=6935068&page=1#pid57044671
     
  2. * Example generated by -dataex-. To install: ssc install dataex
     
  3. clear
     
  4. input str3(origin dest) float(index_bilateral year)
     
  5. "CHN" "BGR"  25.245697 2010
     
  6. "CHN" "RUS" -.26786003 2004
     
  7. "CHN" "IND"   15.62117 2008
     
  8. "CHN" "IND"   6.619596 2006
     
  9. "CHN" "CYP"   65.14904 2003
     
  10. "CHN" "PRT"  28.602924 2011
      
  11. "CHN" "BGR"  16.159151 2013
      
  12. "CHN" "EST"   43.11666 2012
      
  13. "CHN" "MLT"   47.30183 2008
      
  14. "CHN" "LVA"   51.74584 2005
      
  15. "CHN" "IDN"  16.247213 2014
      
  16. "CHN" "CZE"  34.753216 2008
      
  17. "CHN" "HUN"   37.37414 2000
      
  18. "CHN" "KOR"  -18.88718 2001
      
  19. "CHN" "CZE"  17.311008 2013
      
  20. "CHN" "RUS"   5.484401 2005
      
  21. "CHN" "EST"   42.96254 2006
      
  22. "CHN" "TUR"   50.51025 2014
      
  23. "CHN" "LTU"   48.40796 2006
      
  24. "CHN" "LTU"   50.13712 2008
      
  25. "CHN" "CZE"  24.503586 2011
      
  26. "CHN" "KOR"   -26.1602 2013
      
  27. "CHN" "SVK"  -4.946331 2013
      
  28. "CHN" "IDN"  -9.215469 2001
      
  29. "CHN" "MEX"   58.31996 2004
      
  30. "CHN" "HUN"   42.35766 2003
      
  31. "CHN" "KOR"   -27.2578 2004
      
  32. "CHN" "POL"   35.22688 2012
      
  33. "CHN" "CYP"   52.51056 2012
      
  34. "CHN" "RUS"  -23.19418 2000
      
  35. "CHN" "CYP"   57.22584 2004
      
  36. "CHN" "SVK"  35.143818 2001
      
  37. "CHN" "BGR"   48.62837 2000
      
  38. "CHN" "RUS"  23.311113 2010
      
  39. "CHN" "TUR"   40.50524 2010
      
  40. "CHN" "SVK"  24.040916 2006
      
  41. "CHN" "RUS"  25.840374 2008
      
  42. "CHN" "MEX"   57.34701 2005
      
  43. "CHN" "SVK"  4.5704594 2010
      
  44. "CHN" "CYP"   63.87872 2009
      
  45. "CHN" "LVA"    41.2198 2004
      
  46. "CHN" "KOR"  -23.98084 2012
      
  47. "CHN" "MLT"   26.56485 2002
      
  48. "CHN" "BEL"   4.807569 2003
      
  49. "CHN" "TUR"   51.87334 2008
      
  50. "CHN" "GRC"   48.62494 2013
      
  51. "CHN" "IDN" -.51416165 2012
      
  52. "CHN" "CZE"  14.584755 2014
      
  53. "CHN" "HUN"  34.845596 2002
      
  54. "CHN" "POL"  32.281773 2001
      
  55. "CHN" "CZE"   26.69204 2010
      
  56. "CHN" "MLT"   60.83664 2014
      
  57. "CHN" "PRT"   43.49453 2007
      
  58. "CHN" "IDN"    7.19298 2008
      
  59. "CHN" "GRC"   55.29412 2010
      
  60. "CHN" "EST"   58.36507 2002
      
  61. "CHN" "HUN"   27.52004 2006
      
  62. "CHN" "SVN"   39.25492 2007
      
  63. "CHN" "SVN"  32.444096 2010
      
  64. "CHN" "SVK"  -4.403139 2014
      
  65. "CHN" "SVK"  4.2479577 2003
      
  66. "CHN" "LTU"   48.02407 2007
      
  67. "CHN" "KOR" -26.778866 2010
      
  68. "CHN" "BRA" -16.774914 2001
      
  69. "CHN" "PRT"  22.120983 2014
      
  70. "CHN" "POL"   34.62191 2002
      
  71. "CHN" "CYP"   68.21292 2002
      
  72. "CHN" "CZE"  24.281513 2002
      
  73. "CHN" "BRA" -24.257875 2002
      
  74. "CHN" "HUN"  -.3747167 2010
      
  75. "CHN" "HUN"   26.74776 2008
      
  76. "CHN" "BGR"   68.55055 2006
      
  77. "CHN" "MEX"   53.34143 2014
      
  78. "CHN" "BGR"   44.87311 2003
      
  79. "CHN" "HRV"   6.029083 2002
      
  80. "CHN" "LTU"  21.262976 2001
      
  81. "CHN" "KOR" -24.096216 2014
      
  82. "CHN" "KOR"  -6.164859 2008
      
  83. "CHN" "GRC"   64.14749 2007
      
  84. "CHN" "SVK"  25.626314 2005
      
  85. "CHN" "LVA"   60.10111 2007
      
  86. "CHN" "TUR"   54.39251 2006
      
  87. "CHN" "BGR"   58.43769 2001
      
  88. "CHN" "IDN"  -9.743893 2002
      
  89. "CHN" "POL"   40.53851 2009
      
  90. "CHN" "BGR"   61.54499 2008
      
  91. "CHN" "LVA"  30.358263 2001
      
  92. "CHN" "HUN"  -1.405918 2012
      
  93. "CHN" "IDN"  -2.970981 2007
      
  94. "CHN" "HUN"   5.198897 2014
      
  95. "CHN" "CZE"  28.565166 2006
      
  96. "CHN" "LTU"   21.54196 2002
      
  97. "CHN" "EST"   68.44804 2001
      
  98. "CHN" "BEL"   3.225987 2013
      
  99. "CHN" "SVN"  34.447018 2011
      
  100. "CHN" "RUS"  11.041714 2006
       
  101. "CHN" "LTU"  33.574306 2009
       
  102. "CHN" "MEX"    62.5219 2006
       
  103. "CHN" "HRV" -12.727107 2000
       
  104. "CHN" "SVN"   27.55047 2001
       
  105. "BEL" "CHN"   .8011382 2012
       
  106. "BEL" "CHN"   -13.3949 2004
       
  107. "BEL" "CHN" -15.197672 2000
       
  108. "BEL" "CHN"  -4.807569 2003
       
  109. "BEL" "CHN"  -22.55604 2006
       
  110. "BEL" "CHN"  -3.225987 2013
       
  111. "BEL" "CHN"  -11.47142 2009
       
  112. "BEL" "CHN"   .9251509 2002
       
  113. "BEL" "CHN"  -9.647018 2001
       
  114. "BEL" "CHN"  -4.850701 2014
       
  115. "BEL" "CHN"  -7.969518 2010
       
  116. "BEL" "CHN" -21.128284 2007
       
  117. "BEL" "CHN" -18.861422 2005
       
  118. "BEL" "CHN"  -5.933108 2011
       
  119. "BEL" "CHN"  -25.02423 2008
       
  120. "BGR" "CHN"  -58.43769 2001
       
  121. "BGR" "CHN"  -46.04298 2009
       
  122. "BGR" "CHN" -25.245697 2010
       
  123. "BGR" "CHN"  -56.58496 2005
       
  124. "BGR" "CHN"  -68.55055 2006
       
  125. "BGR" "CHN"  -46.10373 2004
       
  126. "BGR" "CHN" -16.159151 2013
       
  127. "BGR" "CHN"  -61.54499 2008
       
  128. "BGR" "CHN"  -48.62837 2000
       
  129. "BGR" "CHN"  -22.00906 2011
       
  130. "BGR" "CHN"  -47.20781 2002
       
  131. "BGR" "CHN" -17.001524 2014
       
  132. "BGR" "CHN"  -59.63894 2007
       
  133. "BGR" "CHN"  -21.91966 2012
       
  134. "BGR" "CHN"  -44.87311 2003
       
  135. "BRA" "CHN"  24.257875 2002
       
  136. "BRA" "CHN"  13.162673 2011
       
  137. "BRA" "CHN"  15.624968 2000
       
  138. "BRA" "CHN"  28.500885 2003
       
  139. "BRA" "CHN"   5.904176 2010
       
  140. "BRA" "CHN"  16.774914 2001
       
  141. "BRA" "CHN"  18.910135 2005
       
  142. "BRA" "CHN"   6.474211 2007
       
  143. "BRA" "CHN"   10.03562 2006
       
  144. "BRA" "CHN"   9.583493 2012
       
  145. "BRA" "CHN" -1.0021992 2008
       
  146. "BRA" "CHN"   4.442032 2013
       
  147. "BRA" "CHN"  21.865746 2004
       
  148. "BRA" "CHN"  11.803807 2009
       
  149. "BRA" "CHN" -2.3279502 2014
       
  150. "CYP" "CHN"  -68.21292 2002
       
  151. "CYP" "CHN"  -73.69014 2007
       
  152. "CYP" "CHN"  -66.83552 2006
       
  153. "CYP" "CHN"  -66.31237 2000
       
  154. "CYP" "CHN"  -57.22584 2004
       
  155. "CYP" "CHN"  -49.63297 2013
       
  156. "CYP" "CHN"  -58.10071 2001
       
  157. "CYP" "CHN"  -68.57891 2010
       
  158. "CYP" "CHN"   -63.3471 2005
       
  159. "CYP" "CHN"  -54.56297 2014
       
  160. "CYP" "CHN"  -71.86724 2008
       
  161. "CYP" "CHN"  -63.87872 2009
       
  162. "CYP" "CHN"  -52.51056 2012
       
  163. "CYP" "CHN"  -59.69622 2011
       
  164. "CYP" "CHN"  -65.14904 2003
       
  165. "CZE" "CHN" -24.281513 2002
       
  166. "CZE" "CHN" -34.032505 2007
       
  167. "CZE" "CHN" -14.584755 2014
       
  168. "CZE" "CHN" -17.311008 2013
       
  169. "CZE" "CHN" -17.492489 2001
       
  170. "CZE" "CHN"  -27.75855 2005
       
  171. "CZE" "CHN" -28.565166 2006
       
  172. "CZE" "CHN" -34.753216 2008
       
  173. "CZE" "CHN"  -23.58339 2004
       
  174. "CZE" "CHN" -11.225542 2000
       
  175. "CZE" "CHN"  -26.69204 2010
       
  176. "CZE" "CHN" -24.503586 2011
       
  177. "CZE" "CHN" -24.731274 2003
       
  178. "CZE" "CHN"  -28.88364 2009
       
  179. "CZE" "CHN" -19.054138 2012
       
  180. "EST" "CHN"  -39.77054 2005
       
  181. "EST" "CHN"  -39.66985 2014
       
  182. "EST" "CHN"  -42.98664 2008
       
  183. "EST" "CHN"  -42.96254 2006
       
  184. "EST" "CHN"  -58.36507 2002
       
  185. "EST" "CHN" -28.522646 2009
       
  186. "EST" "CHN"  -68.44804 2001
       
  187. "EST" "CHN"  -49.15324 2003
       
  188. "EST" "CHN"  -32.25482 2010
       
  189. "EST" "CHN" -30.581184 2013
       
  190. "EST" "CHN"  -42.99669 2000
       
  191. "EST" "CHN" -36.860653 2011
       
  192. "EST" "CHN"  -47.77432 2007
       
  193. "EST" "CHN"  -44.49921 2004
       
  194. "EST" "CHN"  -43.11666 2012
       
  195. "GRC" "CHN"  -65.65321 2008
       
  196. "GRC" "CHN"  -53.34895 2001
       
  197. "GRC" "CHN"  -47.14865 2003
       
  198. "GRC" "CHN"  -44.98263 2012
       
  199. "GRC" "CHN"  -50.84057 2014
       
  200. "GRC" "CHN"  -50.93797 2002
       
  201. "GRC" "CHN"  -55.27709 2006
       
  202. "GRC" "CHN" -37.631474 2004
       
  203. "GRC" "CHN"  -55.29412 2010
       
  204. "GRC" "CHN"  -53.39635 2011
       
  205. end
       
  206. 
       
  207. // Romalpa Akzo
       
  208. gen pair = cond(origin<dest,origin+"-"+dest,dest+"-"+origin)
       
  209. bys year pair (origin): keep if _n==1

  复制代码
  
  

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏5 回帖

关键词：Stata tata generated BILATERAL Brilliant

筛选数据的好命令，多谢黄老师分享

yuqr1986 发表于 2019-2-23 14:08
筛选数据的好命令，多谢黄老师分享

我第一次知道，文字可以比"大小"!

后来我发现可以更精简

1. keep if origin<dest

复制代码