st: RE: or operator with lists of variables

[Joe Canner <jcanner1@jhmi.edu>]

Philipp,

The brute force way to do it is:

gen identical=0
forvalues i=1/20 {
forvalues j=1/25 {
  replace identical=1 if base`i'==var`j'
}
}

If you have a lot of observations, this may not be very efficient, so you might want to use the -inlist- function:

gen identical=0
forvalues i=1/20 {
  replace identical=1 if inlist(base`i',var1,var2,var3,...,var25)
}
}

If var1-var25 are strings instead of numerics you will have to split it into three function calls:

replace identical=1 if inlist(base`i',var1,...,var9) | inlist(base`i',var10,...,var18) | inlist(base`i',var19,var25)

Regards,
Joe Canner
Johns Hopkins University School of Medicine
________________________________________
From: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] on behalf of Loew, Philipp [philipp.loew@wiwi.uni-goettingen.de]
Sent: Monday, January 13, 2014 4:50 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: or operator with lists of variables

Dear Statalists,

I try to solve the following problem:
- I know what to to in a simple case, e.g.:

gen identical=.
replace identical=1 if base1==variable1 | base1==variable2 | base1==variable3

- however, I would like to compare two lists of variables (base1-base20 and var1-var25) with the "or operator" (I try to
describe it in "pseudo-code"):

gen identical=.
replace identical=1 if (base1-base20) == (var1-var25)

- In this case the condition should be satisfied if any of the base and var combinations has identical values.

Thank you!

Kind regards
Philipp

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/