My data are proprietary, so I will provide a simple mock-up that I hope makes the structure clear.
custid is the customer identifier variable and product is, well, different products. I would like to identify which customers are common for all pairwise combinations of products. In my actual data there are hundreds of unique custid (and they can be repeated, absent, or omitted, within products) and 20 different products. I cannot, for the life of me, figure out how to do this using the various table commands and options. Any help would be appreciated.
custid | product |
1 | A |
2 | A |
2 | A |
3 | A |
4 | A |
2 | B |
3 | B |
3 | B |
3 | B |
1 | C |
1 | C |
1 | C |
1 | C |
2 | C |
4 | C |
4 | C |
4 | C |
4 | C |
4 | C |
Comment