Advertisement
Guest User

Dupe black hole

a guest
Aug 23rd, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SAS 0.27 KB | None | 0 0
  1. proc sql;
  2.  
  3. create table dupes as
  4. select mom_id, dob
  5. from your_data
  6. group by mom_id, dob
  7. having count(*) > 1;
  8.  
  9. create table your_data_no_dupes as
  10. select a.*
  11. from your_data a
  12. left join dupes b
  13. on a.mom_id = b.mom_id
  14. and a.dob = b.dob
  15. where b.mom_id = NULL;
  16.  
  17. quit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement