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.