delete observation from two tables

[sasphd]

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

[ballardw · Accepted solution]

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.