DATA Step, Macro, Functions and more

Selection

Accepted Solution Solved
Reply
Contributor
Posts: 33
Accepted Solution

Selection

 

 

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
14rt   159
15fd   171
16gf   182
17sq   193
18pm     
19er     
20tr     
21ea     
       
Want      
       
ID Name     
15fd     
17sq     
18pm     
19er     
       
       

Accepted Solutions
Solution
4 weeks ago
Super User
Super User
Posts: 9,227

Re: Selection

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.

View solution in original post


All Replies
Solution
4 weeks ago
Super User
Super User
Posts: 9,227

Re: Selection

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.

PROC Star
Posts: 1,190

Re: Selection

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;
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 108 views
  • 1 like
  • 3 in conversation