How would you code a merge that will keep only the
observations that have matches from both sets.
Answer Posted / nishant
Using "IN" variable option. Look at the following example.
data three;
merge one(in=x) two(in=y);
by id;
if x=1 and y=1;
run;
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Difference between SAS STATA & SPSS?
how do you want missing values handled? : Sas programming
What can be the size of largest dataset in SAS?
Explain what is SAS informats?
Approximately what date is represented by the SAS date value of 730?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
AE datasets names? how many types?
what is sas business intelligence? : Sas-bi
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Do you need to know if there are any missing values?
What are the different types of sas functions?
Define run-group processing?
How do dates work in SAS data?
How would you define the end of a macro?