topic Re: delete duplicate rows in SAS Procedures

topic Re: delete duplicate rows in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/delete-duplicate-rows/m-p/541268#M74125 <P> </P> <PRE><CODE class=" language-sas">proc sort data=have out=want nodupkey; by id; run;</CODE></PRE> <P> </P> <P> </P> <P> </P> Thu, 07 Mar 2019 22:49:20 GMT novinosrin 2019-03-07T22:49:20Z delete duplicate rows https://communities.sas.com/t5/SAS-Procedures/delete-duplicate-rows/m-p/541266#M74124 <P> </P> <P>I want to delete row if id is the same</P> <P>data have;<BR />input id name $ age $;<BR />cards;<BR />1 aik 26 <BR />1 aik 29 <BR />2 bik 23 <BR />2 bik 23 <BR />5 cik 30 <BR />6 cik 28 <BR />;<BR />run;</P> <P> </P> <P>I want this </P> <P>1 aik 26 <BR />2 bik 23  <BR />5 cik 30 <BR />6 cik 2</P> Thu, 07 Mar 2019 22:46:38 GMT https://communities.sas.com/t5/SAS-Procedures/delete-duplicate-rows/m-p/541266#M74124 sasphd 2019-03-07T22:46:38Z Re: delete duplicate rows https://communities.sas.com/t5/SAS-Procedures/delete-duplicate-rows/m-p/541268#M74125 <P> </P> <PRE><CODE class=" language-sas">proc sort data=have out=want nodupkey; by id; run;</CODE></PRE> <P> </P> <P> </P> <P> </P> Thu, 07 Mar 2019 22:49:20 GMT https://communities.sas.com/t5/SAS-Procedures/delete-duplicate-rows/m-p/541268#M74125 novinosrin 2019-03-07T22:49:20Z