请教各位大神,以下是10个人2007年的工资,每个人均有两条记录,因为统计月份的不同。我想保留每个人12月份的记录,但是使用duplicates drop id,force,会直接删除第二条重复的id记录,有的12月份排在前面,有的1月份排在前面,这样的重复记录还有其他,均存在这种问题,就是都有一条12月份的记录和一条其他月份的工资记录,月份的先后顺序是乱的,像1是一月份在前12月份在后,3是12月份在前1月份在后这种,有什么办法能让月份为12月份的记录排在前面,删除时便可以直接删除其他月份的记录呢,万望大神不吝赐教,谢谢!
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input float id str4 year str2 month str31 Name str2 gender str17 TotalSalary
- 1 "2007" "01" "曹志新" "男" "150000"
- 1 "2007" "12" "曹志新" "男" "139575"
- 2 "2007" "12" "陈丽秋" "女" "192000"
- 2 "2007" "01" "陈丽秋" "女" "192000"
- 3 "2007" "12" "胡海涛" "男" "242460"
- 3 "2007" "01" "胡海涛" "男" "400000"
- 4 "2007" "12" "姜珠国" "男" "180000"
- 4 "2007" "01" "姜珠国" "男" "100000"
- 5 "2007" "12" "江浩然" "男" "362490"
- 5 "2007" "01" "江浩然" "男" "360000"
- 6 "2007" "12" "廖学湖" "男" "324000"
- 6 "2007" "01" "廖学湖" "男" "252000"
- 7 "2007" "12" "邱东华" "男" "192000"
- 7 "2007" "01" "邱东华" "男" "192000"
- 8 "2007" "12" "舒跃平" "男" "180000"
- 8 "2007" "01" "舒跃平" "男" "100000"
- 9 "2007" "12" "王君平" "男" "280000"
- 9 "2007" "01" "王君平" "男" "200000"
- 10 "2007" "12" "赵长健" "男" "86760"
- 10 "2007" "01" "赵长健" "男" "120000"
- end
复制代码