topic Re: delete observation from two tables in SAS Procedures

delete observation from two tables

sasphd — Mon, 20 Apr 2015 18:46:23 GMT

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 — Mon, 20 Apr 2015 20:33:39 GMT

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.