How would you code a merge that will keep only the
observations that have matches from both sets.
Answer Posted / kamudu
here we used simple answer ia
data merge;
merge(tables------);
by (same colum);
if e1 and e2 then
output;
keep-----;
run;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How would you define the end of a macro?
how to remove duplicates using proc sql?
Tell me more about the parameters in macro? : sas-macro
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What is the role of unrestrictive users? : sas-grid-administration
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Explain bmdp procedure?
how many types prompting framework can be broken down to? : Sas-bi
how do you want missing values handled? : Sas programming
How substr function works in sas?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What is PDV?
What do the SAS log messages "numeric values have been converted to character" mean?
What is the difference between class statement and by statement in proc means?