Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: duplicates for one variable
From
"Rienzo, C" <[email protected]>
To
<[email protected]>
Subject
st: RE: duplicates for one variable
Date
Wed, 24 Nov 2010 14:42:30 -0000
Hi try with
Duplicates report "var"
Or duplicates list "var"
If you want to drop then duplicates drop "var" if year==
HTH
Cinzia
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Shehzad Ali
Sent: 24 November 2010 14:35
To: Stata List
Subject: st: duplicates for one variable
Hi listers,
I am looking to find duplicate observations on a certain variable 'time'. Here
is what the data looks like:
id time var3
1 10 2.5
1 20 3.0
1 30 3.5
2 10 2.5
2 10 4.0
I want to identify the observations that are duplicate on the time variable
only, i.e. the last observation in the dataset above.
I would appreciate your help.
Many thanks,
Shehzad
*
* 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/