如何找出数据中重复的值

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str9 liscd str20 abbrnme
   
4. "136231" "16金茂01"
   
5. "136135" "16联泰01"
   
6. "136218" "16华凌01"
   
7. "143290" "17广汇02"
   
8. "112469" "16涪陵02"
   
9. "143017" "17华汽01"
   
10. "143413" "17贵产01"
    
11. "112610" "17制药01"
    
12. "143062" "17首农01"
    
13. "112519" "17物美01"
    
14. "136619" "16中静02"
    
15. "122330" "13中企债"
    
16. "143913" "17渝信Y1"
    
17. "136157" "16重水01"
    
18. "136034" "15沪国资"
    
19. "112305" "15长影02"
    
20. "136792" "16中筑01"
    
21. "143901" "17云续Y1"
    
22. "136726" "16中材02"
    
23. "122495" "14亨通02"
    
24. "143983" "18电投Y2"
    
25. "123034" "16神雾债"
    
26. "136122" "15天域债"
    
27. "143443" "17中民G1"
    
28. "143289" "18鲁商01"
    
29. "112117" "12福发债"
    
30. "112584" "17创维P1"
    
31. "136634" "16黔高速"
    
32. "143598" "18陕煤01"
    
33. "143602" "18雅砻01"
    
34. "136301" "16龙盛03"
    
35. "136056" "15玉皇01"
    
36. "122468" "15五矿01"
    
37. "143526" "18老窖01"
    
38. "136101" "15合景01"
    
39. "112426" "16东林02"
    
40. "136490" "16红美01"
    
41. "136014" "15福投债"
    
42. "136400" "16金辉03"
    
43. "112587" "17越租01"
    
44. "112499" "17欧菲01"
    
45. "136408" "16路桥01"
    
46. "122332" "14亿利01"
    
47. "136009" "15红星01"
    
48. "136513" "16电投03"
    
49. "136297" "16两江01"
    
50. "136857" "16重汽01"
    
51. "112675" "18厦贸Y1"
    
52. "112233" "14漳发债"
    
53. "136552" "16圆融02"
    
54. "122443" "15桂金债"
    
55. "136274" "16海亮01"
    
56. "112666" "18科伦01"
    
57. "143654" "18泰富01"
    
58. "112399" "16凯迪债"
    
59. "112416" "16奥燃02"
    
60. "136419" "16国华01"
    
61. "112644" "18GLPR1"   
    
62. "112502" "17科伦01"
    
63. "136420" "16中电01"
    
64. "143974" "18铁投Y1"
    
65. "143260" "17国投01"
    
66. "143467" "18联想01"
    
67. "136224" "16新业02"
    
68. "136866" "16汇丰02"
    
69. "143005" "17长发01"
    
70. "143700" "18宁资01"
    
71. "143321" "17金玛03"
    
72. "143370" "17联合04"
    
73. "136043" "15华凌01"
    
74. "112560" "17国水01"
    
75. "112674" "18亚迪01"
    
76. "122347" "13太极02"
    
77. "112521" "17昆仑01"
    
78. "143194" "17电投10"
    
79. "136211" "16恒力01"
    
80. "136050" "15景德01"
    
81. "122431" "15闽高速"
    
82. "112511" "17正通01"
    
83. "136364" "16十二师"
    
84. "136705" "16协信08"
    
85. "122492" "15新光02"
    
86. "136360" "16富力04"
    
87. "112240" "15华联债"
    
88. "143629" "18中凯01"
    
89. "112641" "18晨债01"
    
90. "136365" "16桂铁债"
    
91. "112382" "16南都01"
    
92. "112277" "15金街03"
    
93. "122457" "15新金债"
    
94. "143479" "18浦建01"
    
95. "112473" "16海普瑞"
    
96. "143146" "17恒信01"
    
97. "143556" "18特变01"
    
98. "136511" "16云金01"
    
99. "112600" "17巴安债"
    
100. "136727" "16平海01"
     
101. "122380" "14瀚华01"
     
102. "112467" "16天广01"
     
103. "112588" "17万维S1"
     
104. end

复制代码

如何找出数据中重复的值呢

扫码加我 拉你入群

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

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

分享0 收藏4 回帖

1. 你给的资料似乎没有重复的值？2. 重复是对谁 (liscd, abbrnme) 而言？3. 请 help duplicates!

小灰灰no1 发表于 2018-8-15 11:13
如何找出数据中重复的值呢

我有一个思路，stata软件。下面写的year只是通常情况，你的就不用写year了。<br>
gen 计数器=1<br>
bys id year:egen 出现次数=sum(计数器)<br>
list id year 出现次数 if 出现次数＞=2<br>
上面是列出来，下面保证每个样本只出现一次，并且在出现次数那一列写了原来出现过多少次。<br>
duplicates drop id,force
如果还有year，最好是用id和year合并生成一个独一无二的编码，叫yearid(excel下是用&amp;函数，stata下我还没有试过)，duplicates这步就改成yearid。<br>