Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 9888 Views
- I also Faced
- E-Mail Answers
Answer Posted / reddy
data both left_only right_only;
merge dataset1(in=a) dataset2(in=b);
by variable;
if a and b then output both;
if a and not b then output left_only;
if b and not a then output right_only;
run;
i think these is the easy way of writing the code,if any
one nows other please specify.thanks!
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
Have you ever used the SAS Debugger?
What is the purpose of _character_ and _numeric_?
How can sas program be validated?
what is broad cast agent? : Sas-bi
Describe the function and utility of the most difficult SAS macro that you have written?
Tell e how how dealt with..
Give e an example of..
What are the different versions of sas that you have used until now? : sas-grid-administration
What is the difference between input and infile statement?
How would you define the end of a macro?
What is a put statement?
What is SAS?
What are the functions which are used for character handling functions?
Differentiate between proc means and proc summary.
What is a macro routine?
