求教大佬们，想知道stata中如何将不同国家间相同的产品类别提取出来

每个国家都是根据其HS-2的产品编码以此往下排，我想提取出每个国家拥有的相同产品编码（也就是求各国产品编码的交集），希望大佬们能帮帮忙，感激不尽

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input long k str3 country
   
4. 10110 "ARG"
   
5. 10190 "ARG"
   
6. 10410 "ARG"
   
7. 10511 "ARG"
   
8. 10619 "ARG"
   
9. 10690 "ARG"
   
10. 20329 "ARG"
    
11. 20649 "ARG"
    
12. 20714 "ARG"
    
13. 20727 "ARG"
    
14. 20900 "ARG"
    
15. 21019 "ARG"
    
16. 30110 "ARG"
    
17. 30212 "ARG"
    
18. 30321 "ARG"
    
19. 30322 "ARG"
    
20. 30343 "ARG"
    
21. 30371 "ARG"
    
22. 30379 "ARG"
    
23. 30410 "ARG"
    
24. 30420 "ARG"
    
25. 30541 "ARG"
    
26. 30549 "ARG"
    
27. 30729 "ARG"
    
28. 30739 "ARG"
    
29. 30749 "ARG"
    
30. 30759 "ARG"
    
31. 30799 "ARG"
    
32. 40130 "ARG"
    
33. 40210 "ARG"
    
34. 40299 "ARG"
    
35. 40410 "ARG"
    
36. 40610 "ARG"
    
37. 40630 "ARG"
    
38. 40640 "ARG"
    
39. 40690 "ARG"
    
40. 40900 "ARG"
    
41. 50400 "ARG"
    
42. 50590 "ARG"
    
43. 50690 "ARG"
    
44. 50800 "ARG"
    
45. 51000 "ARG"
    
46. 51110 "ARG"
    
47. 51199 "ARG"
    
48. 60110 "ARG"
    
49. 60210 "ARG"
    
50. 60220 "ARG"
    
51. 60290 "ARG"
    
52. 60310 "ARG"
    
53. 60499 "ARG"
    
54. 70110 "ARG"
    
55. 70310 "ARG"
    
56. 70920 "ARG"
    
57. 70990 "ARG"
    
58. 71021 "ARG"
    
59. 71029 "ARG"
    
60. 71030 "ARG"
    
61. 71040 "ARG"
    
62. 71080 "ARG"
    
63. 71190 "ARG"
    
64. 71231 "ARG"
    
65. 71239 "ARG"
    
66. 71290 "ARG"
    
67. 71310 "ARG"
    
68. 71333 "ARG"
    
69. 71339 "ARG"
    
70. 71340 "ARG"
    
71. 80111 "ARG"
    
72. 80132 "ARG"
    
73. 80212 "ARG"
    
74. 80222 "ARG"
    
75. 80232 "ARG"
    
76. 80300 "ARG"
    
77. 80410 "ARG"
    
78. 80420 "ARG"
    
79. 80430 "ARG"
    
80. 80440 "ARG"
    
81. 80450 "ARG"
    
82. 80540 "ARG"
    
83. 80610 "ARG"
    
84. 80720 "ARG"
    
85. 80820 "ARG"
    
86. 81050 "ARG"
    
87. 81090 "ARG"
    
88. 81120 "ARG"
    
89. 81190 "ARG"
    
90. 81310 "ARG"
    
91. 81320 "ARG"
    
92. 81340 "ARG"
    
93. 90111 "ARG"
    
94. 90112 "ARG"
    
95. 90121 "ARG"
    
96. 90122 "ARG"
    
97. 90210 "ARG"
    
98. 90220 "ARG"
    
99. 90230 "ARG"
    
100. 90240 "ARG"
     
101. 90411 "ARG"
     
102. 90412 "ARG"
     
103. 90420 "ARG"
     
104. end

复制代码

* Example generated by -dataex-. To install: ssc install dataex
clear
input int year str3 country int k
2003 "ARG" 10110
2003 "ARG" 10190
2003 "ARG" 10210
2003 "ARG" 10310
2003 "ARG" 10690
2003 "AUS" 10110
2003 "AUS" 10190
2003 "AUS" 10690
2003 "AUT" 10110
2003 "AUT" 10190
2003 "AUT" 10210
2003 "AUT" 10290
2003 "AUT" 10310
2003 "AUT" 10420
2003 "AUT" 10690
end

egen id=group(k)
bys id: egen num=count(country)
sort id
keep if num==3
list

无法理解你要的东西，请用你提供的资料说明！

你提供的数据只有一个国家啊

917968079 发表于 2021-6-14 12:19
你提供的数据只有一个国家啊

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int year str3 country int k
   
4. 2003 "ARG" 10110
   
5. 2003 "ARG" 10190
   
6. 2003 "ARG" 10210
   
7. 2003 "ARG" 10310
   
8. 2003 "ARG" 10690
   
9. 2003 "AUS" 10110
   
10. 2003 "AUS" 10190
    
11. 2003 "AUS" 10690
    
12. 2003 "AUT" 10110
    
13. 2003 "AUT" 10190
    
14. 2003 "AUT" 10210
    
15. 2003 "AUT" 10290
    
16. 2003 "AUT" 10310
    
17. 2003 "AUT" 10420
    
18. 2003 "AUT" 10690
    
19. end

复制代码

不好意思还不太会用stata，我重新截取了一部分，麻烦您再帮我看看，谢谢

黃河泉 发表于 2021-6-14 10:25
无法理解你要的东西，请用你提供的资料说明！

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input int year str3 country int k
   
4. 2003 "ARG" 10110
   
5. 2003 "ARG" 10190
   
6. 2003 "ARG" 10210
   
7. 2003 "ARG" 10310
   
8. 2003 "ARG" 10690
   
9. 2003 "AUS" 10110
   
10. 2003 "AUS" 10190
    
11. 2003 "AUS" 10690
    
12. 2003 "AUT" 10110
    
13. 2003 "AUT" 10190
    
14. 2003 "AUT" 10210
    
15. 2003 "AUT" 10290
    
16. 2003 "AUT" 10310
    
17. 2003 "AUT" 10420
    
18. 2003 "AUT" 10690
    
19. end

复制代码

老师这是我重新截取的内容，目的是提取国家之间相同编码的部分，去掉编码没有重合的，请您再帮我看看，谢谢

蓝狗的眼睛 发表于 2021-6-15 11:22
老师这是我重新截取的内容，目的是提取国家之间相同编码的部分，去掉编码没有重合的，请您再帮我看看，谢 ...

如同我之前所说，

1. 无法理解你要的东西，请用你提供的资料说明！

复制代码

黃河泉 发表于 2021-6-15 16:08
如同我之前所说，

比如我给出的数据中，三个国家都有10110、10190、10690这三个编码，我要keep的就是这三个编码，把另外的10210、10310、、10290、10420给drop掉，所以是求各个国家在产品编码中的交集

蓝色 发表于 2021-6-13 17:37
* Example generated by -dataex-. To install: ssc install dataex
clear
input int year str3 country ...

感谢！！已经解决