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
explain the proc in sas? : Sas-administrator
Give some examples where proc report’s defaults are different than proc print’s defaults?
In proc transpose and data step with arrays which one you pick?
explain what is factor analysis? : Sas-administrator
how can you put a "trace" in your program? : Sas programming
How to sort in descending order?
what is broad cast agent? : Sas-bi
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what type of graphs we will create(for 2+years candidates)?
how to read the variables in sas? : Sas-administrator
What do you know about sas and what we do? : sas-grid-administration
Explain what is SAS informats?
Differences between where and if statement?
What is PROC in SAS?
What do you know about symput and symget?