Say I have a data set with 4 character variables: x1-x4. The data looks something like: ab cd ab ca. I want to compare each variable to the other. Therefore, I have 6 combinations. I am interested in the ones that match (i.e., x1 matches x3, 'ab'). So my output should contain 3 columns: First and second columns list the variables being compared to each other (total of 6 rows due to 6 combinations). The third column stating whether or not there is a match. I know to calculate the number of combinations, I use: c42=comb(4,2). I am stuck thereafter. Any suggestions?
... View more