Re: st: do group identifiers identify the same groups?

[Jeph Herrin <junk@spandrel.net>]

Thanks to C�lio and Svend for their suggestions.

Svend's idea will not work at all, as my two identifiers
are not meant to take the same values. That is, g1 will
likely never equal g2.

C�lio's suggestion does get at what I want, especially as
it found no errors. However, I'm curious if there is a way
that would also let me identify which records or values
produced the errors;  -assert- is uninformative in that
respect.

Thanks again,
Jeph




Svend Juul wrote:
> Jeph wrote:
>  
> Seems this should be easy, but the only solutions I
> can think of are tedious.
>  
> I have two group identifiers in my data of 108k
> observations. I would like to verify that that
> they identify the same groups - there are about
> 800 groups, which rules out the simple inspection
> routes.
>  
> ======================================================
>  
> - and C�lio gave good advice involving -assert-.
>  
> I have the problem with -assert- that it is not very 
> assertive; it remains silent if things are OK. That is
> often good, but here I prefer a positive confirmation.
> I would:
>  
>     . generate samegroup = (g1==g2)
>     . tab1 samegroup
>     -> tabulation of samegroup  
>       samegroup |      Freq.     Percent        Cum.
>     ------------+-----------------------------------
>               1 |    108,000      100.00      100.00
>     ------------+-----------------------------------
>           Total |    108,000      100.00
>  
> This will work both with numeric and string group ids.
>  
> Hope this helps
> Svend
>
> ________________________________________________________ 
>  
> Svend Juul
> Institut for Folkesundhed, Afdeling for Epidemiologi
> (Institute of Public Health, Department of Epidemiology)
> Vennelyst Boulevard 6 
> DK-8000 Aarhus C,  Denmark 
> Phone, work:   +45 8942 6090 
> Phone, home:   +45 8693 7796 
> Fax:           +45 8613 1580 
> E-mail:        sj@soci.au.dk 
> _________________________________________________________ 
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/