How would you code a merge that will keep only the
observations that have matches from both sets.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
What do the PUT and INPUT functions do?
What is proc sort?
Give e an example of..
What does PROC print, and PROC contents do?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
What is the difference between input and infile statement?
Did you used proc test? when?
0 Answers Accenture, Quintiles,
Name validation tools used in SAS
where are dashboard components are created and maintained? : Sas-bi
How to test the debugging in sas?
Name statements that are execution only.
what is the difference between proc means and proc tabulate?