st: Re: match values of several variables

["Irene Moral" <imoral@eapsardenya.cat>]

Hello

perhaps you can try to compute

var1=max( birthyear_98, birthyear_99.......)

and

var2=min( birthyear_98, birthyear_99......)

and var3=var1-var2

and then recode var3 if var3=0, they match, if var3<0|var3>0 they don't 
match

is this useful for your purpouse?

Irene



----- Original Message ----- 
From: "Cris Dogaru (Oregon State University)" <statamplus@gmail.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Friday, April 23, 2010 10:26 AM
Subject: st: match values of several variables


> Dear all,
>
> I have a longitudinal data in which they asked, at different data
> collection points, the year of birth for the subject's mother; the
> variables are named based on the year of data collection (i.e.,
> birthyear_98, birthyear_99, etc).
> One would expect the values of these varables to match (if it's the
> same person), but they don't. I'd like to find an easy way to check if
> several variables have the same value or not, irrespective of the
> missing values. For now I am using the grouping () option in egen, and
> recode by hand the mismatched cases. However, as I am adding new cases
> to the dataset, the coding needs to be redone every time.
>
> Any suggestion is more than wellcome.
>
> Cristian Dogaru
> ISPM, University of Bern
> *
> *   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/