DATA Step, Macro, Functions and more

how to delete duplicate

Reply
Contributor
Posts: 45

how to delete duplicate

How to delete duplicate in data step also in proc sql.
Super User
Posts: 9,682

Re: how to delete duplicate

[pre]
proc sort data=class nodupkey;
by _all_;
run;
[/pre]



[pre]
proc sql;
select distinct *
from temp;
[/pre]




Ksharp
Contributor
Posts: 45

Re: how to delete duplicate

Dear Ksharp,

Thanks a lot for your kind information .

Thanks,
Regards,
Bina
Super User
Posts: 9,682

Re: how to delete duplicate

You are welcome. Smiley Happy


Ksharp
Ask a Question
Discussion stats
  • 3 replies
  • 174 views
  • 0 likes
  • 2 in conversation