Is something with like this helpful?
egen dup=group(headroom trunk)
tab dup
The values with higher frequency than 1 are duplicates.
Cheers
Manos
________________________________________
From: [email protected] [[email protected]] On Behalf Of Michael McCulloch [[email protected]]
Sent: 03 September 2008 18:34
To: [email protected]
Subject: Re: st: RE: testing -duplicates tag-
Apologies, I wasn't clear in my question. What I want to do is find
records for which *both* trunk and headroom are duplicates. So
following the command suggested by Martin and Nick, I get:
. list foreign headroom trunk if trunk==8, clean
foreign headroom trunk
20. Domestic 2.0 8
45. Domestic 1.5 8
57. Foreign 2.0 8
58. Foreign 2.5 8
59. Foreign 2.5 8
Note that:
observations 20 and 57 both have headroom==2.0, trunk==8
observations 58 and 59 both have headroom==2.5, trunk==8
Since I'm developing this command for use in a large dataset, how
would I follow up -duplicates tag- to identify those unique sets of
records, where two variables are duplicates simultaneously, without
having to search manually?
>I cannot see your point. Stata does tag these observations with tag 1. Just
>-list- after -duplicates tag-.
>
>**********
>clear
>sysuse auto
>list foreign headroom trunk if trunk==8
>duplicates tag headroom trunk, generate(dup_admission_id)
>*Let`s see...
>list dup_* foreign headroom trunk if trunk==8
>**********
>
>HTH
>Martin
>
>-----Original Message-----
>From: [email protected]
>[mailto:[email protected]] On Behalf Of Michael McCulloch
>Sent: Wednesday, September 03, 2008 6:29 PM
>To: Statalist
>Subject: st: testing -duplicates tag-
>
>Hello,
>I'm testing -duplicates tag-, and puzzled as to why it won't show the
>two observations where headroom==2.0 and trunk==8.
>
>clear
>sysuse auto
>list foreign headroom trunk if trunk==8
>duplicates tag headroom trunk, generate(dup_admission_id)
>
>--
>
>Best wishes,
>Michael McCulloch
>
>
>
>Pine Street Foundation
>124 Pine St., San Anselmo, CA 94960-2674
>Tel: (415) 407-1357
>Fax: (415) 485-1065
>[email protected]
>www.pinestreetfoundation.org
>*
>* 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/
*
* 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/
The University of Aberdeen is a charity registered in Scotland, No SC013683.
*
* 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/
