人大经济论坛 › 论坛 › 计量经济学与统计论坛五区 › 计量经济学与统计软件 › Stata专版 › stata 对于双边数据怎样保留唯一的组合

CDA数据分析研究院

商业数据分析与大数据领航教育品牌



经管云课堂

经管/金融/财会/社科/名师公开课



学术培训

Stata 空间计量 SSCI Python

贵宾：通行论坛特权+数据库权限
+案例库+下载特权 VIP：论坛特权+更多下载次数
+ccerdata数据库+更高阅读权限+……

发帖

楼主: 沉默的烽火

2571 6

[编程问题求助] stata 对于双边数据怎样保留唯一的组合 [推广有奖]

5关注
16粉丝

讲师

31%

还不是VIP/贵宾

威望: 0 级
论坛币: 637 个
通用积分: 40.6493
学术水平: 0 点
热心指数: 2 点
信用等级: 0 点
经验: 625 点
帖子: 149
精华: 0
在线时间: 525 小时
注册时间: 2017-10-17
最后登录: 2022-10-3

楼主

沉默的烽火

发表于 2019-2-21 01:34:18 |只看作者 |坛友微信交流群|倒序 |AI写论文

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

以进出口为例，A对B的出口恰好就是B对A的进口，所以按照贸易顺差/逆差来看的话A国和B国的对外贸易差额绝对值其实是一样的。现在我希望保留唯一的配对（比如B-A和A-B视为一对），请问在stata里面要怎么操作才能实现啊？我自己想了几个方法都不行（比如对A.B分别赋值然后看A+B的值之类的，仔细想想发现不对...）有代码最好（编程苦手，感觉写的命令不简洁），说个思路也可以，请大神指点

出口国	进口国	出口额	贸易差额
A	B	2	-1
A	C	1	1
B	A	3	1
B	C	1	1
C	A	0	-1
C	B	0	-1

扫码加我拉你入群

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

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

分享0 收藏1 回帖

关键词：Stata tata 贸易差额贸易顺差怎么操作

相关帖子

使用道具举报

沙发

黃河泉

发表于 2019-2-21 07:47:38 |只看作者 |坛友微信交流群

你若要问程序，永远附上相关资料；若附上资料，永远用 dataex 印出资料。
1. 先 ssc install dataex (并见说明)，将原始 Stata 资料中具有”代表性”的一部分资料列出，以供有意回答者实验之用，并能提供具体操作指令。
2. 并请参考 http://www.jianshu.com/p/9870080fe769, https://bbs.pinggu.org/thread-5048204-1-1.html, 与 https://bbs.pinggu.org/thread-5917273-1-1.html。

已有 1 人评分	经验	收起理由
葫芦娃大王	+ 10	精彩帖子

总评分: 经验 + 10 查看全部评分

使用道具举报

藤椅

沉默的烽火

发表于 2019-2-21 10:46:47 |只看作者 |坛友微信交流群

