楼主: ×晓√
1027 4

[数据管理求助] 请大家看一下，以下的数据如何删除重复值（这只是其中的一组数据），蟹蟹。 [推广有奖]

  • 1关注
  • 1粉丝

已卖：5份资源

本科生

15%

还不是VIP/贵宾

-

0%
威望
0 级
论坛币
3051 个
通用积分
3.3335
学术水平
0 点
热心指数
0 点
信用等级
0 点
经验
8704 点
帖子
59
精华
0
在线时间
56 小时
注册时间
2017-11-3
最后登录
2020-11-25
楼主
×晓√ 发表于 2019-3-7 13:58:59 |AI写论文
100论坛币
input str6 mfc long year str6(mfcstock mfc_1 mfcstock_1)
"020009" 201302 "000001" "020009" "000001"
"020009" 201302 "000001" "050004" "000001"
"020009" 201302 "000001" "090003" "000001"
"020009" 201302 "000001" "160215" "000001"
"020009" 201302 "000001" "160613" "000001"
"020009" 201302 "000001" "161706" "000001"
"020009" 201302 "000001" "162209" "000001"
"020009" 201302 "000001" "180020" "000001"
"020009" 201302 "000001" "202019" "000001"
"020009" 201302 "000001" "217001" "000001"
"020009" 201302 "000001" "217009" "000001"
"020009" 201302 "000001" "217012" "000001"
"020009" 201302 "000001" "217013" "000001"
"020009" 201302 "000001" "233006" "000001"
"020009" 201302 "000001" "340007" "000001"
"020009" 201302 "000001" "460001" "000001"
"020009" 201302 "000001" "460005" "000001"
"020009" 201302 "000001" "519994" "000001"
"020009" 201302 "000001" "519996" "000001"
"020009" 201302 "000001" "630006" "000001"
"020009" 201302 "000001" "750001" "000001"
"050004" 201302 "000001" "020009" "000001"
"050004" 201302 "000001" "050004" "000001"
"050004" 201302 "000001" "090003" "000001"
"050004" 201302 "000001" "160215" "000001"
"050004" 201302 "000001" "160613" "000001"
"050004" 201302 "000001" "161706" "000001"
"050004" 201302 "000001" "162209" "000001"
"050004" 201302 "000001" "180020" "000001"
"050004" 201302 "000001" "202019" "000001"
"050004" 201302 "000001" "217001" "000001"
"050004" 201302 "000001" "217009" "000001"
"050004" 201302 "000001" "217012" "000001"
"050004" 201302 "000001" "217013" "000001"
"050004" 201302 "000001" "233006" "000001"
"050004" 201302 "000001" "340007" "000001"
"050004" 201302 "000001" "460001" "000001"
"050004" 201302 "000001" "460005" "000001"
"050004" 201302 "000001" "519994" "000001"
"050004" 201302 "000001" "519996" "000001"
"050004" 201302 "000001" "630006" "000001"
"050004" 201302 "000001" "750001" "000001"
"090003" 201302 "000001" "020009" "000001"
"090003" 201302 "000001" "050004" "000001"
"090003" 201302 "000001" "090003" "000001"
"090003" 201302 "000001" "160215" "000001"
"090003" 201302 "000001" "160613" "000001"
"090003" 201302 "000001" "161706" "000001"
"090003" 201302 "000001" "162209" "000001"
"090003" 201302 "000001" "180020" "000001"
"090003" 201302 "000001" "202019" "000001"
"090003" 201302 "000001" "217001" "000001"
"090003" 201302 "000001" "217009" "000001"
"090003" 201302 "000001" "217012" "000001"
"090003" 201302 "000001" "217013" "000001"
"090003" 201302 "000001" "233006" "000001"
"090003" 201302 "000001" "340007" "000001"
"090003" 201302 "000001" "460001" "000001"
"090003" 201302 "000001" "460005" "000001"
"090003" 201302 "000001" "519994" "000001"
"090003" 201302 "000001" "519996" "000001"
"090003" 201302 "000001" "630006" "000001"
"090003" 201302 "000001" "750001" "000001"
"121008" 201302 "000001" "020009" "000001"
"121008" 201302 "000001" "050004" "000001"
"121008" 201302 "000001" "090003" "000001"
"121008" 201302 "000001" "160215" "000001"
"121008" 201302 "000001" "160613" "000001"
"121008" 201302 "000001" "161706" "000001"
"121008" 201302 "000001" "162209" "000001"
"121008" 201302 "000001" "180020" "000001"
"121008" 201302 "000001" "202019" "000001"
"121008" 201302 "000001" "217001" "000001"
"121008" 201302 "000001" "217009" "000001"
"121008" 201302 "000001" "217012" "000001"
"121008" 201302 "000001" "217013" "000001"
"121008" 201302 "000001" "233006" "000001"
"121008" 201302 "000001" "340007" "000001"
"121008" 201302 "000001" "460001" "000001"
"121008" 201302 "000001" "460005" "000001"
"121008" 201302 "000001" "519994" "000001"
"121008" 201302 "000001" "519996" "000001"
"121008" 201302 "000001" "630006" "000001"
"121008" 201302 "000001" "750001" "000001"
"160215" 201302 "000001" "020009" "000001"
"160215" 201302 "000001" "050004" "000001"
"160215" 201302 "000001" "090003" "000001"
"160215" 201302 "000001" "160215" "000001"
"160215" 201302 "000001" "160613" "000001"
"160215" 201302 "000001" "161706" "000001"
"160215" 201302 "000001" "162209" "000001"
"160215" 201302 "000001" "180020" "000001"
"160215" 201302 "000001" "202019" "000001"
"160215" 201302 "000001" "217001" "000001"
"160215" 201302 "000001" "217009" "000001"
"160215" 201302 "000001" "217012" "000001"
"160215" 201302 "000001" "217013" "000001"
"160215" 201302 "000001" "233006" "000001"
"160215" 201302 "000001" "340007" "000001"
"160215" 201302 "000001" "460001" "000001"
end


最佳答案

黃河泉 查看完整内容

试试
分享0
关键词：000001

相关帖子

沙发
黃河泉 在职认证  发表于 2019-3-7 13:59:00
×晓√ 发表于 2019-3-7 14:03
重复情况为：mfc和mfc_1中的数据重复，比如020009和050004、050004和020009重复，只需要保留一个就行。
试试
  1. gen pair = cond(mfc < mfc_1,mfc+"-"+mfc_1,mfc_1+"-"+mfc)
  2. duplicates list pair
  3. duplicates drop pair, force
复制代码
藤椅
×晓√ 发表于 2019-3-7 14:03:46
重复情况为：mfc和mfc_1中的数据重复，比如020009和050004、050004和020009重复，只需要保留一个就行。
板凳
×晓√ 发表于 2019-3-8 10:01:27
黃河泉 发表于 2019-3-7 13:59
试试
非常感谢老师的帮助[em23][em23]
报纸
黃河泉 在职认证  发表于 2019-3-8 10:47:09
×晓√ 发表于 2019-3-8 10:01
非常感谢老师的帮助
如果你觉得我的讲习可以帮助其它老师或学生，晚一点愿意帮我们转发招生讯息，你可以考虑加我的微信 (请私信我，我给你我的微信号码)。
返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jltj
拉您入交流群

京ICP备16021002号-2 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问：王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2025-12-21 09:35