topic Re: comparing the tables in SAS Programming

comparing the tables

Aayushi_17 — Mon, 26 Nov 2018 07:10:27 GMT

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

Re: comparing the tables

novinosrin — Sun, 25 Nov 2018 22:23:14 GMT





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

Re: comparing the tables

Aayushi_17 — Sun, 25 Nov 2018 17:21:55 GMT

thank you so much

Re: comparing the tables

VDD — Sun, 25 Nov 2018 17:40:08 GMT

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

Re: comparing the tables

Aayushi_17 — Mon, 26 Nov 2018 06:59:50 GMT

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