How to merge two data sets in this case

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 122
Accepted Solution

How to merge two data sets in this case

Hi,

I have a seemingly easy question. I would like to know if there is any easy way to do it.

There are two datasets A and B, both include a variable stock id (ID). A is a very comprehensive one that has many more ids than B. Now I want to merge two together to get any IDs in A that are not in B. How to do it? Can I do it in proc sql?

Thanks.


Accepted Solutions
Solution
‎11-20-2014 04:00 PM
Super User
Posts: 19,038

Re: How to merge two data sets in this case


All Replies
Solution
‎11-20-2014 04:00 PM
Super User
Posts: 19,038

Re: How to merge two data sets in this case

Frequent Contributor
Posts: 122

Re: How to merge two data sets in this case

Cool. Thanks!

Occasional Contributor
Posts: 15

Re: How to merge two data sets in this case

use proc_sql under left join

🔒 This topic is solved and locked.

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

Discussion stats
  • 3 replies
  • 206 views
  • 0 likes
  • 3 in conversation