Excluding people from a second dataset

[Walternate]

Hi,

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

Person

A

B

A

A

B

C

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!

[DBailey · Accepted solution]

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;