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
- 18631 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 is study design in while working with SAS? what are screening variables in SAS?
What are the difference between sas functions and procedures?
What is the function of Stop statement in a SAS Program?
what is the effect of the options statement errors=1? : Sas programming
What do the SAS log messages "numeric values have been converted to character" mean?
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?
what are all the reports you generated in your recent project?
What is PROC in SAS?
What does PROC print, and PROC contents do?
Do you need to rearrange the order of the data for the report?
what are the benefits of data integration? : Sas-di
What is SAS? What are the functions does it performs?
What is Linear Regression?
What is by-group processing?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
