How would you code a merge that will write the matches of
both to one data set, the non-matches from the left-most
data set to a second data set, and the non-matches of the
right-most data set to a third data set.
Answer Posted / tangyoulei
data new1 new2 new3;
merge old1 (in=one) old2 (in=two);
if one and two then output new1;
else if one and not two then output new2;
else output new3;
run;
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is the work of tranwrd function?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What is the difference between %local and %global? : sas-macro
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What is the maximum and minimum length of macro variable
Explain substr function?
what is ae onset date n what is RDS
What are the statements in proc sql?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What are the uses of sas?
How do you test for missing values?
what is treatment emergent events and treatment emregent adverse event
How would you identify a macro variable? : sas-macro
What are the automatic variables for macro? : sas-macro
how can you create zero observation dataset? : Sas programming