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.
- 10 Answers
- 18543 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
data data1 data2 data3;
merge left(in-a) right(in=b);
by subjid;
if a and b then output data1;
if a and not b then output data2;
if b and not a then output data3;
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differentiate between proc means and proc summary.
How would you identify a macro variable?
Enlist the syntax rules followed in sas statements.
What is the difference between %put and symbolgen? : sas-macro
How do dates work in sas?
Have you ever used the SAS Debugger?
Mention what is SAS data set?
What is the difference between where and if statement?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
How does proc sql work?
What is program data vector (pdv)?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
explain about sas business intelligence? : Sas-bi
what is sas business intelligence? : Sas-bi
name several ways to achieve efficiency in your program? : Sas programming
