How would you code a merge that will keep only the
observations that have matches from both sets?
Answer Posted / naveen
data qqq;
merge aaa(in=a) bbb(in=b);
if a and b;
run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the maximum length of the macro variable?
What are pdv and it functions?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What sas features do you use to check errors and data validation?
what is data access? : Sas-di
what is ae onset date n what is RDS
For what purpose would you use the RETAIN statement?
how to change the execute of macro
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What are the five ways to do a table lookup in sas? : sas-grid-administration
How do you add a number to a macro variable? : sas-macro
Differentiate between proc means and proc summary.
How do you delete duplicate observations in sas?
What is the difference between nodupkey and nodup options?
What are all the problems you faced while validating tables and reports?