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
- 18523 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / arun & g.n.rao
data one;
input ID$ NAME$;
datalines;
A01 SUE
A02 TOM
A05 KAY
A10 JIM
;
RUN;
DATA TWO;
INPUT ID$ AGE SEX$;
DATALINES;
A01 58 F
A02 20 M
A04 47 F
A10 11 M
;
RUN;
DATA N1 N2 N3;
MERGE ONE (IN=X) TWO (IN=Y);
BY ID;
IF X=1 AND Y=1 THEN OUTPUT N1;
IF X=1 AND Y=0 THEN OUTPUT N2;
IF X=0 AND Y=1 THEN OUTPUT N3;
RUN;
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What makes sas stand out to be the best over other data analytics tools?
Explain proc univariate?
how do you want missing values handled? : Sas programming
What will calendar procedure do?
What is the basic structure of the SAS base program?
What is the difference between SAS functions and procedures?
Enlist the syntax rules followed in sas statements.
How does the internal authentication work in sas? : sas-grid-administration
What is maximum storage capability of SAS?
How do you debug and test your SAS programs?
What is the difference between proportion and average?
what are _numeric_ and _character_ and what do they do? : Sas programming
Do you need to rearrange the order of the data for the report?
What are all the problems you faced while validating tables and reports?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
