Selection

[WilliamB]

Hello,

I would like to create a table, with the information from Table 1, but I do not want individuals who are not present in Table 2. In sql code.

Thanks for your help. 

Table1					Table2
ID	Name				ID	Age
14	rt				15	9
15	fd				17	1
16	gf				18	2
17	sq				19	3
18	pm
19	er
20	tr
21	ea
Want
ID	Name
15	fd
17	sq
18	pm
19	er

[RW9 · Accepted solution]

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

Post test data in the form of a datastep in future please.

[PeterClemmensen]

Provided that your data is properly sortet...

data have1;
input ID $ Name $;
datalines;
14 rt
15 fd
16 gf
17 sq
18 pm
19 er
20 tr
21 ea
;

data have2;
input ID $ Age;
datalines;
15 9
17 1
18 2
19 3
;

data want;
    merge have1 have2(in=ina);
    by ID;
    if ina;
    keep ID Name;
run;