Borrowed Art's code: data pumpkin2 ; length name $ 16; infile "c:\temp\forum\pumpkin2.txt"  ; input @;     _infile_=catx("  ",substr(_infile_,1,anydigit(_infile_)-1),                 substr(_infile_,anydigit(_infile_))); input name & age : 2. type : $1. date : mmddyy10. (score1-score3) ( 4.1); run; proc print;run;           Obs          name          age    type     date    score1    score2    score3            1     Alicia Grossman      13     c      16006      7.8       6.5       7.2            2     Matthew Lee           9     D      16008      6.5       5.9       6.8            3     Elizabeth Garcia     10     C      16007      8.9       7.9       8.5            4     Lori Newcombe         6     D      16008      6.7       5.6       4.9            5     Jose Martinez         7     d      16009      8.9       9.5      10.0            6     Brian Williams       11     C      16007      7.8       8.4       8.5 ... View more

DF: While I, too, learned something new from Linlin's post, I agree that neither of the suggestions address ties.  How about: data have; input hospital $ claim; cards; a 23 b 45 a . b 43 a 55 c 55 ; proc sql ;   select hospital from     (select hospital,count(claim) as counts        from have          group by hospital)            having counts=max(counts)    ; quit; ... View more