黃河泉发表于 2019-2-21 07:47
你若要问程序，永远附上相关资料；若附上资料，永远用 dataex 印出资料。
1. 先 ssc install dataex (并见 ...

黄老师您好，抱歉还没有养成用dataex的习惯，所以之前只是按照想法描述了一下大概数据的形态。
这是用代码截取出来的数据样本，origin就是出口国，dest是目的国，index使我算的一个指数，类似于贸易差额这样的东西。

* Example generated by -dataex-. To install: ssc install dataex
clear
input str3(origin dest) float(index_bilateral year)
"CHN" "BGR" 25.245697 2010
"CHN" "RUS" -.26786003 2004
"CHN" "IND" 15.62117 2008
"CHN" "IND" 6.619596 2006
"CHN" "CYP" 65.14904 2003
"CHN" "PRT" 28.602924 2011
"CHN" "BGR" 16.159151 2013
"CHN" "EST" 43.11666 2012
"CHN" "MLT" 47.30183 2008
"CHN" "LVA" 51.74584 2005
"CHN" "IDN" 16.247213 2014
"CHN" "CZE" 34.753216 2008
"CHN" "HUN" 37.37414 2000
"CHN" "KOR" -18.88718 2001
"CHN" "CZE" 17.311008 2013
"CHN" "RUS" 5.484401 2005
"CHN" "EST" 42.96254 2006
"CHN" "TUR" 50.51025 2014
"CHN" "LTU" 48.40796 2006
"CHN" "LTU" 50.13712 2008
"CHN" "CZE" 24.503586 2011
"CHN" "KOR" -26.1602 2013
"CHN" "SVK" -4.946331 2013
"CHN" "IDN" -9.215469 2001
"CHN" "MEX" 58.31996 2004
"CHN" "HUN" 42.35766 2003
"CHN" "KOR" -27.2578 2004
"CHN" "POL" 35.22688 2012
"CHN" "CYP" 52.51056 2012
"CHN" "RUS" -23.19418 2000
"CHN" "CYP" 57.22584 2004
"CHN" "SVK" 35.143818 2001
"CHN" "BGR" 48.62837 2000
"CHN" "RUS" 23.311113 2010
"CHN" "TUR" 40.50524 2010
"CHN" "SVK" 24.040916 2006
"CHN" "RUS" 25.840374 2008
"CHN" "MEX" 57.34701 2005
"CHN" "SVK" 4.5704594 2010
"CHN" "CYP" 63.87872 2009
"CHN" "LVA" 41.2198 2004
"CHN" "KOR" -23.98084 2012
"CHN" "MLT" 26.56485 2002
"CHN" "BEL" 4.807569 2003
"CHN" "TUR" 51.87334 2008
"CHN" "GRC" 48.62494 2013
"CHN" "IDN" -.51416165 2012
"CHN" "CZE" 14.584755 2014
"CHN" "HUN" 34.845596 2002
"CHN" "POL" 32.281773 2001
"CHN" "CZE" 26.69204 2010
"CHN" "MLT" 60.83664 2014
"CHN" "PRT" 43.49453 2007
"CHN" "IDN" 7.19298 2008
"CHN" "GRC" 55.29412 2010
"CHN" "EST" 58.36507 2002
"CHN" "HUN" 27.52004 2006
"CHN" "SVN" 39.25492 2007
"CHN" "SVN" 32.444096 2010
"CHN" "SVK" -4.403139 2014
"CHN" "SVK" 4.2479577 2003
"CHN" "LTU" 48.02407 2007
"CHN" "KOR" -26.778866 2010
"CHN" "BRA" -16.774914 2001
"CHN" "PRT" 22.120983 2014
"CHN" "POL" 34.62191 2002
"CHN" "CYP" 68.21292 2002
"CHN" "CZE" 24.281513 2002
"CHN" "BRA" -24.257875 2002
"CHN" "HUN" -.3747167 2010
"CHN" "HUN" 26.74776 2008
"CHN" "BGR" 68.55055 2006
"CHN" "MEX" 53.34143 2014
"CHN" "BGR" 44.87311 2003
"CHN" "HRV" 6.029083 2002
"CHN" "LTU" 21.262976 2001
"CHN" "KOR" -24.096216 2014
"CHN" "KOR" -6.164859 2008
"CHN" "GRC" 64.14749 2007
"CHN" "SVK" 25.626314 2005
"CHN" "LVA" 60.10111 2007
"CHN" "TUR" 54.39251 2006
"CHN" "BGR" 58.43769 2001
"CHN" "IDN" -9.743893 2002
"CHN" "POL" 40.53851 2009
"CHN" "BGR" 61.54499 2008
"CHN" "LVA" 30.358263 2001
"CHN" "HUN" -1.405918 2012
"CHN" "IDN" -2.970981 2007
"CHN" "HUN" 5.198897 2014
"CHN" "CZE" 28.565166 2006
"CHN" "LTU" 21.54196 2002
"CHN" "EST" 68.44804 2001
"CHN" "BEL" 3.225987 2013
"CHN" "SVN" 34.447018 2011
"CHN" "RUS" 11.041714 2006
"CHN" "LTU" 33.574306 2009
"CHN" "MEX" 62.5219 2006
"CHN" "HRV" -12.727107 2000
"CHN" "SVN" 27.55047 2001
"BEL" "CHN" .8011382 2012
"BEL" "CHN" -13.3949 2004
"BEL" "CHN" -15.197672 2000
"BEL" "CHN" -4.807569 2003
"BEL" "CHN" -22.55604 2006
"BEL" "CHN" -3.225987 2013
"BEL" "CHN" -11.47142 2009
"BEL" "CHN" .9251509 2002
"BEL" "CHN" -9.647018 2001
"BEL" "CHN" -4.850701 2014
"BEL" "CHN" -7.969518 2010
"BEL" "CHN" -21.128284 2007
"BEL" "CHN" -18.861422 2005
"BEL" "CHN" -5.933108 2011
"BEL" "CHN" -25.02423 2008
"BGR" "CHN" -58.43769 2001
"BGR" "CHN" -46.04298 2009
"BGR" "CHN" -25.245697 2010
"BGR" "CHN" -56.58496 2005
"BGR" "CHN" -68.55055 2006
"BGR" "CHN" -46.10373 2004
"BGR" "CHN" -16.159151 2013
"BGR" "CHN" -61.54499 2008
"BGR" "CHN" -48.62837 2000
"BGR" "CHN" -22.00906 2011
"BGR" "CHN" -47.20781 2002
"BGR" "CHN" -17.001524 2014
"BGR" "CHN" -59.63894 2007
"BGR" "CHN" -21.91966 2012
"BGR" "CHN" -44.87311 2003
"BRA" "CHN" 24.257875 2002
"BRA" "CHN" 13.162673 2011
"BRA" "CHN" 15.624968 2000
"BRA" "CHN" 28.500885 2003
"BRA" "CHN" 5.904176 2010
"BRA" "CHN" 16.774914 2001
"BRA" "CHN" 18.910135 2005
"BRA" "CHN" 6.474211 2007
"BRA" "CHN" 10.03562 2006
"BRA" "CHN" 9.583493 2012
"BRA" "CHN" -1.0021992 2008
"BRA" "CHN" 4.442032 2013
"BRA" "CHN" 21.865746 2004
"BRA" "CHN" 11.803807 2009
"BRA" "CHN" -2.3279502 2014
"CYP" "CHN" -68.21292 2002
"CYP" "CHN" -73.69014 2007
"CYP" "CHN" -66.83552 2006
"CYP" "CHN" -66.31237 2000
"CYP" "CHN" -57.22584 2004
"CYP" "CHN" -49.63297 2013
"CYP" "CHN" -58.10071 2001
"CYP" "CHN" -68.57891 2010
"CYP" "CHN" -63.3471 2005
"CYP" "CHN" -54.56297 2014
"CYP" "CHN" -71.86724 2008
"CYP" "CHN" -63.87872 2009
"CYP" "CHN" -52.51056 2012
"CYP" "CHN" -59.69622 2011
"CYP" "CHN" -65.14904 2003
"CZE" "CHN" -24.281513 2002
"CZE" "CHN" -34.032505 2007
"CZE" "CHN" -14.584755 2014
"CZE" "CHN" -17.311008 2013
"CZE" "CHN" -17.492489 2001
"CZE" "CHN" -27.75855 2005
"CZE" "CHN" -28.565166 2006
"CZE" "CHN" -34.753216 2008
"CZE" "CHN" -23.58339 2004
"CZE" "CHN" -11.225542 2000
"CZE" "CHN" -26.69204 2010
"CZE" "CHN" -24.503586 2011
"CZE" "CHN" -24.731274 2003
"CZE" "CHN" -28.88364 2009
"CZE" "CHN" -19.054138 2012
"EST" "CHN" -39.77054 2005
"EST" "CHN" -39.66985 2014
"EST" "CHN" -42.98664 2008
"EST" "CHN" -42.96254 2006
"EST" "CHN" -58.36507 2002
"EST" "CHN" -28.522646 2009
"EST" "CHN" -68.44804 2001
"EST" "CHN" -49.15324 2003
"EST" "CHN" -32.25482 2010
"EST" "CHN" -30.581184 2013
"EST" "CHN" -42.99669 2000
"EST" "CHN" -36.860653 2011
"EST" "CHN" -47.77432 2007
"EST" "CHN" -44.49921 2004
"EST" "CHN" -43.11666 2012
"GRC" "CHN" -65.65321 2008
"GRC" "CHN" -53.34895 2001
"GRC" "CHN" -47.14865 2003
"GRC" "CHN" -44.98263 2012
"GRC" "CHN" -50.84057 2014
"GRC" "CHN" -50.93797 2002
"GRC" "CHN" -55.27709 2006
"GRC" "CHN" -37.631474 2004
"GRC" "CHN" -55.29412 2010
"GRC" "CHN" -53.39635 2011
end

复制代码

------------------ copy up to and including the previous line ------------------

希望能得到您的指导，谢谢

使用道具举报

板凳

黃河泉

发表于 2019-2-21 11:36:53 |只看作者 |坛友微信交流群

沉默的烽火发表于 2019-2-21 10:46
黄老师您好，抱歉还没有养成用dataex的习惯，所以之前只是按照想法描述了一下大概数据的形态。
这是用代 ...

我帮你问问看!

使用道具举报

报纸

黃河泉

发表于 2019-2-21 15:57:05 |只看作者 |坛友微信交流群

沉默的烽火发表于 2019-2-21 10:46
黄老师您好，抱歉还没有养成用dataex的习惯，所以之前只是按照想法描述了一下大概数据的形态。
这是用代 ...

根据 David Benson 建议，请先 ssc install multencode 并试试

sort origin dest year
bysort origin dest (year): gen n = _n
multencode origin dest, gen(orig_id dest_id)
gen dyad_id = cond(orig_id < dest_id, string(orig_id) + " " + string(dest_id), string(dest_id) + " " + string(orig_id))
egen dyad = group(dyad_id), label
duplicates drop dyad year, force
sort origin dest year

复制代码