Hello! Recently I was presented with this kind of data data have ; input id (T1-T12) ($) ; cards ; 1 E A E B A A E A C B E F 2 F A E F E E E E A E E E 3 A C C E E E A F D D E F 4 A F F D B B C A A A C C 5 B B C C D A A A B E E F ; run ; Here we have 5 person (animal) with 12 variables describing some its traits. At every trait we can have score from A to F. This scores can be interpreted also as a string containing all scores.  What would be goal is to compare scores between animals and to say where are they the same. For example: id1 vs id2 are same at: t2,t3,t7,t11 id1 vs id2 same at: t11,t12 etc.. In original data set I have and will have much more animals.  I appreciate all of inputs! Cheers! ... View more

Dear friends, consider correlation matrix (attached) and variables IBS_A, IBS_B and IBS_C. This is short example. I usually have much larger matrices with mostly unknown number of variables (goal is to have universal solution). I would like to obtain a vector "New" which would use data without diagonal and duplicates.  New 0,5 0,625 0,5 This is actually corelation between ab, ac, and ac. other is surplus. Can this be done? Thanks!   ... View more