Help using Base SAS procedures

How to get a dataset where the ticket doesn't match ?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

How to get a dataset where the ticket doesn't match ?

I have 2 tables I need to create a new table where the key doesn't match here is example
TABLE 1
ID. date. key
A. 06/01/15. 1
A. 06/02/16. 23
here is example
TABLE 2
ID. date. key
A. 06/01/15. 3
A. 06/02/16. 23

here what I want to see

TABLE 3
ID. date. key
A. 06/02/16. 3
The key 1 is not needed ... I'm kicking around merge I just need the key where there is no match thanks

Accepted Solutions
Solution
‎05-29-2016 12:38 PM
Super User
Posts: 10,483

Re: How to get a dataset where the ticket doesn't match ?

Here's a try for simple data such as you show.

If there are many duplicates of ID*date combinations may not work.

proc sql;
   create table want 
   as select b.*
   from table1 as a left join table2 as b
      on a.id=b.id and a.date=b.date 
   where a.key ne b.key;
quit;

View solution in original post


All Replies
Solution
‎05-29-2016 12:38 PM
Super User
Posts: 10,483

Re: How to get a dataset where the ticket doesn't match ?

Here's a try for simple data such as you show.

If there are many duplicates of ID*date combinations may not work.

proc sql;
   create table want 
   as select b.*
   from table1 as a left join table2 as b
      on a.id=b.id and a.date=b.date 
   where a.key ne b.key;
quit;
☑ This topic is SOLVED.

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

Discussion stats
  • 1 reply
  • 191 views
  • 0 likes
  • 2 in conversation