SAS_Institute
A00-201 · Question #49
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: WORK.EMPLOYEE Fname age Bruce 30 Dan 40 WORK.SALARY name salary Bruce 25000 Dan 35000 The following SAS program is submitted: data…
The correct answer is D. merge work.employee work.salary (rename = (name = fname)). See the full explanation below for the reasoning.
Question
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: WORK.EMPLOYEE Fname age Bruce 30 Dan 40 WORK.SALARY name salary Bruce 25000 Dan 35000 The following SAS program is submitted: data work.empdata; <insert MERGE statement here> by fname; totsal + salary; run; Which one of the following statements completes the merge of the two data sets by the FNAME variable?
Options
- Amerge work.employee work.salary (name = fname);
- Bmerge work.employee work.salary
- Cmerge work.employee work.salary (rename = (name = fname));
- Dmerge work.employee work.salary (rename = (name = fname));
How the community answered
(38 responses)- A16% (6)
- B11% (4)
- C3% (1)
- D71% (27)
Community Discussion
No community discussion yet for this question.