请问各位,如果data set中有duplicate observations(如SALARY data set),用MERGE合并EMPLOYEE 和SALARY的时候程序是怎么样处理的呢?谢谢啦~
data set:EMPLOYEE SALARY
name age name salary
Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
data work.empsalary;
merge work.employee (in = inemp)
work.salary(in = insal);
by name;
if inemp and insal;
run;