topic Re: How to merge two data sets in this case in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180085#M265037 <HTML><HEAD></HEAD><BODY><P>Cool. Thanks!</P></BODY></HTML> Thu, 20 Nov 2014 21:24:33 GMT SeanZ 2014-11-20T21:24:33Z How to merge two data sets in this case https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180083#M265035 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have a seemingly easy question. I would like to know if there is any easy way to do it.</P><P></P><P>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?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 20 Nov 2014 20:35:17 GMT https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180083#M265035 SeanZ 2014-11-20T20:35:17Z Re: How to merge two data sets in this case https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180084#M265036 <HTML><HEAD></HEAD><BODY><P>Yes you can do it in proc sql. Use a left join.</P><P></P><P><A href="https://twitter.com/abmathewks/status/531243396443406336/photo/1" title="https://twitter.com/abmathewks/status/531243396443406336/photo/1">Abraham Mathew on Twitter: &amp;quot;Hands down, one of the most important works of art EVER! </A><A href="http://t.co/AeaYZGjGvg&amp;quot" target="_blank">http://t.co/AeaYZGjGvg&amp;quot</A>;</P></BODY></HTML> Thu, 20 Nov 2014 21:00:12 GMT https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180084#M265036 Reeza 2014-11-20T21:00:12Z Re: How to merge two data sets in this case https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180085#M265037 <HTML><HEAD></HEAD><BODY><P>Cool. Thanks!</P></BODY></HTML> Thu, 20 Nov 2014 21:24:33 GMT https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180085#M265037 SeanZ 2014-11-20T21:24:33Z Re: How to merge two data sets in this case https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180086#M265038 <HTML><HEAD></HEAD><BODY><P>use proc_sql under left join</P></BODY></HTML> Fri, 21 Nov 2014 08:01:48 GMT https://communities.sas.com/t5/SAS-Programming/How-to-merge-two-data-sets-in-this-case/m-p/180086#M265038 jadhavsada1_gmail_com 2014-11-21T08:01:48Z