🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 02-15-2017 06:53 PM
(978 views)
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
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
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;