data have; infile cards dlm=' ,'; input name $ code $; cards; Sarah, A1 Sarah, B1 Sarah, C1 Matt, A2 Matt, E2 Dave, A2 Dave, B3 Dave, E2 George, C2 George, A1 ; proc sql; create table want as select name,min(code) as code, ifc(sum(code eqt 'B' or code eqt 'C'),'no ','yes' ) as eligible from have group by name; quit; ... View more

One quick way is to switch to PROC REPORT and specify the BY variable as a GROUP variable instead. You can also try specifying the ID variable the same as the BY variable and see if that resolves it as in this example: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1dex816rlsynxn1gicri1elan89.htm#n1dex816rlsynxn1gicri1elan89 EDIT: proc sort data=sashelp.class out=class; by sex; run; title 'PROC PRINT + BY'; proc print data=class; by sex; run; title 'PROC PRINT + BY + ID'; proc print data=class; id sex; by sex; run; title 'PROC REPORT + GROUP'; proc report data=class; column sex name age weight height; define sex / group ; define name / display; define age / display; define weight / display; define height / display; run; ... View more