collapsing the expanded rows keeping only one

[Bibek Sapkota]

Hi
I have expanded my data making 11 rows for some reasons as below. Now, I just want to keep one row deleting 10. What could be the code?

* Example generated by -dataex-. To install: ssc install dataex
clear
input int sn float cluster byte(district municipality ward)
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 1 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 2 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 3 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 4 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 5 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 6 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 7 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 8 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
 9 1 1 1 3
10 1 1 1 3
end
label values cluster cluster
label def cluster 1 "koshi", modify
label values district district
label def district 1 "sunsari", modify
label values municipality municipality
label def municipality 1 "gadhi", modify

[Nick Cox]

help duplicates