sort id
duplicates drop id, force
This will only work if you want to keep the FIRST observation for each id
_________________________
Jorge Eduardo Pérez Pérez
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Laura Platchkov
Sent: sábado, 12 de septiembre de 2009 01:45 p.m.
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/
