Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- proc sql;
- create table dupes as
- select mom_id, dob
- from your_data
- group by mom_id, dob
- having count(*) > 1;
- create table your_data_no_dupes as
- select a.*
- from your_data a
- left join dupes b
- on a.mom_id = b.mom_id
- and a.dob = b.dob
- where b.mom_id = NULL;
- quit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement