Love this solution and have found it extremely usefully. Is there a way to exand this so that the "numbers" columns is grouped using two columns? I tried this but it didn't work data want; length cat $20.; do until (last.letter1 and last.letter2); set intable; by letter2 letter1 notsorted; cat=catx(',',cat,number); end; drop number; run;
... View more