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.
Answer Posted / tangyoulei
data new1 new2 new3;
merge old1 (in=one) old2 (in=two);
if one and two then output new1;
else if one and not two then output new2;
else output new3;
run;
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What are the data types in sas?
What is the maximum and minimum length of macro variable
Give e an example of..
What commands are used in the case of including or excluding any specific variables in the data set?
Which command is used to perform sorting in sas program?
What is your favorite all time computer book? Why?
Do you know the features of sas?
What are common programming errors committed in sas
How would you identify a macro variable?
What does proc print, and proc contents are used for?
What is the difference between INPUT and INFILE ?
Why double trailing @@ is used in input statement?
What is Linear Regression?