## delete observation from two tables

Solved
Frequent Contributor
Posts: 126

# delete observation from two tables

I have two tables. I want to delete from table A observations of table B

Table 1

A     B

3     5

4     6

1     2

3     4

Table 2

A     B

3     5

3     4

Table want

A     B

4     6

1     2

Accepted Solutions
Solution
‎04-20-2015 04:33 PM
Super User
Posts: 13,508

## Re: delete observation from two tables

If you have two values of A=3 and B=5 in table 1 do you want all of them gone?

Does the final order of the results matter?

If the answer to the first question is yes and no to the second then:

proc sql;

create table want as

select * from table1

except

select * from table2

quit;

Will work.

If you have lots of other variables then additional work will be needed.

All Replies
Solution
‎04-20-2015 04:33 PM
Super User
Posts: 13,508

## Re: delete observation from two tables

If you have two values of A=3 and B=5 in table 1 do you want all of them gone?

Does the final order of the results matter?

If the answer to the first question is yes and no to the second then:

proc sql;

create table want as

select * from table1

except

select * from table2

quit;

Will work.

If you have lots of other variables then additional work will be needed.

🔒 This topic is solved and locked.