Excluding people from a second dataset

Walternate — Tue, 11 Mar 2014 18:26:37 GMT

Hi,

I have a dataset where each row represents one person, with duplicates, like this:

Person

Then I have a second similar dataset, one row per person.

What I want to be able to do is remove people from the first dataset if they are present in the second dataset. Any help is much appreciated.

Thanks!

Re: Excluding people from a second dataset

DBailey — Tue, 11 Mar 2014 18:50:18 GMT

proc sql;

create table want as

select

t1.*

from

dataset1 as t1

left outer join dataset2 as t2

on t1.person=t2.person

where

t2.person is null;

quit;