topic Re: Finding Unmatched Values between 2 tables in SAS Enterprise Guide

Finding Unmatched Values between 2 tables

pcfriendly — Mon, 28 Oct 2013 02:02:33 GMT

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 — Mon, 28 Oct 2013 08:01:14 GMT

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 — Mon, 28 Oct 2013 20:52:30 GMT

Thanks Bruno !!