https://communities.sas.com/t5/SAS-Programming/Remove-duplicates-thru-datastep/m-p/722873#M224218 <P>You already have it. Use a BY statement and either the first. or last. variable in a subsetting IF. After 340+ posts here, this will be child's play for you.</P> Tue, 02 Mar 2021 15:11:36 GMT Kurt_Bremser 2021-03-02T15:11:36Z https://communities.sas.com/t5/SAS-Programming/Remove-duplicates-thru-datastep/m-p/722863#M224210 <P>data new;<BR />input Client_No$ Client_name$&amp;20.;<BR />cards;<BR />1234 Julie<BR />1234 Julie Tremblay<BR />4567 George<BR />5678 Alex<BR />5678 Alexander<BR />9123 Bob<BR />;<BR />run;</P> <P><BR />proc sort data=new;<BR />by Client_No;<BR />run;</P> <P>How to remove duplicates thru datastep (first.and last.)</P> Tue, 02 Mar 2021 14:20:36 GMT https://communities.sas.com/t5/SAS-Programming/Remove-duplicates-thru-datastep/m-p/722863#M224210 BrahmanandaRao 2021-03-02T14:20:36Z https://communities.sas.com/t5/SAS-Programming/Remove-duplicates-thru-datastep/m-p/722870#M224215 <P>I don't see any duplicates.&nbsp; What would you like the result to be?</P> Tue, 02 Mar 2021 15:00:54 GMT https://communities.sas.com/t5/SAS-Programming/Remove-duplicates-thru-datastep/m-p/722870#M224215 Astounding 2021-03-02T15:00:54Z https://communities.sas.com/t5/SAS-Programming/Remove-duplicates-thru-datastep/m-p/722873#M224218 <P>You already have it. Use a BY statement and either the first. or last. variable in a subsetting IF. After 340+ posts here, this will be child's play for you.</P> Tue, 02 Mar 2021 15:11:36 GMT https://communities.sas.com/t5/SAS-Programming/Remove-duplicates-thru-datastep/m-p/722873#M224218 Kurt_Bremser 2021-03-02T15:11:36Z