Hi all, I am very new to SAS, and I am trying to merge two datasets. The first has pairwise comparisons between the proportion shared between 2 IDs. The second has additional identifying information about each of these IDs. I want the merge the two datasets to produce an output similar to what is shown below, but I am unsure where to start. I have provided samples of the data tables below. I am working in SAS 9.4. I appreciate any help you can provide. Input 1 ID1 ID2 Pair_Num Proportion_Shared 1 2 1 0.97 1 3 2 81 1 4 3 0.73 1 5 4 0.81 2 3 5 0.56 2 4 6 0.71 2 5 7 0.31 3 4 8 0.81 3 5 9 0.66 4 5 10 0.59 Input 2 ID Color Age 1 Blue 15 2 Green 21 3 Blue 78 4 Green 23 5 Blue 56 Desired Output ID1 ID2 Pair_Num Proportion_Shared Colors Age_Difference 1 2 1 0.97 Blue, Green 6 1 3 2 81 Blue, Blue 63 1 4 3 0.73 Blue, Green 8 1 5 4 0.81 Blue, Blue 41 2 3 5 0.56 Green, Blue 57 2 4 6 0.71 Green, Green 2 2 5 7 0.31 Green, Blue 35 3 4 8 0.81 Blue, Green 55 3 5 9 0.66 Blue, Blue 22 4 5 10 0.59 Green, Blue 33
... View more