Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: RE: testing -duplicates tag-


From   "Mentzakis, Emmanouil" <e.mentzakis@abdn.ac.uk>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: testing -duplicates tag-
Date   Wed, 3 Sep 2008 19:22:01 +0100

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: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] On Behalf Of Michael McCulloch [mm@pinest.org]
Sent: 03 September 2008 18:34
To: statalist@hsphsun2.harvard.edu
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: owner-statalist@hsphsun2.harvard.edu
>[mailto:owner-statalist@hsphsun2.harvard.edu] 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
>mcculloch@pinestreetfoundation.org
>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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index