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
- 15575 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / vipin choudhary
Assume the common variable in both of the old datasets
is "name".
Data One two three;
merge old(in = in1) old1(in = in2);
by name;
if in1 and in2 then output one;
if in1 then output two;
if in1 = 0 and in2 = 1 then output three;
run
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
explain the concepts and capabilities of business object? : Sas-bi
What is connection profile? : sas-grid-administration
What was the last computer book you purchased? Why?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
how sas deals with business intelligence? : Sas-bi
In sas, what are the areas that you are most interested in? : sas-grid-administration
Differentiate between sas functions and sas procedures.
If money were no object, what would you like to do?
describe about metadata object? : Sas-di
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?
What do the put and input function do?
Briefly explain input and put function?
How you can read the variables that you need?
