May this code help you... data san; input id name$; id1=id; cards; 10 a 10 b 10 c 10 d 20 e 20 f 20 g 20 h 30 i 30 j 30 k 30 l ; run; Proc sort data=san; by id id1; run; data san1; set san; by id; if (first.id=0)&&(last.id=0); run; data san2(keep=name id); set san1; by id1; if last.id1; run; Thanks..
... View more