https://communities.sas.com/t5/SAS-Procedures/delete-observation/m-p/350000#M63784 proc sort data=have out=want nodupkey;<BR />by name surname;<BR />run; Fri, 14 Apr 2017 10:33:58 GMT Jagadishkatam 2017-04-14T10:33:58Z https://communities.sas.com/t5/SAS-Procedures/delete-observation/m-p/349993#M63783 <P>I have a data set like this :</P><P>&nbsp;</P><P>NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SURNAME<BR />RAYNALD&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALEXANDRE<BR />RAYNALD&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; ALEXANDRE<BR />RAYNALD&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; ALEXANDRE</P><P>ALICE&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ANDRE</P><P>ALICE&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ANDRE</P><P>GERALDINE&nbsp;&nbsp; &nbsp;ANDRE</P><P>&nbsp;</P><P>How can I get some thing like this ?&nbsp; :</P><P>NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SURNAME<BR />RAYNALD&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALEXANDRE</P><P>ALICE&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ANDRE</P><P>GERALDINE&nbsp;&nbsp; &nbsp;ANDRE</P> Fri, 14 Apr 2017 10:04:59 GMT https://communities.sas.com/t5/SAS-Procedures/delete-observation/m-p/349993#M63783 John4 2017-04-14T10:04:59Z https://communities.sas.com/t5/SAS-Procedures/delete-observation/m-p/350000#M63784 proc sort data=have out=want nodupkey;<BR />by name surname;<BR />run; Fri, 14 Apr 2017 10:33:58 GMT https://communities.sas.com/t5/SAS-Procedures/delete-observation/m-p/350000#M63784 Jagadishkatam 2017-04-14T10:33:58Z