I want to find the mode of columns value1,value2 for every group of name,surname columns. as mentioned in below example. I have various approaches but couldn't able to generate any significant output so have not attached my approch. but here is sample data on which it can be tried. data table; infile datalines delimiter=','; input name $ surname $ value1 value2; datalines; N1,S1,90,A N1,S1,90,B N1,S1,100,B N1,S2,70,C N1,S2,80,C N1,S2,70,C ; run;
... View more