Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Sas-Institute Discussions

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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Mouni_18
7 months, 2 weeks 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, 3 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
3 years ago
yes, the correct answer here is D
upvoted 1 times
Navyvuyyuru
3 years ago
Sorry the correct answer is merge work.employee work.salary (rename = (name = fname));
upvoted 3 times
...
...
Navyvuyyuru
3 years 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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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