*(Q). Is there a way I can detect ties for any value in any of the variables? So, in the end, we would have 1 variable that is flagged for a tie in at least one pair (1) or not flagged (0). The reason I say this is because my variables have values all over the place like 7.1439583 or 12.93878974. A complication is that the part in parentheses at the end of the COUNT command will not accept a variable instead of a number. Any ideas? *(A) Posted to SPSSX-L by Raynald Levesque on 2002/10/30. * Note: This is a treat for *macro lovers*. DATA LIST LIST /var1 var2 var3 var4. BEGIN DATA 1 2 3 3 1 2 3 4 1 1 2 2 1 1 1 1 3 3 2 2 . . 1 2 4 1.7 2 1.7 END DATA. LIST. * Flag any cases where some of the variables have the same value. *////////////////////. DEFINE !test(listvar=!CMDEND) !IF (!listvar !NE !NULL) !THEN !LET !testval=!HEAD(!listvar) !LET !other=!TAIL(!listvar) !DO !var !IN (!other) - COMPUTE flag=SUM(!var = !testval, flag). !DOEND !test listvar=!other. !IFEND !ENDDEFINE. *////////////////////. SET MPRINT=yes. COMPUTE flag=0. !test listvar=var1 var2 var3 var4. SET MPRINT=no. COMPUTE flag2=MIN(flag,1). EXECUTE. * Flag2 = 1 when any of the variables var1 to var4 have the same value.