Question50:TheSASdatasetsWORK.EMPLOYEEandWORK.SALARYareshownbelow:

WORK.EMPLOYEEWORK.SALARY

fnameagenamesalary

Bruce30Bruce25000

Dan40Bruce35000

Dan25000

ThefollowingSASprogramissubmitted:

datawork.empdata;

byfname;

totsal+salary;

run;

WhichoneofthefollowingstatementscompletesthemergeofthetwodatasetsbytheFNAMEvariable?

1.mergework.employee

work.salary(fname=name);

2.Get all Questions and Answer from here

3.You need to have paid subscription to access all questions

4.Thanks for considering Python Certification Material

CorrectAnswer:4

Becausethetwodatasetsaremergedbyfnamevariable.Youneedtorenamethenamevariableofthesalarydatasettofname.Correctwaytorenameis

(rename=(name=fname))

(rename=(original_var_name=new_var_name))

Theoriginalvarinthiscaseisnameandneedstoberenamedfname.

So4shouldbethecorrectanswer.

You can access to full explanation to question and answer from this page.