SAS BASE 123試題+答案詳解

A00-201A00-201A-ThePowerofKnowingA-ThePowerofKnowingQUESTION1InthefollowingSASprogram,theinputdatafilesaresortedbytheNAMESvariable:libnametemp'SAS-data-library';datatemp.sales;mergetemp.saleswork.receipt;bynames;run;Whichoneofthefollowingresultsoccurswhenthisprogramissubmitted?TheprogramexecutessuccessfullyandatemporarySASdatasetiscreated.TheprogramexecutessuccessfullyandapermanentSASdatasetiscreated.TheprogramfailsexecutionbecausethesameSASdatasetisreferencedforbothandwriteoperations.TheprogramfailsexecutionbecausetheSASdatasetsontheMERGEstatementintwodifferentlibraries.Answer:BQUESTION2WhenthefollowingSASprogramissubmitted,thedatasetSASDATA.PRDSALEScontains5000observations:libnamesastemp'SAS-data-library';optionsobs=500;procprintdata=sasdata.prdsales(firsttobs=100);run;optionsobs=max;procmeansdata=sasdata.prdsales(firsttobs=500);run;Howmanyobservationsareprocessedbyeachprocedure?400forPROC4500forPROCMEANS401forPROC4501forPROCMEANS401forPROC4500forPROCMEANS500forPROC5000forPROCMEANSAnswer:BQUESTION3ThefollowingSASprogramissubmitted:datawork.new;lengthword$7;amount=7;ifamount=5thenword='CAT';elseifamount=7thenword='DOG';elsework='NONE!!!';amount=5;run;WhichoneofthefollowingrepresentsthevaluesoftheAMOUNTandWORDvariables?amount5DOGamount5CATamount7DOGamountword7''(missingcharactervalue)Answer:AQUESTION4WhichoneofthefollowingistrueoftheSUMstatementinaSASDATAstepprogram?ItisonlyvalidinconjunctionwithaSUMfunction.ItisnotvalidwiththeSET,MERGEandUPDATEstatements.Itaddsthevalueofanexpressiontoanaccumulatorvariableandignoresvalues.ItdoesnotretaintheaccumulatorvariablevaluefromoneiterationoftheSASsteptothenext.Answer:CQUESTION5ThefollowingSASprogramissubmitted:datawork.sets;dountil(prodgt6);prod+1;end;run;WhichoneofthefollowingisthevalueofthevariablePRODintheoutputdataset?5678Answer:CQUESTION6ThefollowingSASprogramissubmitted:procprintdata=run;<insertOPTIONSstatementprocmeansdata=sasuser.shoes;run;WhichoneofthefollowingOPTIONSstatementsresetsthepagenumberto1forthesecondreport?optionpageno=1;optionpagenum=1;optionsresetpageno=1;optionsresetpagenum=1;Answer:AQUESTION7ThecontentsoftherawdatafilePRODUCTarelistedbelow:|10|20|3024613$25.31ThefollowingSASprogramissubmitted:datainventory;infile'product';inputidnum5.@10price;run;WhichoneofthefollowingisthevalueofthePRICEvariable?A.25.31B.$25.31C..(missingnumericvalue)D.Novalueisstoredastheprogramfailstoexecuteduetoerrors.Answer:CQUESTION8ThecontentsoftherawdatafileTYPECOLORarelistedbelow:|10|20|30daisyyellowThefollowingSASprogramissubmitted:dataflowers;infile'typecolor';inputtype$1-5+1color$;run;WhichoneofthefollowingrepresentsthevaluesofthevariablesTYPEandCOLOR?typedaisyyellowtypedaisyellowtypecolordaisyyellow(missingcharactervalue)Novaluesarestoredastheprogramfailstoexecuteduetosyntaxerrors.Answer:BQUESTION9Arawdatarecordislistedbelow:|10|20|30son,Travis,Thefollowingoutputisdesired:relationfirstnamesonTravisWhichoneofthefollowingSASprogramsreadsthedatacorrectly?datafamily/dlm=',';infile'file-specification';inputrelation$firstnamerun;optiondlm=datafamily;infile'file-specification';inputrelation$firstname$;run;datafamily;infile'file-specification'optiondlm=',';inputrelation$firstname$;run;datafamily;infile'file-specification';inputrelation$firstname$/dlm=',';run;Answer:CQUESTION10ThefollowingSASprogramissubmitted:libnamerawdata1'locationofSASdatalibrary';filenamerawdata2'locationofrawdatafile';datawork.testdata;infile<insertiteminputsales1salse2;run;Whichoneofthefollowingisneededtocompletetheprogramcorrectly?rawdata1rawdata2'rawdata1''rawdata2'Answer:BQUESTION11ThefollowingSASprogramissubmittedandreads100recordsfromarawdatafile:datawork.total;infile'file-specification'end=eof;inputname$salary;totsal+salary;<insertIFstatementhere>run;WhichoneofthefollowingIFstatementswritesthelastobservationtotheoutputdataset?ifend=0;ifeof=0;ifend=1;ifeof=1;Answer:DQUESTION12ThecontentsoftherawdatafileFURNITUREarelistedbelow:|10|20|30chair,,tablechair,couch,tableThefollowingSASprogramissubmitted:datastock;infile'furniture'dsd;inputitem1$item2$item3$;run;WhichoneofthefollowingisthevalueofthevariablenamedITEM2inthefirstobservationoftheoutputdataset?table,table.(missingnumericvalue)''(missingcharactervalue)Answer:DQUESTION13Arawdatafileislistedbelow:RANCH,1250,2,1,SheppardAvenue,"$64,000"SPLIT,1190,1,1,RandStreet,"$65,850"CONDO,1400,2,1.5,MarketStreet,"80,050"TWOSTORY,1810,4,3,GarrisStreet,"$107,250"RANCH,1500,3,3,KembleAvenue,"$86,650"SPLIT,1615,4,3,WestDrive,"94,450"SPLIT,1305,3,1.5,GrahamAvenue,"$73,650"ThefollowingSASprogramissubmittedusingtherawdatafileasinput:datawork.condo_ranch;infile'file-specification'dsd;inputstyle$@;ifstyle='CONDO'orstyle='RANCH'theninputsqfeetbedroomsbathsstreet$price:dollar10.;run;HowmanyobservationsdoestheWORK.CONDO_RANCHdatasetcontain?0357Answer:DQUESTION14Arawdatafileislistedbelow:RANCH,1250,2,1,SheppardAvenue,"$64,000"SPLIT,1190,1,1,RandStreet,"$65,850"CONDO,1400,2,1.5,MarketStreet,"80,050"TWOSTORY,1810,4,3,GarrisStreet,"$107,250"RANCH,1500,3,3,KembleAvenue,"$86,650"SPLIT,1615,4,3,WestDrive,"94,450"SPLIT,1305,3,1.5,GrahamAvenue,"$73,650"ThefollowingSASprogramissubmittedusingtherawdatafileasinput:datawork.condo_ranch;infile'file-specification'dsd;inputstyle$@;ifstyle='CONDO'orstyle='RANCH';inputsqfeetbedroomsbathsstreet$price:dollar10.;run;Howmanyobservationswilltheoutputdatasetcontain?0357Answer:BQUESTION15ThefollowingSASprogramissubmitted:datanumrecords;infile'file-specification';input@1patient$15.relative$16-26@;ifrelative='children'theninput@54diagnosis$15.@;elseifrelative='parents'theninput@28doctor$15.clinic$44-53@54diagnosis$15.@;inputage;run;HowmanyrawdatarecordsarereadduringeachiterationoftheDATAstepduringexecution?1234Answer:AQUESTION16ThefollowingSASprogramissubmitted:datawork.empsalary;setwork.people(in=inemp)work.money(in=insal);ifinsalandinemp;run;TheSASdatasetWORK.PEOPLEhas5observations,andthedatasetWORK.MONEYhas7observations.HowmanyobservationswillthedatasetWORK.EMPSALARYcontain?05712Answer:AQUESTION17ThecontentsoftwoSASdatasetsnamedEMPLOYEEandSALARYarelistedbelow:EMPLOYEESALARYnameagenamesalaryBruce30Bruce40000Dan35Bruce35000Dan37000Dan.ThefollowingSASprogramissubmitted:datawork.empsalary;mergework.employee(in=inemp)work.salary(in=insal);byname;ifinempandinsal;run;HowmanyobservationswillthedatasetWORK.EMPSALARYcontain?2456Answer:BQUESTION18TheSASdatasetsWORK.EMPLOYEEandWORK.SALARYarelistedbelow:WORK.EMPLOYEEWORK.SALARYfnameagefnamesalaryBruce30Bruce25000Dan40Bruce35000Dan25000ThefollowingSASprogramissubmitted:datawork.empdata;mergework.employeework.salary;byfname;totsal+salary;run;HowmanyvariablesareoutputtotheWORK.EMPDATAdataset?345Novariablesareoutputtothedatasetastheprogramfailstoexecuteduetoerrors.Answer:BQUESTION19TheSASdatasetsWORK.EMPLOYEEandWORK.SALARYareshownbelow:WORK.EMPLOYEEWORK.SALARYfnameagenamesalaryBruce30Bruce25000Dan40Bruce35000Dan25000ThefollowingSASprogramissubmitted:datawork.empdata;<insertMERGEstatementhere>byfname;totsal+salary;run;WhichoneofthefollowingstatementscompletesthemergeofthetwodatasetsbytheFNAMEvariable?mergework.employeework.salary(fname=mergework.employeework.salary(name=mergework.employeework.salary(rename=(fname=name));mergework.employeework.salary(rename=(name=fname));Answer:DQUESTION20ThefollowingSASprogramissubmitted:procsortdata=work.employee;bydescendingfname;procsortsortdata=work.salary;bydescendingfname;datawork.empdata;mergework.employeework.salary;byfname;run;Whichoneofthefollowingstatementsexplainswhytheprogramfailedexecution?TheSORTprocedurescontaininvalidsyntax.ThemergeddatasetsarenotpermanentSASdatasets.Thedatasetswerenotmergedintheorderbywhichtheyweresorted.TheRUNstatementswereomittedaftereachoftheSORTprocedures.Answer:CQUESTION21ThefollowingSASSORTprocedurestepgeneratesanoutputdataset:procsortdata=sasuser.housesout=report;bystyle;run;Inwhichlibraryistheoutputdatasetstored?WORKREPORTHOUSESSASUSERAnswer:AQUESTION22ThefollowingSASDATAstepissubmitted:libnametemp'SAS-data-library';datatemp.report;setsasuser.houses;newvar=price*1.04;run;Whichoneofthefollowingstatementsistrueregardingtheprogramabove?Theprogramisreadingfromatemporarydatasetandwritingtoatemporarydataset.Theprogramisreadingfromatemporarydatasetandwritingtoapermanentdataset.Theprogramisreadingfromapermanentdatasetandwritingtoatemporarydataset.Theprogramisreadingfromapermanentdatasetandwritingtoapermanentdataset.Answer:DQUESTION23WhichoneofthefollowingSASDATAstepssavesthetemporarydatasetnamedMYDATAasapermanentdataset?libnamesasdata'SAS-data-library';datasasdata.mydata;copymydata;run;libnamesasdata'SAS-data-library';datasasdata.mydata;keepmydata;run;libnamesasdata'SAS-data-library';datasasdata.mydata;savemydata;run;libnamesasdata'SAS-data-library';datasasdata.mydata;setmydata;run;Answer:DQUESTION24ThefollowingSASDATAstepissubmitted:datasasdata.atlantasasdata.bostonwork.portlandwork.phoenix;setcompany.prdsales;ifregion='NE'thenoutputbostan;ifregion='SE'thenoutputatlanta;ifregion='SW'thenoutputphoenix;ifregion='NW'thenoutputportland;run;Whichoneofthefollowingistrueregardingtheoutputdatasets?Nolibraryreferencesarerequired.ThedatasetslistedonalltheIFstatementsrequirealibraryreference.ThedatasetslistedinthelasttwoIFstatementsrequirealibraryreference.ThedatasetslistedinthefirsttwoIFstatementsrequirealibraryreference.Answer:DQUESTION25ThefollowingSASDATAstepexecutesonMonday,April25,2000:datanewstaff;setstaff;start_date=today();run;WhichoneofthefollowingisthevalueofthevariableSTART_DATEintheoutputdataset?acharacterstringwiththevalue'04/25/2000'acharacterstringwiththevalue'Monday,April25,2000'thenumericvalue14725,representingtheSASdateforApril25,2000thenumericvalue04252000,representingtheSASdateforApril25,2000Answer:CQUESTION26ThefollowingSASprogramissubmitted:datawork.new;mon=3;day=23;year=2000;date=mdy(mon,day,year);run;WhichoneofthefollowingisthevalueoftheDATEvariable?acharacterstringwiththevalue'23mar2000'acharacterstringwiththevalue'03/23/2000'anumericvalueof14692,whichrepresentstheSASdatevalueforMarch23,2000anumericvalueof3232000,whichrepresentstheSASdatevalueforMarch23,Answer:CQUESTION27ThefollowingSASprogramissubmitted:datarevenue;setyear_1;var1=mdy(1,15,1960);run;WhichoneofthefollowingvaluesdoesthevariablenamedVAR1contain?1415C.1151960D.'1/15/1960'Answer:AQUESTION28ThefollowingSASprogramissubmitted:datawork.report;setwork.sales_info;ifqtr(sales_date)ge3;run;TheSASdatasetWORK.SALES_INFOhasoneobservationforeachmonthintheyear2000andthevariableSALES_DATEwhichcontainsaSASdatevalueforeachofthetwelvemonths.HowmanyoftheoriginaltwelveobservationsinWORK.SALES_INFOarewrittentotheWORK.REPORTdataset?2369Answer:CQUESTION29ThefollowingSASprogramissubmitted:?libnametemp'SAS-data-library';datawork.new;set;formatnewdatemmddyy10.;qdate=qtr(newdate);ddate=weekday(newdate);run;procprintdata=work.new;run;ThevariableNEWDATEcontainstheSASdatevalueforApril15,2000.WhatoutputisproducedifApril15,2000fallsonaSaturday?Obsnewdateqdate1APR15200026Obsnewdateqdate104/15/200026Obsnewdateqdate1APR15200027Obsnewdateqdate104/15/200027Answer:DQUESTION30Arawdatarecordisshownbelow:07Jan2002Whichoneofthefollowinginformatswouldreadthisvalueandstoreitasadatevalue?date9.ddmonyy9.ddMMMyy9.ddmmmyyyy9.Answer:AQUESTION31ThecontentsoftheSASdatasetPERM.JAN_SALESarelistedbelow:VARIABLENAMETYPEidnumcharactervariablesales_datenumericdatevalueAcommadelimitedrawdatafileneedstobecreatedfromthePERM.JAN_SALESdataset.TheSALES_DATEvaluesneedtobeinaMMDDYY10form.WhichoneofthefollowingSASDATAstepscorrectlycreatesthisrawdatafile?libnameperm'SAS-data-library';data_null_;setperm.jan_sales;file'file-specification'dsd=',';putidnumsales_date:mmddyy10.;run;libnameperm'SAS-data-library';data_null_;setperm.jan_sales;file'file-specification'dlm=',';putidnumsales_date:mmddyy10.;run;libnameperm'SAS-data-library';data_null_;setperm.jan_sales;file'file-specification';putidnumsales_date:mmddyy10.dlm=',';run;libnameperm'SAS-data-library';data_null_;setperm.jan_sales;file'file-specification';putidnumsales_date:mmddyy10.dsd=',';run;Answer:BQUESTION32ThecontentsoftheSASdatasetnamedPERM.STUDENTSarelistedbelow:nameageAlfred14Alice13Barbara13Carol14ThefollowingSASprogramissubmittedusingthePERM.STUDENTSdatasetasinput:Libnameperm'SAS-date-library';datastudents;setperm.students;file'file-specification';putname$15.@5agerunWhichoneofthefollowingrepresentsthevalueswrittentotheoutputrawdatafile?A.|10|20| 30Alfred14Alice13Barbara13Carol14B.|10|20| 30Alfr14Alic13Barb13aCaro14C.|10|20| 30Alfr14edAlic13eBarb13araCaro14lD.|10|20| 30Alfred14Alice13Barbara13Carol14Answer:BQUESTION33ThecontentsoftherawdatafileTEAMarelistedbelow:|10|20|30Janice10Henri11Michael11Susan12ThefollowingSASprogramissubmitted:datagroup;infile'team';inputname$15.age2.;file'file-specification';putname$15.=5age2.;run;Whichoneofthefollowingdescribestheoutputcreated?arawdatafileonlyaSASdatasetnamedGROUPonlyaSASdatasetnamedGROUPandarawdatafileNooutputisgeneratedastheprogramfailstoexecuteduetoerrors.Answer:CQUESTION34ThefollowingSASprogramissubmitted:data_null_;setold;putsales1sales2;run;Whereistheoutputwritten?theSASlogtherawdatafilethatwasopenedlasttheSASoutputwindoworanoutputfilethedatasetmentionedintheDATAstatementAnswer:AQUESTION35ThefollowingSASprogramissubmitted:data_null_;setold(keep=prodsales1sales2);file'file-specification';putsales1sales2;run;Whichoneofthefollowingdefaultdelimitersseparatesthefieldsintherawdatafilecreated?:(colon)(space),(comma)Answer:BQUESTION36ThefollowingSASprogramissubmitted:dataallobs;setsasdata.origin(firstobs=75obs=499);run;TheSASdatasetSASDATA.ORIGINcontains1000observations.HowmanyobservationsdoestheALLOBSdatasetcontain?A.424B.425C.499D.1000Answer:BQUESTION37TheSASdatasetnamedCOMPANY.PRICESislistedbelow:COMPANY.PRICESprodidpriceproducttypesalesreturnsK12S5.10NETWORK152B132S2.34HARDWARE30010R18KY21.29SOFTWARE2553KL8BY6.37HARDWARE12515DY65DW5.60HARDWARE455DGTY234.55HARDWARE672ThefollowingSASprogramissubmitted:libnamecompany'SAS-data-library';datahwareintersoft;setcompany.prices(keep=producttypeprice);ifpricele5.00;ifproducttype='HARDWARE'thenoutputHWARE;elseifproducttype='NETWORK'thenoutputINTER;elseifproducttype='SOFTWARE'thenoutputSOFT;run;HowmanyobservationsdoestheHWAREdatasetcontain?0246Answer:BQUESTION38TheSASDATA.BANKSdatasethasfiveobservationswhenthefollowingSASprogramissubmitted:libnamesasdata'SAS-date-library';dataallobs;setsasdata.banks;capital=0;doyear=2000to2020by5;capital+((capital+2000)*rate);output;end;HowmanyobservationswilltheALLOBSdatasetcontain?5152025Answer:DQUESTION39Arawdatafileislistedbelow:|10|20|30JohnMcCloskey3571JuneRosesette1043TinekeJones937ThefollowingSASprogramissubmittedusingtherawdatafileasinput:datawork.homework;infile'file-specification';inputname$ageheight;ifageLE10;run;HowmanyobservationswilltheWORK.HOMEWORKdatasetcontain?023Nodatasetiscreatedastheprogramfailstoexecuteduetoerrors.Answer:CQUESTION40ThefollowingSASprogramissubmitted:proccontentsdata=sasuser.airplanes;run;Whichoneofthefollowingisproducedasoutput?thedataportionofeverydatasetintheSASUSERlibrarythedataportionofthedatasetSASUSER.AIRPLANESonlythedescriptorportionofeverydatasetintheSASUSERlibrarythedescriptorportionofthedatasetSASUSER.AIRPLANESonlyAnswer:DQUESTION41ThefollowingSASprogramissubmitted:procdatasetslib=sasuser;contentsdata=classvarnum;quit;WhichoneofthefollowingisthepurposeoftheVARNUMoption?toprintalistofvariablenamestoprintthetotalnumberofvariablestoprintalistofthevariablesinalphabeticordertoprintalistofthevariablesintheordertheywerecreatedAnswer:DQUESTION42WhichoneofthefollowingSASproceduresdisplaysthedataportionofaSASdataset?PRINTFSLISTCONTENTSDATASETSAnswer:AQUESTION43Onwhichportion(s)ofaSASdatasetdoesthePRINTprocedurereport?thedataportiononlythedescriptorportiononlythedescriptorportionandthedataportionneitherthedataportionnorthedescriptorportionAnswer:AQUESTION44ThefollowingSASprogramissubmitted:datawork.test;setwork.staff(keep=jansalesfebsalesmarsales);arraydiff_sales{3}difsales1-difsales3;arraymonthly{3}jansalesfebsalesmarsales;run;Whichoneofthefollowingrepresentsthenewvariablesthatarecreated?JANSALES,FEBSALESandMARSALESMONTHLY1,MONTHLY2andMONTHLY3DIFSALES1,DIFSALES2andDIFSALES3DIFF_SALES1,DIFF_SALES2andDIFF_SALES3Answer:CQUESTION45ThefollowingSASprogramissubmitted:datawork.test;arrayagent{4}$12sales1-sales4;run;Whichoneofthefollowingrepresentsthevariablesthatarecontainedintheoutputdataset?SALES1,SALES2,SALES3,SALES4AGENTS1,AGENTS2,AGENTS3,AGENTS4None,theDATAstepfailsbecausetheARRAYstatementcanreferenceonlydata.None,theDATAstepfailsbecausetheARRAYstatementcanreferencepre-existingvariables.Answer:AQUESTION46ThefollowingSASprogramissubmitted:datastats;setrevenue;arrayweekly{5}montuewedthusfri;<insertDOstatementhere>total=weekly{i}*.25;WhichoneofthefollowingDOstatementscompletestheprogramandprocessestheelementsoftheWEEKLYarray?doi=1to5;doweekly{i}=1to5;doi=montuewedthufri;ADOloopcannotbeusedbecausethevariablesreferenceddonotendinadigit.Answer:AQUESTION47WhichoneofthefollowingstatementsistrueregardingthenameofaSASarray?Itissavedwiththedataset.Itcanbeusedinprocedures.ItexistsonlyforthedurationoftheDATAstep.Itcanbethesameasthenameofavariableinthedataset.Answer:CQUESTION48TheobservationsintheSASdatasetWORK.TESTareorderedbythevaluesofthevariableSALARY.ThefollowingSASprogramissubmitted:procsortdata=work.testout=work.testsorted;byname;run;WhichoneofthefollowingistheresultoftheSASprogram?ThedatasetWORK.TESTisstoredinascendingorderbyvaluesofthevariable.ThedatasetWORK.TESTisstoredindescendingorderbyvaluesofthevariable.ThedatasetWORK.TESTSORTEDisstoredinascendingorderbyvaluesofNAMEvariable.ThedatasetWORK.TESTSORTEDisstoredindescendingorderbyvaluesofNAMEvariable.Answer:CQUESTION49TheSASdatasetWORK.AWARDSislistedbelow:fnamepointsAmy2Amy1Gerard3Wang3Wang1Wang2ThefollowingSASprogramissubmitted:procsortdata=work.awards;bydescendingfnamepoints;run;Whichoneofthefollowingrepresentshowtheobservationsaresorted?Wang3Gerard3Wang2Amy2Wang1Amy1WangWang2Wang1Gerard3Amy2Amy1WangWang1Wang2Gerard3Amy2Amy1WangWang2Wang3Gerard3Amy1Amy2Answer:DQUESTION50TheSASdatasetEMPLOYEE_INFOislistedbelow:IDNumberExpenses2542100.003612133.152198234.342198111.12ThefollowingSASprogramissubmitted:procsortdata=employee_info;<insertBYstatementhere>run;WhichoneofthefollowingBYstatementscompletestheprogramandsortsthedatasequentiallybyascendingexpensevalueswithineachascendingIDNUMBERvalue?byExpensesIDNumber;byIDNumberExpenses;byascending(IDNumberExpenses);byascendingIDNumberascendingExpenses;Answer:BQUESTION51ThefollowingSASprogramissubmitted:libnamecompany'SAS-data-library';procsortdata=company.payroll;byEmployeeIDNumber;run;WriteaccesshasbeengrantedtotheCOMPANYlibrary.Whichoneofthefollowingrepresentshowtheobservationsaresorted?COMPANY.PAYROLLisrecreatedinsortedorderbyEmployeeIDNumber.COMPANY.PAYROLLisstoredinoriginalorder,andanewdatasetPAYROLLcreatedinsortedorderbyEmployeeIDNumber.COMPANY.PAYROLLisstoredinoriginalorder,andanewdatasetCOMPANY.PAYROLLSORTEDiscreatedinsortedorderbyEmployeeIDNumber.COMPANY.PAYROLLisrecreatedinsortedorderbyEmployeeIDNumber,andnewdatasetPAYROLLiscreatedinsortedorderbyEmployeeIDNumber.Answer:AQUESTION52TheSASdatasetQTR1_REVENUEislistedbelow:destinationYYZ53634FRA62129FRA75962RDU76254YYZ82174ThefollowingSASprogramissubmitted:procsortdata=qtr1_revenue;bydestinationdescendingrevenue;run;Whichoneofthefollowingrepresentsthefirstobservationintheoutputdataset?destinationYYZ82174destinationYYZ53634destinationFRA62129destinationFRA75962Answer:DQUESTION53TheSASdatasetEMPLOYEE_INFOislistedbelow:IDNumberExpenses2542100.003612133.152198234.342198111.12ThefollowingSASprogramissubmitted:procsortdata=employee_info;<insertBYstatementhere>run;WhichoneofthefollowingBYstatementscompletestheprogramandsortsthedatasequentiallybydescendingexpensevalueswithineachdescendingIDNUMBERvalue?bydescendingIDNumberExpenses;by(IDNumberExpenses)descending;byIDNumberdescendingExpensesdescending;bydescendingIDNumberdescendingExpenses;Answer:DQUESTION54ThefollowingSASprogramissubmitted:datawork.new;lengthword$7;amount=4;ifamount=4thenword='FOUR';elseifamount=7thenword='SEVEN';elseword='NONE!!!';amount=7;run;WhichoneofthefollowingrepresentsthevaluesoftheAMOUNTandWORDvariables?amount7FOURamount7SEVENamount4FOURamountword4''(missingcharactervalue)Answer:AQUESTION55ThefollowingSASprogramissubmitted:datawork.flights;destination='CPH';select(destination);when('LHR')city='London';when('CPH')city='Copenhgen';otherwise;end;run;WhichoneofthefollowingisthevalueoftheCITYvariable?LondonCopenhCopenhagen''(missingcharactervalue)Answer:BQUESTION56ThefollowingSASprogramissubmitted:datawork.flights;destination='cph';select(destination);when('LHR')city='London';when('CPH')city='Copenhgen';otherwisecity='Other';end;run;WhichoneofthefollowingisthevalueoftheCITYvariable?OtherCopenhCopenhagen''(missingcharactervalue)Answer:AQUESTION57TheSASdatasetnamedWORK.TESTislistedbelow:capacityairplanetypestaff150Large10WhichoneofthefollowingSASprogramscreatedthisdataset?datawork.test;capacity=150;if100lecapacityle200thenairplanetype='Large'andstaff=10;elseairplanetype='Small'andstaff=5;run;datawork.test;capacity=150;if100lecapacityle200thendo;airplanetype='Large';staff=10;end;elsedo;airplanetype='Small';staff=5;end;run;datawork.test;capacity=150;if100lecapacityle200thendo;airplanetype='Large';staff=10;elsedo;airplanetype='Small';staff=5;end;run;datawork.test;capacity=150;if100lecapacityle200then;airplanetype='Small';staff=5;else;airplanetype='Large';staff=10;run;Answer:BQUESTION58ThefollowingSASprogramissubmitted:datawork.one;x=3;y=2;z=x**y;run;WhichoneofthefollowingisthevalueofthevariableZintheoutputdataset?69.(missingnumericvalue)Theprogramfailstoexecuteduetoerrors.Answer:BQUESTION59ThefollowingSASprogramissubmitted:datawork.staff;JobCategory='FA';JobLevel='1';jobCategory=JobCategory||JobLevel;run;WhichoneofthefollowingisthevalueofthevariableJOBCATEGORYintheoutputdataset?FAFA1FA1''(missingcharacterAnswer:AQUESTION60ThefollowingSASprogramissubmitted:datawork.passengers;datawork.passengers;ifOrigPassengers=.thenOrigPassengers=100;TransPassengers=100;OrigPassengers=.;NonPaying=10;TotalPassengers=OrigPassengers+TransPassengers;run;WhichoneofthefollowingisthevalueoftheTOTALPASSENGERSvariableintheoutputdataset?A.100B.110C.200D..(missingnumericvalue)Answer:DQUESTION61ThefollowingSASprogramissubmitted:datawork.passengers;ifOrigPassengers=.thenOrigPassengers=100;TransPassengers=100;OrigPassengers=.;NonPaying=10;TotalPassengers=sum(OrigPassengers,TransPassengers);run;WhichoneofthefollowingisthevalueoftheTOTALPASSENGERSvariableintheoutputdataset?A.100B.110C.200D..(missingnumericvalue)Answer:AQUESTION62ThefollowingSASprogramissubmitted:datapany;setwork.dept1(keep=jobcode)work.dept2(rename=(jcode=jobcode));run;Whichoneofthefollowingistheresult?ThevariableJCODEiswrittentotheoutputdataset.ThevariableJOBCODEiswrittentotheoutputdataset.NeithervariableJCODEnorJOBCODEiswrittentotheoutputdataset.Theprogramfailstoexecuteduetoerrors.Answer:BQUESTION63WhichoneofthefollowingSASstatementsrenamestwovariables?setwork.dept1work.dept2(rename=(jcode=jobcode)(sal=salary));setwork.dept1work.dept2(rename=(jcode=jobcodesal=salary));setwork.dept1work.dept2(rename=jcode=jobcodesal=salary);setwork.dept1work.dept2(rename=(jcode(salsalary));Answer:BQUESTION64ThefollowingSASDATAstepissubmitted:datawork.accountting;setwork.department;lengthjobcode$12;run;TheWORK.DEPARTMENTSASdatasetcontainsacharacte