Desktop productivity for business analysts and programmers

Finding Unmatched Values between 2 tables

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

Finding Unmatched Values between 2 tables

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?


Accepted Solutions
Solution
‎10-28-2013 04:01 AM
SAS Super FREQ
Posts: 703

Re: Finding Unmatched Values between 2 tables

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

View solution in original post


All Replies
Solution
‎10-28-2013 04:01 AM
SAS Super FREQ
Posts: 703

Re: Finding Unmatched Values between 2 tables

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

Frequent Contributor
Posts: 80

Re: Finding Unmatched Values between 2 tables

Thanks Bruno !!

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 1267 views
  • 2 likes
  • 2 in conversation