comparing the tables

[Aayushi_17]

Hi i have two tables with same variable name which contains yes or no as values and sequence number  i want to create a new variable by comparing that value in both the tables like if the first table has no as an answer then i want to get yes from table 2. 

table 1                                       

sequence number	findings
1	yes
2	yes
3	No
4	No
5	yes
6	No

table 2 

sequence number	findings
1	no
2	no
3	yes
4	yes
5	yes
6	yes

the  output i want is this way 

sequence number	findings
1	yes
2	yes
3	yes
4	yes
5	yes
6	yes

thanks in advance

[novinosrin · Accepted solution]

data table1;
input sequence_number 	findings $;
cards;
1	yes 
2	yes 
3	No 
4	No 
5	yes 
6	No 
;

data table2;
input  sequence_number 	findings $;
cards;
1	no 
2	no 
3	yes 
4	yes 
5	yes 
6	No 
;

data want;

merge table1 table2(rename=(findings=f));

if findings='No' and f='yes' then findings='yes';

drop f;

run;

data want;

merge table1 table2(rename=(findings=f));

if findings='No' and f='yes' then findings='yes';

drop f;

run;

NOTE; Your sequence 6 has NO in both tables, so that can't be YES in output

[Aayushi_17]

thank you so much 

[VDD]

what sets sequence number 6 to yes since both incoming tables has sequence number 6 as No?

[Aayushi_17]

sorry that table 1 should contain no and table 2 should contain yes