Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: how to find out observations that id variables can't uniquely identify?


From   Nina YIN <yinnina.ccer@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: how to find out observations that id variables can't uniquely identify?
Date   Wed, 19 Oct 2011 19:39:57 +0200

Thank you, Steve, Jorge, Pedro, William!
Your suggestions works well.


On Wed, Oct 19, 2011 at 5:59 PM, William Buchanan
<william@williambuchanan.net> wrote:
>
> Hi Nina,
>
> -duplicates drop appIno productno-
>
> - Billy
> On Oct 19, 2011, at 7:58 AM, Nina YIN wrote:
>
> > Dear all,
> >
> > I want to merge two large datasets, before I merge them, I checked
> > whether id variables(applno productno) uniquely identify observations:
> > "by applno productno:assert _N==1", it turns out "4 contradictions in
> > 26586 by-groups ", then I want to figure out what's the problem with
> > these 4 contradictions. However I don't know how to find out where
> > they are? Do you have any suggestions? Thanks a lot!
> >
> >
> >
> > --
> > Best Regards,
> > Nina YIN
> >
> >
> > Toulouse School of Economics
> > Manufacture des Tabacs
> > 21 Allee de Brienne
> > Toulouse, 31000, France
> > Tel: 0033-(0)5 6123 8348
> > *
> > *   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/



--
Best Regards,
Nina YIN


Toulouse School of Economics
Manufacture des Tabacs
21 Allee de Brienne
Toulouse, 31000, France
Tel: 0033-(0)5 6123 8348

*
*   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   |   Site index