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
- 9806 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
what are the scrubbing procedures in sas? : Sas programming
What are the data types in sas?
Differentiate between proc means and proc summary.
Describe the ways in which you can create macro variables?
Explain the purpose of substr functions in sas programming.
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
Mention few capabilities of sas framework.
Mention the difference between ceil and floor functions in sas?
explain about data integrator metadata reports? : Sas-di
How would you identify a macro variable?
How to test the debugging in sas?
What do you understand by the term Normal Distribution?
What versions of SAS have you used (on which platforms)?
what is function of retain statment
