Finding Unmatched Values between 2 tables

[pcfriendly]

Hi,

I'm using SAS Enterprise Guide 4.3 & I'm trying to find the best way to separate account numbers where one table is a subset of the other.

Any suggests?

[BrunoMueller · Accepted solution]

You can use the query builder to achieve this. Brief steps:

• you have two tables that share a key which is used to identify the accounts
• start your query with the table (called A from now on) that contains the accounts you are interested in
• join the second table (called B from now on) in the query using a left join
• on the select tab, get the columns from table A your are interested in
• add the the key column from table B to the select tab
• now define a filter on the key column from table B, all rows where this value is missing are only present in table A but not in table B

Have a go

[pcfriendly]

Thanks Bruno !!