How to create new rows of all possible combinations (without using Cartesian merging)

[KS99]

Dear Mkeintz

Thank you very much for your detailed explanations!
Only got back to SAS community after an extended span of research.
Wish you a very good rest of the day!

KS -,

[PeterClemmensen]

Just as an alternative

data Network;
input  Cusip Analyst;
cards;
1  1  
1  2  
1  3  
2  8  
2  9  
2  11 
2  10 
2  12 
3  45 
3  46 
;

proc transpose data=Network out=wide prefix = a;
    by Cusip;
    id Analyst;
    var Analyst;
run;

proc summary data = wide missing;
   by Cusip;
   class a:;
   ways 2;
   output out = temp / ways;
run;

data want(keep = Cusip var1 var2);
   set temp;
   if n(of a:) = 2;
   var1 = largest(2, of a:);
   var2 = largest(1, of a:);
run;