[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: ST: delete duplicate observations
From
Jeph Herrin <[email protected]>
To
[email protected]
Subject
Re: st: ST: delete duplicate observations
Date
Mon, 14 Sep 2009 14:46:34 -0400
If by "first" you mean "smallest value of Z" then
bys ID (Z) : keep if _n==1
will do it.
hth,
Jeph
Laura Platchkov wrote:
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/
© Copyright 1996–2024 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |