HI..
I have a sitation where I need to delete all duplicated records without keep one unique row.Can anyone help me to achieve this .
For example...
id name dept
1 aaa xxx
1 aaa xxx
2 bbb yyy
3 ccc zzz
3 ccc zzz
4 ddd zzz
result should be
id name dept
2 bbb yyy
4 ddd zzz
Thanks in advance....
How about:
data temp; input id name $ dept $; cards; 1 aaa xxx 1 aaa xxx 2 bbb yyy 3 ccc zzz 3 ccc zzz 4 ddd zzz ; run; proc sql noprint; create table want as select * from temp group by id,name,dept having count(*) eq 1; quit; data temp; input id name $ dept $; cards; 1 aaa xxx 1 aaa xxx 2 bbb yyy 3 ccc zzz 3 ccc zzz 4 ddd zzz ; run; proc sort data=temp;by id name dept;run; data want; set temp; by id name dept; if first.dept and last.dept; run;
Ksharp
How about:
data temp; input id name $ dept $; cards; 1 aaa xxx 1 aaa xxx 2 bbb yyy 3 ccc zzz 3 ccc zzz 4 ddd zzz ; run; proc sql noprint; create table want as select * from temp group by id,name,dept having count(*) eq 1; quit; data temp; input id name $ dept $; cards; 1 aaa xxx 1 aaa xxx 2 bbb yyy 3 ccc zzz 3 ccc zzz 4 ddd zzz ; run; proc sort data=temp;by id name dept;run; data want; set temp; by id name dept; if first.dept and last.dept; run;
Ksharp
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: