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
- 18145 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 the command used to find missing values?
What is the purpose of trailing @ and @@? How do you use them?
What is the difference between INPUT and INFILE ?
What is the maximum length of the macro variable?
what is hierarchy flattening? : Sas-di
What is interleaving in SAS?
Which command is used to save logs in the external file?
where to use sas business intelligence? : Sas-bi
Explain what is data step?
Describe a time when you were really stuck on a problem and how you solved it?
What is by-group processing?
Give e an example of..
What can be the size of largest dataset in SAS?
What is the difference between where and if statement?
Given an unsorted data set, how to read the last observation to a new data set?
