How would you code a merge that will keep only the
observations that have matches from both sets?
Answer Posted / vijay
Dear Guest,
Merge won't accept NODUPKEY option. it is for PROC SORT.
the following code will get only matched observations in
both datasets
data three;merge one (in=a) two (in=b);by **;if a and b;run;
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Difference between nodup and nodupkey options?
Explain proc sort?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What is the role of sas grid administrator? : sas-grid-administration
In sas, what are the areas that you are most interested in? : sas-grid-administration
What Proc glm does?
Name few SAS functions?
how sas deals with business intelligence? : Sas-bi
for whom is sas data integration studio designed? : Sas-di
How would you determine the number of missing or nonmissing values in computations?
Are you sensitive to code walk-throughs peer review or QC review?
what is ae onset date n what is RDS
what are several options for creating reports in web report studio? : Sas-bi
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Differences between where and if statement?