How would you code a merge that will keep only the observations that have match

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

How would you code a merge that will keep only the
observations that have matches from both sets.

Question Posted / jaipal reddy

5 Answers
14530 Views
Accenture, Bank Of America, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you code a merge that will keep only the observations that have matches from both sets...

Answer / nishant

Using "IN" variable option. Look at the following example.

data three;
merge one(in=x) two(in=y);
by id;
if x=1 and y=1;
run;

Is This Answer Correct ?

13 Yes

1 No

How would you code a merge that will keep only the observations that have matches from both sets...

Answer / pallavi

data three;
merge one(in=x) two(in=y);
by id;
if x and y;
run;

Is This Answer Correct ?

13 Yes

1 No

How would you code a merge that will keep only the observations that have matches from both sets...

Answer / madhavi

proc sort data=one;
by id;
run;
proc sort data=two;
by id;
run;
data comm_rec;
merge one(in=a) two(in=b);
by id;
if a and b;
run;
proc print data=comm_rec;
run;

Is This Answer Correct ?

11 Yes

0 No

How would you code a merge that will keep only the observations that have matches from both sets...

Answer / sheetal

Using joins in proc sql statement, see following example

proc sql;
select *
from a, b
where a.case_id = b.case_id;
quit;

Is This Answer Correct ?

6 Yes

1 No

How would you code a merge that will keep only the observations that have matches from both sets...

Answer / kamudu

here we used simple answer ia
data merge;
merge(tables------);
by (same colum);
if e1 and e2 then
output;
keep-----;
run;

Is This Answer Correct ?

0 Yes

5 No

Post New Answer