Hi,
I have a data set of the following structure:
with variables of type A and variables of type B.
I want to find the overlap in the values of the A and B type variables so that the table looks like:
where the OL variables present the overlaps.
Is there an easy way to do this?
Many thanks!
Bobby
I have a data set of the following structure:
a1 | a2 | a3 | b1 | b2 | b3 |
11 | 13 | 17 | 9 | 13 | 22 |
6 | 22 | 24 | 12 | 19 | 22 |
12 | 14 | 29 | 7 | 12 | 29 |
with variables of type A and variables of type B.
I want to find the overlap in the values of the A and B type variables so that the table looks like:
a1 | a2 | a3 | b1 | b2 | b3 | ol1 | ol2 | ol3 |
11 | 13 | 17 | 9 | 13 | 22 | 13 | . | . |
6 | 22 | 24 | 12 | 19 | 22 | . | . | . |
12 | 14 | 29 | 7 | 12 | 29 | 12 | 29 | . |
where the OL variables present the overlaps.
Is there an easy way to do this?
Many thanks!
Bobby
Comment