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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.