Which one of the following statements completes the merge of the two data sets by the FNAME variable?

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:

WORK.EMPLOYEE WORK.SALARY

fname age name salary

Bruce 30 Bruce 25000

Dan 40 Bruce 35000

Dan 25000

The following SAS program is submitted:

data work.empdata;

by fname;

totsal + salary;

run;

Which one of the following statements completes the merge of the two data sets by the FNAME variable?
A . merge work.employeework.salary (fname = name);
B. merge work.employeework.salary (name = fname);
C. merge work.employeework.salary (rename = (fname = name));
D. merge work.employeework.salary (rename = (name = fname));

View Answer

Answer: D