I am trying to use proc sql to create all possible pairs of two variables. For example, if my starting data appears like this... letter number a 1 b 2 c 3 I would like the output data to look like... pair1 pair2 pair3 a-1 b-2 c-3 a-1 b-3 c-2 a-2 b-1 c-3 a-2 b-3 c-2 a-3 b-1 c-2 a-3 b-2 c-1 I have been able to get a single column with all 9 possible pairs, but when I try to put multiple pairs on a single line, things get messed up. Thanks in advance for your help!
... View more