ExamTopics Logo
Mail Us[email protected]
Menu
Sas-Institute Discussions
exam questions

Exam A00-211 All Questions

View all questions & answers for the A00-211 exam
Go to Exam

Exam A00-211 topic 1 question 9 discussion

Actual exam question from SAS Institute's A00-211
Question #: 9
Topic #: 1
[All A00-211 Questions]

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.employee work.salary (fname = name);
  • B. merge work.employee work.salary (name = fname);
  • C. merge work.employee work.salary (rename = (fname = name));
  • D. merge work.employee
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Kleinstone at Jan. 19, 2021, 3:27 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Mouni_18
7 months, 1 week ago
The correct answer is data work.empdata; merge work.employee work.salary(rename=(name = fname)); by fname; run; It is not in these options. But it is close to option C so we can choose C.
upvoted 2 times
Lisa_L
4 months, 2 weeks ago
Agreed, the correct way to rename is (rename = (name = fname))
upvoted 1 times
...
...
Mandar77
1 year, 10 months ago
Correction.. Answer C is wrong bacaz Salary has column as Name not Fname. My Apology. it has to be like this merge work.employee (rename = (fname = name)) work.salary; or merge work.employee work.salary (rename = (name = fname));
upvoted 1 times
...
Mandar77
1 year, 10 months ago
Correct answer is C. You need more than one dataset two merge in first place. Salary has column as name and Employee has column has fname. Either dataset has to rename column. C is right bcaz it is rename column with proper syntax.
upvoted 1 times
...
Navyvuyyuru
2 years, 12 months ago
yes, the correct answer here is D
upvoted 1 times
Navyvuyyuru
2 years, 12 months ago
Sorry the correct answer is merge work.employee work.salary (rename = (name = fname));
upvoted 3 times
...
...
Navyvuyyuru
2 years, 12 months ago
what is the correct answer here ?
upvoted 1 times
...
Kleinstone
3 years, 3 months ago
is C? D is surely wrong.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago