Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

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

st: RE: Re: match values of several variables

From   "Nick Cox" <>
To   <>
Subject   st: RE: Re: match values of several variables
Date   Fri, 23 Apr 2010 12:02:58 +0100

Note that this can be trimmed to 

list if (max(<whatever) - min(<whatever>)) > 0 

although the <whatever> inevitably lengthen the command. 


Irene Moral

perhaps you can try to compute

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


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 

is this useful for your purpouse?

From: "Cris Dogaru (Oregon State University)" <>

> 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.

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index