<>
**************
bysort ID: keep if_n==1
**************
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Laura Platchkov
Sent: Samstag, 12. September 2009 20:45
To: [email protected]
Subject: st: ST: delete duplicate observations
Dear all,
I have a dataset with 200'000 observations, and a lot of observation have
the same ID. I want to keep only 1 observation of each ID, lets say the
first one that have this particular ID.
My dataset is like this:
ID variable Z
1 45.6
1 46.7
1 47.8
1 .
2 .
2
2
3
4
5
5
5
5
An I want to transform the dataset like this:
1 45.6
2
3
4
Does anyone has the magic command for that???
Laura
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/