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.
- 10 Answers
- 15569 Views
- Accenture, I also Faced
- E-Mail Answers
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 sas olap server? : Sas-di
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
AE datasets names? how many types?
Mention what is SAS data set?
Differences between where and if statement?
What are the different versions of sas that you have used until now? : sas-grid-administration
What is the use of PROC gplot?
what is operational data and operational system? : Sas-di
State the difference between INFORMAT and FORMAT ?
How can you create a macro variable with in data step? : sas-macro
What are the functions used for character handling?
What is data _null_?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What are the features of base sas system?
How does proc sql work?
