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
- 9799 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sas job searcher
data x1y1
x1y0
x0y1;
/* x1y1, x1y0, x0y1 are output data set names */
merge left_most(in=x) right_most(in=y);
by id;
/* write all matches to x1y1: */
if x=1 and y=1 then output x1y1;
/* non-matches from the left-most data set: */
if x=1 and y=0 then output x1y0;
/* non-matches from the right-most data set: */
if x=0 and y=1 then output x0y1;
run;
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / 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 |
How do you add a number to a macro variable?
I have a dataset with variables empid and doj how to calculate retirement age?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
How to limit decimal places for the variable using proc means?
What are the difference between the sas data step and sas procs?
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.
How to test the debugging in sas?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Explain why double trailing @@ is used in input statement?
What is a macro routine?
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
Teradata 
