https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25974#M4591 Dear Ksharp,<BR /> <BR /> Thanks a lot for your kind information .<BR /> <BR /> Thanks,<BR /> Regards,<BR /> Bina Thu, 10 Mar 2011 09:07:34 GMT arpit 2011-03-10T09:07:34Z https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25972#M4589 How to delete duplicate in data step also in proc sql. Thu, 10 Mar 2011 07:38:37 GMT https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25972#M4589 arpit 2011-03-10T07:38:37Z https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25973#M4590 [pre]<BR /> proc sort data=class nodupkey;<BR /> by _all_;<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> <BR /> [pre]<BR /> proc sql;<BR /> select distinct *<BR /> from temp;<BR /> [/pre]<BR /> <BR /> <BR /> <BR /> <BR /> Ksharp Thu, 10 Mar 2011 08:38:36 GMT https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25973#M4590 Ksharp 2011-03-10T08:38:36Z https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25974#M4591 Dear Ksharp,<BR /> <BR /> Thanks a lot for your kind information .<BR /> <BR /> Thanks,<BR /> Regards,<BR /> Bina Thu, 10 Mar 2011 09:07:34 GMT https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25974#M4591 arpit 2011-03-10T09:07:34Z https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25975#M4592 You are welcome. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /> <BR /> <BR /> Ksharp Thu, 10 Mar 2011 09:43:26 GMT https://communities.sas.com/t5/SAS-Programming/how-to-delete-duplicate/m-p/25975#M4592 Ksharp 2011-03-10T09:43:26Z