Help using Base SAS procedures

delete observation from two tables

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 118
Accepted Solution

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: 10,483

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.

View solution in original post


All Replies
Solution
‎04-20-2015 04:33 PM
Super User
Posts: 10,483

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 159 views
  • 0 likes
  • 2 in conversation