Question43:
ThefollowingSASprogramissubmitted:
datawork.empsalary;
setwork.people(in=inemp)
work.money(in=insal);
ifinsalandinemp;
run;
TheSASdatasetWORK.PEOPLEhas5observations,andthedatasetWORK.MONEYhas7observations.HowmanyobservationswillthedatasetWORK.EMPSALARYcontain?
1.0
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:1
Exp:Becauseinitasetstatementnotmerge,soonlyinemporinsalcanbetrueatatime.answeris'0'observationsbecausethestatement'merge'isnotused.Atthiscase,you
areeitherinemporinsal,butnotboth.In'SET',onlyonetableiscontributinginanyoneobservationofresultingdatasetthereforeonlyone'in='variablecanbetrueforsuch
observation.
MergingcombinesobservationsfromtwoormoreSASdatasetsintoasingleobservationinanewSASdataset.Thenewdatasetcontainsallvariablesfromalltheoriginaldatasets
You can access to full explanation to question and answer from this page.
