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

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

From   Jeph Herrin <>
Subject   Re: st: do group identifiers identify the same groups?
Date   Wed, 09 Jul 2008 12:36:43 -0400

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

Thanks again,

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
- 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 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: _________________________________________________________
* For searches and help try:

*   For searches and help try:

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