topic Re: Two tables bring in unmatch in SAS Programming

Two tables bring in unmatch

Gil_ — Wed, 15 Feb 2017 23:53:27 GMT

Hi I have 2 tables 3 columns I want to join them and show my output where text they don't match each tables the 1st table look like this
Table1
ID. Date. .. Text
AZ. 01/01/16. AZ 01/01/16
TX. 02/02/16. TX. 02/02/16
The second. table
ID. Date. Text
AZ. 01/01/16. AZ 01/01/16
TX. 02/02/16. TX 02/0216

THE OUTPUT
I'D. DATE. TEXT
TX. 02/0216

Re: Two tables bring in unmatch

ballardw — Wed, 15 Feb 2017 23:59:42 GMT

If I understand what you want this may work:

proc sql;
   create table want as
   select table2.*
   from table2 left join table1
   on table2.id=table1.id and table2.date=table1.date
   where table2.text ne table1.text;
run;