I've got repeated observations with thesame IDs. I want to keep only the first of the repeated observations for each of the IDs that appear. For example in the sample below, I want to keep only two observations. Serial number 1 and Serial number 31 [Will appreciate any help. tnx]:
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float n str42 HHID 1 "10100101111008" 2 "10100101111008" 3 "10100101111008" 4 "10100101111008" 5 "10100101111008" 6 "10100101111008" 7 "10100101111008" 8 "10100101111008" 9 "10100101111008" 10 "10100101111008" 11 "10100101111008" 12 "10100101111008" 13 "10100101111008" 14 "10100101111008" 15 "10100101111008" 16 "10100101111008" 17 "10100101111008" 18 "10100101111008" 19 "10100101111008" 20 "10100101111008" 21 "10100101111008" 22 "10100101111008" 23 "10100101111008" 24 "10100101111008" 25 "10100101111008" 26 "10100101111008" 27 "10100101111008" 28 "10100101111008" 29 "10100101111008" 30 "10100101111008" 31 "10100101111009" 32 "10100101111009" 33 "10100101111009" 34 "10100101111009" 35 "10100101111009" 36 "10100101111009" 37 "10100101111009" 38 "10100101111009" 39 "10100101111009" 40 "10100101111009" 41 "10100101111009" 42 "10100101111009" 43 "10100101111009" 44 "10100101111009" 45 "10100101111009" 46 "10100101111009" 47 "10100101111009" 48 "10100101111009" 49 "10100101111009" 50 "10100101111009" 51 "10100101111009" 52 "10100101111009" 53 "10100101111009" 54 "10100101111009" 55 "10100101111009" 56 "10100101111009" 57 "10100101111009" 58 "10100101111009" 59 "10100101111009" 60 "10100101111009" end
0 Response to Sorting duplicates in household IDS
Post a Comment