<div>
proc sql;<br />
&nbsp; create table3 as<br />
&nbsp; select * from table1 where id not in (select id from table2) Data<br />
quit;
</div>


proc sql;
  create table3 as
  select * from table1 where id not in (select id from table2) Data
quit;

<div>
<div class="content wysiwyg-content">
I have 2 tables: table 1 one with a list of IDs and table 2 with a smaller list of IDs, which are all also in table 1. I want to merge/join the 2 tables in such a manner that I keep all the IDS in table 1, but not the IDS that are in both table 1 and 2. What kind of join do I need to do?
</div>
</div>


I have 2 tables: table 1 one with a list of IDs and table 2 with a smaller list of IDs, which are all also in table 1. I want to merge/join the 2 tables in such a manner that I keep all the IDS in table 1, but not the IDS that are in both table 1 and 2. What kind of join do I need to do?

Join tables in SAS

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.