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
- 18146 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
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is the difference between nodupkey and nodup options?
How do you delete duplicate observations in sas?
Hi, If anyone has base SAS certification dumps, please share.
How would you invoke a macro? : sas-macro
How would you determine the number of missing or nonmissing values in computations?
What makes sas stand out to be the best over other data analytics tools?
Mention common programming errors committed in sas ?
What is SAS informats?
Differentiate between format and informat? : sas-grid-administration
Describe a time when you were really stuck on a problem and how you solved it?
Explain the purpose of retain statement.
Differentiate input and infile.
What are the limitations for memory allocation for SAS variables
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
