2023年SASbase考試必備真題附答案

1.TｈeｆollｏwingSASｐrｏgramisｓubmitｔｅd:dataWORK．TＯTAL；sｅtＷＯRK．SALARＹ；byDeparｔmeｎｔＧeｎｄｅr;ifFirst.＜_insｅｒt＿codｅ_>ｔhｅｎPａyroｌｌ=0；Ｐaｙｒｏll＋Wagｅrａt(yī)e;iｆＬａｓt.＜＿ｉnｓert_cｏｄe＿>；rｕn;TｈｅSＡＳdatａsetＷORK．SALARYisｃuｒrenｔlyｏｒdeｒedbyGenderｗｉtｈinDepartmeｎｔ.WhichｉnｓertedcodewiｌlａccumulatesuｂtoｔａlsfｏｒｅａchＧenｄｅrwｉthiｎDeparｔｍｅｎｔ?A.GｅndｅrB．DepaｒｔmenｔC.GｅｎdeｒDepartmeｎｔＤ.DｅpartｍｅntGｅndeｒＡnsｗｅr:A--－－－－--－--－--－-－-－－－-－－－2．GiｖｅnｔheｆollｏwiｎｇrawdaｔareｃoｒdsinＴEＸTFILＥ.TＸT：－｜10|-－--20--－｜-－-－３０Jｏhn,ＦEB,13,25,１４,27，F(xiàn)inalJｏhn,MAR,２6，17,29,１1,２３,CｕrｒentTｉｎａ,ＦEB，15,１８，1２,13，F(xiàn)iｎａlＴｉnａ，MAR,2９,14,19,2７,20,CurreｎtＴhefollｏwingoutｐuｔｉsｄesｉrｅd:ObｓNaｍｅMｏnｔhStatusWeeｋ1Week２Ｗeek3Weeｋ４Wｅe(cuò)ｋ５1ＪｏｈｎＦEBFｉnal$１3＄25$14＄27．２JohｎMARCurreｎt＄26$1７$２９$1１＄23３TinaＦＥＢFinal＄1５＄１８$12$１3．４TinaMＡＲCｕrｒenｔ$29$14$19$27$20ＷhichSＡＳprogramcoｒreｃｔlyprｏｄuｃestｈedesiｒedoutput?A.daｔaWＯRK．ＮUMBＥＲＳ；ｌenｇtｈＮame＄４Mｏｎtｈ$3Staｔus$7;infiｌe'ＴＥXTＦIＬE．ＴXT'dsｄ;ｉnpｕtName＄Month$;ifMｏnth='FEB'ｔhenｉnpｕtWeｅｋ１Ｗeek2Wｅe(cuò)k３Week4Stａt(yī)ｕs＄；elｓｅiｆMontｈ='MAR'theninpｕｔＷeｅk1Ｗeek2Weeｋ３Weeｋ4Wｅe(cuò)k5Stａｔus$；formaｔWeek1-Ｗeeｋ5ｄｏllar６.；run;procprinｔdatａ=WORＫ.NUＭBERS;ruｎ；B.ｄａｔaＷOＲＫ．ＮUMＢERS;leｎｇtｈName＄4Ｍontｈ＄3Sｔaｔus$７；ｉnfｉlｅ＇TEXTFILE.TＸＴ'dlm＝＇,＇miｓｓｏver;inpｕｔName$Ｍｏnth＄；iｆMonｔh＝'ＦEB'tｈeｎｉnputWeeｋ１Ｗeek2Weeｋ3Week4Ｓtaｔus$;eｌseｉｆＭonth='MAR'ｔｈｅnｉnputWeek1Weeｋ2Ｗeek３Weeｋ4Week5Ｓtatｕｓ$；ｆoｒmａｔWeek１-Weeｋ5doｌｌar6.;ｒun;proｃprintdａt(yī)a＝WORＫ.NUＭＢEＲS;run；C.daｔaＷＯＲＫ.NUMBERS;lenｇthNａｍｅ$4Month$３Ｓtａt(yī)us$７;inｆｉle'TＥXTFILE．TＸＴ＇ｄｌｍ=＇,'；iｎputＮamｅ$Ｍonth$@;ifMｏnth='ＦEＢ'theninpuｔWeek1Ｗeek2Wｅe(cuò)ｋ3Weeｋ4Stａt(yī)ｕs＄;eｌｓeiｆＭｏnｔh＝＇MAR＇thｅninputＷｅe(cuò)k1Week２Week3Wｅe(cuò)k4Wｅe(cuò)ｋ５Ｓtaｔus$;formaｔWeeｋ1-Week5ｄolｌａr6.；rｕｎ；pｒocprintdaｔａ=WORK.NUMＢＥＲＳ；ruｎ；Ｄ．ｄataWORK．NUＭBERＳ；lengthName$4Monｔｈ$３Sｔａt(yī)us$７;ｉｎfiｌｅ＇TEXTＦIＬＥ.ＴXT'ｄｓd＠;ｉnpｕtＮamｅ＄Ｍonｔh＄;ifMonｔh='FEB'ｔhenｉｎpｕtWeeｋ1Ｗeek２Wｅe(cuò)k３Weeｋ4Ｓtaｔus$；ｅlｓeiｆMｏntｈ=＇MＡR＇thenｉnputＷeｅk１Wｅe(cuò)k2Wｅe(cuò)k3Wｅe(cuò)k4Wｅe(cuò)k5Stａｔus$;ｆｏrｍatＷeek1-Week５ｄoｌlar６.;ｒｕn;ｐroｃprintdaｔa=WORＫ.NUMBＥＲS;rｕn;Anｓweｒ:C－--－－-－－-－－--－-－--－-－－－-３．TheExcelworkbookＲEＧＩＯＮS．XLＳconｔａｉnsthefollowｉnｇfourｗｏｒksｈｅe(cuò)ts：EＡSTWESＴNOＲTHSOUＴHTｈefolｌoｗinｇprｏgｒamｉssｕbｍｉtted:ｌｉｂnaｍｅMＹXLS'ｒegiｏｎs.xlｓ';WhicｈPROCＰRＩNＴｓtｅｐcorrｅctlydispｌaｙstheＮＯRTＨｗｏrksheeｔ？Ａ.ｐｒocｐrinｔdaｔa=MＹXLS．NＯRＴＨ；ｒuｎ；B.prｏcprinｔdａt(yī)a＝ＭYXLＳ.ＮOＲTH$；rｕn;C．ｐroｃｐｒintdaｔa=ＭYXLS．'ＮＯRTH'e;ｒuｎ;D．pｒｏcpｒｉｎtｄａt(yī)a＝MYXLS．'NORTH＄＇n;rｕｎ;Anｓwer：Ｄ－－－-－－－－--－-－－－--－--－-4．ThefolloｗingSASｐｒogramiｓsｕｂmitted:dataWORＫ.ＤＡＴE_ＩNFO;Daｙ=＂01"；Yｒ=1960;Ｘ=ｍdｙ(Dａｙ，０1,Yr);run；WｈaｔisｔhｅvaｌuｅoftheｖａrｉaｂｌeX?Ａ．thenｕmerｉcvalｕe0B.ｔｈeｃhａｒａctervaｌuｅ＂01０1１9６０"C．a(chǎn)ｍiｓsingvaluｅｄｕetosｙｎtａxeｒｒorsD．thesｔepｗｉllnotｃompileｂecauｓｅofｔhecharａｃteraｒgumentinthｅmｄyfuｎｃtion．Ａnsｗer:A－--－－-－--－－--－－--－--－５.Ｗhｉcｈｓtａt(yī)emenｔｓpｅｃiｆiesthatrecｏrds１ｔhroｕｇｈ１0aretobｅrｅadfｒｏmthｅrawdａｔａfｉlecuｓｔoｍｅｒ．txt？A.infile'ｃｕsｔoｍｅr.txt＇1－10；B.input'ｃｕｓtomer.txt'stｏｐ@１０；C.ｉnfｉlｅ'ｃuｓｔｏmer．txt'oｂs＝10；Ｄ.ｉnpｕt＇custoｍer.ｔｘt＇ｓtop=１０;Ａｎsｗｅr:C--－-－-－－－－-－-－-－－６．ＡftｅｒaSＡＳｐｒoｇｒaｍiｓsuｂｍitteｄ,thefｏlｌowinｇisｗrｉtｔenｔoｔｈeSＡＳlog:1０1datａWOＲK.JANUARY;10２ｓｅtWＯＲＫ.ALLYＥAR(kｅｅp＝ｐrｏducｔmoｎthｎum＿SｏldCｏｓt);10３iｆMontｈ='Jａn'ｔhｅnoｕｔｐｕｔＷORK．ＪAＮUＡRY；104Sａｌes=Ｃost*Ｎｕm_Soｌｄ;１0５kｅe(cuò)ｐ=ProducｔSａｌes；－－22EＲＲＯＲ22－322:Ｓynｔａxerrｏr,ｅｘpectiｎgｏneｏfｔhｅfｏllｏwｉng：！，!！，&,*，＊*,+，-，,＜=，<>,=,>，>=，AND,EQ,GＥ，GT,ＩN,ＬＥ,LＴ，MＡＸ，MIN，NE，ＮG,NＬ,ＮＯTIＮ,OR,＾＝，｜，｜|,~=．10６ｒuｎ;WhatｃｈanｇessｈoｕldｂeｍadetｏtｈｅＫＥEPsｔatｅｍeｎtｔoｃｏrreｃｔtｈeerrｏｒsiｎtheＬＯG?Ａ.keep=（ProｄuｃtＳａlｅs)；B．keepＰｒｏdｕcｔ，Ｓａlｅｓ；C．keep＝Ｐｒoduct，Saｌｅs；Ｄ.ｋeeｐPｒｏduｃｔSales;Answｅr：Ｄ-－－－－－－－--－－－－－－７.ＷhicｈofthefollowiｎｇｃｈoｉceｓｉｓanuｎaｃceptａbｌｅODＳｄeｓtiｎationfｏrprｏｄuｃｉnｇoｕｔpｕtｔｈａt(yī)cａｎbeviewediｎＭicｒoｓofｔExｃｅl？A．ＭSOFFIＣE２KＢ．EXCEＬXＰC.CSVＡＬLＤ.ＷIＮＸＰAnsｗeｒ：D-－-－－--－－-－-－－－－-－－－-－8.TheSASdａt(yī)aｓeｔnamedWＯＲK.SＡLＡRYｃontaiｎｓ1０oｂsｅrvａｔionsｆoｒeａｃhｄｅｐarｔment，andiscurreｎｔlyorderｅｄbｙDepａrtment.TｈeｆolｌｏwingＳAＳpｒoｇｒamiｓｓubmｉtteｄ:dａｔａWＯRK.TOTAL;seｔWＯＲＫ.SALAＲY（keｅｐ＝DepartmentMoｎｔｈｌyWagｅRatｅ)；byDeｐａｒtｍeｎt;ifFｉrst．Deｐａrｔment=１theｎPayrolｌ＝0；Ｐａyrｏｌｌ+(MonthｌyWａｇeＲａｔe＊１2)；ｉfLast.Dｅpaｒtｍeｎt＝1；ｒｕn;Wｈichsｔａｔemeｎｔisｔrue?A.TｈebystatemｅｎｔiｎtｈeDATAsｔepcａｕsesasyｎtaxerｒor．B.TｈesｔatｅmentＰayroｌl+(ＭoｎｔｈｌyＷaｇｅRate*１２);iｎｔhedａt(yī)astepcausesasynｔａxerｒｏr.C．ThevaｌｕesｏfthevariabｌePａｙｒolｌrｅｐｒesｅntｔhｅmｏｎthlytotalfｏｒeacｈｄｅpartmentintｈeWORK.SALＡRYdａｔaｓeｔ.Ｄ.TｈevａluｅｓｏｆthevａriableＰａyrollreprｅｓenｔaｍｏｎtｈlｙtｏtalforallvａlｕesｏfＷAGＥＲATＥｉntｈeWＯRＫ.SＡＬＡRYdａt(yī)aset．Anｓｗeｒ:C－－－－--－－－--－－1０.ThefoｌlｏwｉｎgSＡSｐrograｍｉssuｂmitteｄ：daｔaWＯRK.ＲＥＴAIL；Ｃｏsｔ＝'$2０，0０0'；Ｄｉscounｔ=．10*Cｏsｔ；ｒｕn;Whatｉstｈerｅsuｌｔ？Ａ．ＴhevａｌｕeｏfthevariａbleDiｓｃｏｕnｔintｈeｏutpｕtdataseｔis２0２３.NomeｓｓaｇeｓarewrｉtteｎtotheSＡSlog.Ｂ.ＴhｅｖalueofthｅvａriａbｌｅＤｉｓcountinthｅｏutpｕtdatasetiｓ20２3.Ａnotｅthａt(yī)convｅｒsionhastakｅnplaceｉswｒittｅnｔoｔhｅSＡSｌoｇ.C.ＴhevaluｅofｔhｅvａrｉａbｌeDｉsｃouｎtiｎｔheｏutｐｕｔdａt(yī)asｅtｉsｍisｓing.ＡｎｏteｉｎtｈeSAＳlogrｅfｅｒｓtoinvａｌidnumeｒicdata.Ｄ.ThｅｖariaｂleDiｓcｏuｎtinthｅouｔpｕtｄａt(yī)ａseｔissettozeｒo．NoｍessagｅsarｅｗｒiｔtentｏtｈeSASlog．Ａnswer:Ｃ由于有一個(gè)$符號－－-－--－－－-－－-－-－-－--－--－-－－1１.GiventheexｉstｉngＳASｐrogram：prｏcforｍａt(yī)；valueagegrpｌoｗ-1２＝'Pre-Teｅn'13－ｈigｈ=＇Ｔｅe(cuò)n';rｕn;procmeａｎｓｄaｔa=ＳＡＳHELＰ.CLＡSS；varHｅｉgｈt;cｌａsｓSexAｇe；formａｔＡgeaｇegｒp.；ｒun;Whichsｔaｔementinｔｈｅｐrｏcmeaｎｓstepｎeeｄstobｅmｏdifiedoraｄdeｄｔogenｅraｔeｔhefoｌlowingresults:AｎalysisVaｒiabｌe:ＨeightNSｅｘＡｇeＯbsＭｉｎiｍumＭaxｉmumMeａn-－－－－－－-－-－-－－－-－－－－－--－-－－－－－－－ＦＰｒe-Ｔeen3５1.359．8５5.８Tｅe(cuò)n656.５６６.563．０MＰre-Tｅe(cuò)n４５７.36４．８59.７Teen662.57２.0６６.８--－-－－-－－--－－--－－-－－-－－－－－－--－－-Ａ.vaｒHeigｈｔ／nｏbsmｉｎｍａxmeanmaｘdec＝1;Ｂ.ｐrocmeansdata＝SASHEＬP.CＬASSｍaxdec=1;C.procmｅａnsdatａ=SASＨELP．CＬAＳＳｍinmaxmeaｎmaｘdｅｃ＝1;D.oｕtｐutｎobsmiｎmａxｍｅａｎmａｘdｅc=1；Ansｗer:C－-－－-－－－--－--－--－－－-－－－－-１２.TheExｃelwｏｒkbｏokQTＲ1.XLＳconｔaｉnｓtheｆollowiｎgthrｅｅｗｏｒｋｓｈeｅｔｓ:JANＦEBMARＷhichstatementｃorrｅcｔlｙａsｓｉｇnsaliｂrarｙreｆeｒeｎcetoｔheExceｌwｏｒkbook?A.libｎameqｔrdａt(yī)a'qtr1．xls＇;B．ｌibname'qｔｒ1.ｘｌs'sｈｅe(cuò)ｔｓ=３；Ｃ．libｎaｍｅjaｎfebｍａｒ'qtr1.xls'；Ｄ.liｂｎamemyｄａｔａ'qtr1．xls＇ＷＯＲK.ｈeｅts＝(ｊaｎ,feb,mar)；Answｅr：A－－－－－－-－-－-－－－－－－－--１３．TheｆｏlloｗiｎgSＡSｐroｇｒaｍｉsｓubmiｔｔeｄ:datａWORＫ.TEST；sｅtＷＯRK.MEASLES（kｅe(cuò)p=JanptFebptＭａrpt）；aｒrayＤifｆ{３｝Diｆcouｎt1-Difcoｕnｔ３;ａrrayＰatｉｅｎts{３}JanptFebptMarpｔ；rｕｎ;Whａt(yī)newvａriablesaｒecreａt(yī)eｄ？A.Dｉfcount1,Ｄiｆcoｕnt２ａｎdDifｃounｔ3B．Diｆｆ1,Diff2ａｎｄDiff3Ｃ.Ｊanpt，F(xiàn)ebpt,ａｎdMａｒｐtＤ.Ｐatients1,Ｐａt(yī)ｉents2andPａt(yī)ienｔｓ3Answer:Ａ--－－--－－－－-－－－--－－-－－-－-－14．WｈichoｆthｅfoｌlｏwingｐrogrａｍscorrecｔlｙｉnｖokesthｅDAＴＡSteｐDebｕｇger：Ａ.daｔaWORK.TESＴdebuｇ;ｓｅtWＯＲK．PＩLOＴS;Stａt(yī)ｅ=scan(citySｔａt(yī)e,2，'＇);ｉfSｔatｅ='NE'tｈｅnｄeｓcripｔion='Cｅｎtrａｌ';ｒun;B.dataＷOＲＫ．TESＴｄｅｂuggｅr;ｓｅtWＯRK．PIＬOTS;Stａｔe=sｃan(ｃｉtｙStatｅ,2,＇＇）;ifSｔａt(yī)e=＇ＮE'tｈｅndescｒipｔion='Ceｎtｒaｌ＇;run;C.dａt(yī)aＷＯＲＫ.TEＳT／dｅｂuｇ；sｅｔWＯＲＫ．ＰILOTＳ;Statｅ＝sｃａn（ｃityState，２，＇＇);ifState＝＇NE＇thenｄescripｔｉｏn＝'Ceｎtral'；run;D.ｄａｔaＷORＫ.TEＳT/ｄebｕgｇｅr；ｓetＷORK．PILOＴＳ;Ｓｔaｔｅ=ｓｃan(ｃitｙStａt(yī)ｅ,2,＇');ｉfStａt(yī)e='NE'thendｅsｃrｉpｔｉon='Ｃｅｎtrａl＇；run；Answｅr：c-－－-－--－－--－－-－－－－1５.Ｗｈｉchｓtａt(yī)ｅmｅnｔiｓtrueｃｏncｅrningthｅSASautｏｍａt(yī)ｉcｖarｉａbｌｅ＿ERROR_?A．Ｉtcａｎnotbeuｓedinａnif/theｎcｏｎｄition.B.Itcannｏｔbｅusedinaｎａｓｓignmenｔsｔａｔemｅnt.Ｃ．Ｉｔcａnbｅｐｕtintｏａｋeｅpstatemｅntｏｒkeep=opｔioｎ．D.Itｉｓauｔomａt(yī)ｉcallyｄroｐｐeｄ.Answer：Ｄ－-－--－－－－－－-－－－－-－－16．TheｆｏlｌｏｗｉnｇSASｐrogｒａｍiｓｓuｂmitteｄ：dataWORK.DATE_ＩＮFO；Ｘ＝＇04jul２０23'd；ＤaｙＯfＭｏnth=daｙ(ｘ)；MｏnthOfYｅar＝ｍonｔh(x);Yｅａr=year(ｘ);rｕｎ;WｈattypｅsoｆvariａblesarｅDａyOfＭｏnth,MonthOfYear,ａnｄYear?A．DayOｆMｏnth,Yeａr,andMｏnthOfＹeａrａrecharacｔｅｒ.B.ＤａyＯfMｏnｔｈ，Ｙear，aｎdMoｎthOfYeararenuｍeric.C.DayOfMｏｎthanｄYearａrenｕmｅrｉc.MoｎthOfYeａｒｉschａｒactｅr.D.DayＯfMｏnｔh,Year,ａｎdMonthOｆＹearareｄatevaｌues.Anｓweｒ：Ｂ-－－－--－－－－-－17．Giｖentｈｅｆollowiｎgｄatastep：ｄatａＷＯRＫ．GEO；infiｌedaｔａｌines;ｉnputＣitｙ$20.；iｆCiｔy='Tulsa'thenSｔａｔe＝'OK';Ｒｅｇｉon＝'Ｃeｎtrａl';iｆCiｔｙ＝'ＬosAngeｌes'ｔhenＳtate＝'CA＇;Region＝'Westｅｒn'；ｄataｌineｓ；ＴulsaLosAｎgeleｓBaｎgｏr；run;Ａｆｔerdａt(yī)asteｐexeｃutioｎ,whatwilｌdaｔａsｅtWOＲK.GEＯcｏntａin?A.CityStatｅReｇｉon-－-－－－－－--TｕｌsaOKWesternLosＡngｅｌesＣＡWesternBａｎｇｏｒＷｅｓternＢ.ＣｉtyStateＲｅgiｏｎ－－－－－－--－TulsaＯＫWeｓteｒｎLosAngeｌesCAWｅsterｎBanｇorC．CityＳｔatｅＲｅgioｎ－TulsaＯKCeｎtｒａｌLosAｎgｅlｅsＣAＷesternＢanｇoｒWestｅrnD.CiｔyStatｅRegion－－－--－－ＴｕlsaOKCentｒalLosＣＡWestｅrnBａngorAｎswｅr：A－－--－－--－-－－－--－-－－--－--１8.WｈiｃhsｔaｔeｍentdｅscriｂesacharacｔeristicｏｆｔheSAＳａutｏmａｔicｖａriａble_EＲRＯR_?Ａ.The＿EＲＲOR_variaｂｌemaｉntainsａcountofｔｈeｎuｍberofdａt(yī)aerrorｓｉnaDATAｓｔep.B．The_ERＲOR_vaｒiablｅisaｄdedtｏthｅprogrａmdaｔavecｔoｒａｎｄbecomesｐartofthｅｄataｓeｔbeiｎgｃrｅａt(yī)ｅｄ.C.Thｅ_ＥRＲOR_varｉabｌecanbeuｓediｎｅxpressｉonｓintheＤAＴＡｓtep.D.Ｔhe_ＥＲROＲ_ｖariaｂｌecoｎtaｉｎｓtｈeｎuｍberｏftheｏbsｅrvａt(yī)ioｎtｈａｔｃausedｔｈｅdaｔaerrｏr.Aｎswｅr:Ｃ-－-－--－--－－-－-－-－－-－-－－--－1９.ＴhｅＳASdataｓetWOＲK.ONEconｔａinｓａｎｕmｅricvariaｂlenａmedNｕｍandａchａracteｒｖarｉａｂｌenaｍｅdＣhaｒ:WORK．OＮENumChａｒ－-－-－-－1233２3１7７ＴhefｏlｌｏｗｉngSAＳprogrａmissubmｉtｔｅd:proｃpｒiｎｔｄata=ＷORＫ.ONE;wｈｅｒeNum='１＇；rｕn；Ｗｈａt(yī)iｓoｕtput?A.ＮｕｍＣｈar－--１23Ｂ.NumＣhar--－－1231７7C.ＮｕmChａr１2332３17７D．Nooutpuｔｉsgenerａt(yī)ｅd.Aｎsｗｅｒ:Ｄ--－-－--－－--－－－－－－-－－-－－－20．ＴheｄataseｔWORＫ.RＥALEＳTATEｈａstｈevarｉaｂlｅLｏcalＦeewｉtｈaformaｔｏf９.anｄａvariableＣounｔryFeewitｈaforｍａｔof7．；TｈefollｏwinｇＳASprogramｉssubmiｔｔｅd：dａｔａWＯＲK.FＥE_ＳTＲUCTURＥ;ｆorｍａt(yī)ＬocａlFeeＣoｕnｔｒyＦeｅｐeｒｃent7.２；ｓｅtＷORＫ.REALEＳＴＡT;LocalFｅｅ=LｏｃａｌＦｅe(cuò)／1０0;ＣounｔryFee＝ＣountｒyFee/1０0;rｕn;WhaｔaretｈｅｆｏrmatsofｔhｅvａriableｓLOCAＬFＥEａnｄＣOUNTＲＹＦEEiｎｔheouｔpuｔdataｓet?A.LocaｌFeeｈasｆoｒｍatｏf9．a(chǎn)ndCoｕｎｔryFｅe(cuò)hasafoｒｍａt(yī)ｏf7.B.LoｃalFｅｅhaｓｆorｍａt(yī)oｆ９．a(chǎn)ndＣｏuntryFｅｅhaｓaformatｏｆperceｎｔ7．2C．BｏthLoｃａlＦeeａndCｏｕｎｔｒｙＦｅｅhavｅaformatｏfpeｒcenｔ７.２Ｄ．Theｄａt(yī)ａｓtｅpfailsexeｃuｔｉｏn；ｔｈｅreisｎoformatfoｒＬocａlＦee.Aｎｓwｅr:C-－-－－－－－－－－-21.GivenｔhｅＳASdataｓｅtＷORＫ.PRODＵＣTS：ＰrodIdPｒicｅＰroｄｕctＴypeSaｌesRｅｔurnｓ-－--－-－-－－－－--Ｋ１2S９５.５0OUTDＯOR15２B132S２．９９CＬOTHＩＮG30010R18KＹ２51．99EQUIＰＭＥNT２553ＫL８BＹ６．３9OUＴＤＯＯR１25１５DY6５ＤW5．６0ＯＵＴＤOOＲ455DGＴＹ23３4.５5EＱUIPMEＮＴ6７2ＴhefolｌoｗinｇＳASprｏｇｒamissubmｉｔteｄ:dａt(yī)aWＯRK.OUTDＯORＷORK.CLOTHWORK．ＥＱUIP；sｅtＷＯＲK．PRＯDＵCTＳ;ifＳalesＧT30;iｆＰroｄｕctTｙｐeEQ'ＯUTDOOR'theｎoｕtｐutWOＲK.ＯＵTＤＯOR;ｅlsｅiｆPrｏｄｕctTｙｐeEＱ＇CLＯTＨIＮＧ＇ｔhenｏuｔputWＯRK.CLOTH；ｅｌｓｅifProdｕcｔTypｅEQ'ＥＱＵIPMEＮＴ＇thｅnoｕtpuｔWＯRK.EＱUIP;ｒun；Ｈｏwｍanyｏbserｖａt(yī)ionsｄoeｓｔｈeＷORＫ．OＵTDＯORdataseｔcontａｉn？Ａ.１B.2C.３Ｄ．6Ａnsｗer:B--－-－－－-－－-－－-－－－－2２.ＷhｉｃhstｅpdispｌayｓalisｔｉnｇofａｌｌtｈeｄatａｓetｓinｔheWＯRKｌｉｂｒary?Ａ.ｐrｏcconｔentslｉb=WＯＲKrun；Ｂ．ｐrｏｃconｔeｎtsliｂ=WORＫ．ａll；rｕn;C．ｐｒocconteｎtsdata=WORK._all_；rｕｎ；D.procｃontｅntｓdａｔa=WＯＲＫ_ALＬ_;run;Ａnswｅr:c－－－－－-－-－－－23.WhichisａvaliｄLIＢNAMＥstａt(yī)emeｎｔ?A.lｉbnａｍe"＿SAＳ_ｄaｔａ_libraｒy_ｌｏcatiｏn_";Ｂ.sasdataｌｉｂｎame＂_SAＳ_dａt(yī)ａ＿ｌiｂｒary_lｏcａt(yī)iｏｎ_＂;Ｃ.liｂnaｍｅsaｓdａｔa＂_SAＳ＿ｄata_lｉbｒａｒy_ｌｏcatｉon_＂;D.liｂnaｍeｓaｓdａｔasas"_SAS_daｔａ＿ｌibｒarｙ_location_"；Ａｎｓｗer:Ｃ－－－--－-－－－--－-－－－--24．Gｉveｎthｅfｏｌｌｏｗinｇrawdataｒecｏrｄｓ：|1０－--|－--－20－--|３0Suｓａn*12/29／１９70*１0Ｍｉｃhaｅl＊*６Thｅfollowingoutputiｓdesｉred:Ｏｂsemployeebdateyeａrs１Sｕsaｎ4０1５1０2Miｃhaeｌ.6ＷhicｈSASｐroｇｒamcorreｃtlｙrｅaｄsiｎtherａｗdata?A.datａｅmｐloyeeｓ;iｎfｉle'ｆilesｐecification＇dlm＝'＊＇;inｐutemployｅe(cuò)$ｂdatｅ:ｍmddyy1０．ｙeａｒs;run;Ｂ．daｔaeｍplｏｙees；infilｅ＇fiｌeｓpecｉfｉcａｔion'ｄｓd='＊＇;inｐuｔeｍployｅe(cuò)＄ｂdａt(yī)emｍddyy10.yｅarｓ；ｒｕn；C．ｄaｔａemployｅe(cuò)s;ｉｎfiｌｅ'fileｓpecifiｃatｉｏn＇dlmｄsd;ｉnpｕtemplｏｙee$bdａt(yī)ｅｍmddyy1０．yeａrs;run;D．daｔaｅmpｌoｙees;iｎfｉle'ｆilespｅcifｉcａt(yī)ioｎ'dlｍ='*＇ｄsd;inｐutｅmplｏyｅe(cuò)$bdate:mmｄdyy１0．yearｓ;ｒuｎ;Aｎswｅｒ:D－--－-－－－-－－－--－-－--－－－－－--－25.Giｖenｔhｅfolｌowingcoｄe：proｃpｒiｎtdaｔa=ＳAＳHELＰ．CLＡSＳ(ｆirｓｔobs=５obs＝15)；ｗhereSｅx='M';run;Ｈoｗｍanｙｏｂｓervatioｎｓｗｉｌｌｂedisｐlayｅｄ?Ａ.11Ｂ.１5C．１0orｆewerD.11ｏrｆｅｗerＡｎsｗｅr:D－－-－-－－－－－-２6.ＷhｉchsｔｅpｓortstheｏbseｒｖationsofaｐｅrmａnｅnｔSASdaｔaｓｅｔｂytwovａｒiablｅsａndｓtｏrｅstｈｅｓortedｏｂsｅrvａt(yī)iｏnsinaｔeｍpoｒａｒySAＳｄaｔａｓet?A.procsｏrｔout＝EMPＬOYEEＳdａt(yī)a＝ＥMPSORＴ;byLnａｍｅaｎdFｎａmｅ;rｕｎ;B.pｒoｃsｏrtdata＝ＳASUＳＥR.EMPLOＹＥEＳout＝EMＰＳＯRT;byＬｎameＦnａme;run;Ｃ.procsortｏｕt＝SＡSUSEＲ．ＥMＰＬOYEESｄata＝WORK.ＥMPSＯRＴ;byＬnａmeFnａｍe；run；D.ｐrocsortｄaｔａ=SAＳUＳER．EＭPLOＹEＥSout=SASＵSＥＲ．ＥMＰSORT;bｙＬnameandFnaｍe;ruｎ;Anｓweｒ:B－－--－－--－-－－--－－－－－－２7.GivｅnｔheSASｄatasetWORK．ＴＥMPＳ：DａyMonｔhＴｅmp-－－－--－-1May7５１5Ｍay7015Jｕne8０3Ｊune７62July851４July8９Thｅｆolｌoｗinｇpｒograｍissubmitｔed：prｏｃsortdａt(yī)a=WORK.TEMPＳ；ｂydescｅndingＭontｈＤay；run;ｐrｏcpｒintdａt(yī)ａ＝WOＲK.TEMPS;ｒun;Whichoutpｕtiｓｃorｒｅｃt?A．ＯbsＤaｙＭonｔhTeｍp－--－--－-－----－-12Jｕｌｙ852１4July８９３3Junｅ７6415Junｅ8051May７5６１５Mａy７B.ＯｂsDaｙMontｈTｅmp－-－-－--－-－--－-－１1Mａy７522July8533Junｅ7641４Ｊuly8９5１5Maｙ７0615Jｕｎｅ８０C．ObsDayＭoｎｔhTemｐ－--－－－-－－11Ｍaｙ75215Mａｙ70３3June７6415Ｊune805２Jｕlｙ856１4July89D.ObｓDayMontｈＴemｐ－---－－－--－-－11５Ｍay７0２１May75３１５Ｊuｎｅ８043Ｊｕne７65１４Julｙ896２July8５A(chǔ)ｎｓwｅr：Ｃ－--－－-－--－-－－－-－-－－２8.ＧivｅｎｔheSASｄataｓｅtWOＲＫ.Ｐ20２3：ＬocaｔionPop2023-－－--－－-－Alaskａ6２6931Dｅlawaｒｅ7８3５95Ｖermoｎｔ６０8８26Ｗyoming493782andｔｈeSＡSｄａｔａsetWＯRK.P2023:ＳtatｅＰop２02３－－---－－－--Ａlaｓｋa６86２９3Delawａｒe8７３0９２Wyomｉnｇ５3266８Ｔheｆｏlｌoｗｉｎgouｔpuｔｉsｄesired:ＯbsStaｔePop2０２3Pop2０２3Ｄifferｅnce１Ａlaｓｋａ6269３1686２9３５93622Dｅｌaｗarｅ78３595８7３０928９４９7３Wyoming49378253２6６838８８6ＷhiｃｈＳＡSprｏgｒamcoｒreｃｔlyｃｏmbinｅsｔheｄａt(yī)ａ？A.ｄataｃompａｒｅ;mｅrgeWORK.Ｐ２02３(in=_ａLｏcａt(yī)ion=Stａｔｅ)WORＫ．P2023(in=_b）;bｙStaｔe;if_aand＿b；Differenｃe＝Ｐop2023－Ｐoｐ2０２３;run;B.datａcｏｍpａre；mergeWORK．P2023（rｅnａme=(Locaｔiｏn=State）)WORＫ．P２0２3；byＳtate;ｉｆ_aａnd＿b；Diffｅreｎｃe＝Ｐoｐ2023－Pop2０２3；ruｎ;C.datacomparｅ;mergeＷＯＲK.Ｐ2023(in=＿aｒｅnamｅ＝(Locatiｏｎ=Statｅ))WOＲK．P2023(iｎ=_b);byＳｔaｔe；if_ａanｄ_b；Difference=Pop2０2３-Pop２０2３;ruｎ;D.datacｏｍｐaｒｅ;ｍergeWOＲK.Ｐ２0２３(in＝＿ａ）(reｎａme=(Locaｔiｏn=Ｓtate))ＷＯRＫ.P2023（in=_b);bySｔaｔe；ｉｆ_ａand_ｂ;Ｄｉfｆeｒencｅ=Ｐｏp2023－Pop2023;rｕn;Ａnsｗｅｒ:Ｃ－--－-－－--－-－－－－－-－－--－－2９.ＴhefollｏwinｇSＡSｐrogramiｓsuｍｂｉｔｔed:datａＷORＫ．INＦＯ;infｉle＇DＡＴAＦILＥ．TXT';ｉｎｐuｔ＠１Compaｎy$20．@２5Stａt(yī)ｅ＄2．@;ｉfSｔatｅ＝''ｔheninpｕｔ@30Ｙear;eｌseｉｎｐuｔ@30ＣitｙYear;ｉnpｕｔNumEmｐlｏｙeｅs；run；Howｍanyrａwｄａt(yī)aｒecｏｒdsarｅｒeadduringeacｈiｔeｒatiｏｎoｆｔheDATAsteｐ?A．１Ｂ．２Ｃ.3Ｄ．4Aｎsｗer:Ａ－-－－－－-－－－３０．You'rｅａt(yī)ｔeｍptinｇｔoｒｅａdaｒａwｄatafileaｎdｙoｕｓｅe(cuò)thｅｆollowinｇmessａgｅｓdiｓplaｙediｎtheSＡSＬog：NOTE:Ｉnvａliｄｄａt(yī)afｏrＳalａryiｎline415-2３．RULE：－-－-+－－－－1-－--＋--－-2－+－3－－-－+-－－-4-－－-+－--－5--4１2023４F4６#３０11MAY１９５433Employｅe(cuò)＿Id=120234emplｏyｅe(cuò)_ｇender=FSalary＝.bｉrth_ｄａt(yī)e=－2０6１_EＲＲＯR_=１_N_=４ＮOＴＥ:20reｃordsweｒｅｒｅaｄｆrｏmｔhｅiｎfiｌe'c:\employees.dat'．Theminimumrecordlｅnｇthｗas33.Ｔhemａximｕmｒecｏrdlｅngｔhwａs33．NOTE:ThｅdataseｔＷORK.EMＰLOYＥEＳhａｓ20observatｉonｓand4variａbｌes.Ｗｈａt(yī)dｏesitmeａn?A.Aｃoｍｐilererｒoｒ,triｇgeredbyanｉｎvａliｄcharａcｔerfortheｖaｒiableSalａry.B.Anｅxｅcutiｏnｅrror，ｔrigｇeｒｅdbｙａｎｉnvalｉdcｈaracterfｏrthevaｒiablｅSalary.C.Ｔｈｅ1ｓtoｆｐoｔentｉallyｍanyｅｒroｒｓ,thｉsｏneoｃｃurｒiｎgｏnthe4ｔhｏbseｒvａt(yī)ion.D.ＡnｅｒrorontｈeIＮPＵTｓtatemenｔspeｃｉficａｔionforreａdｉngｔheｖaｒｉａbｌeＳalaｒy.Ａnsweｒ：Ｂ－－－－－－-－-－--－－-－－-31.GiｖeｎｔｈefolｌｏwiｎgｒaｗdatａreｃordｓiｎDATＡFIＬＥ.TXT:－－－-｜10--－|--－-2０-－-|--－-３０Kim，Ｂａskｅtbａll,Gｏlf,TenｎisBｉll,ＦootbalｌＴｒacy，Sｏcceｒ，ＴrackTｈeｆolloｗiｎｇprｏgｒamissｕbmｉtted：ｄatａWORＫ．SPORTS＿INFO；leｎgthＦnaｍｅＳｐort1-Spoｒt3$１0;infｉle＇ＤATAFILE.TXＴ'dlm='，＇；ｉnpｕtFｎame$Ｓｐorｔ１＄Sporｔ２$Sport3$；run;procｐrinｔｄａt(yī)a=WＯRＫ．SＰORTＳ_INFO;ｒun;Whiｃhoutputiｓcorrｅctbasedonthesubmittedpｒoｇrａｍ?Ａ.ＯｂsFnaｍeＳporｔ1Ｓpｏrt２Ｓｐorｔ31KｉmＢａsｋｅtbalｌGolfTｅｎnｉs2BillFｏotbalｌ3TｒaｃySocｃｅrTrackＢ.ObsFnａmeSpｏrt1Ｓｐｏrt2Spｏrt3１ＫｉmBasketballGolfTenｎｉs2BilｌＦootballFooｔｂalｌＦootball3TraｃｙSocｃerＴraｃkＴｒackＣ．ＯbsＦnaｍｅＳpｏrt１Ｓpoｒt２Sport31KiｍＢasｋｅtbａｌｌＧoｌfTｅnniｓ2BilｌＦooｔballＴrａcySoｃｃｅrD.ＯbsFnaｍeSpｏrt1Spoｒt2Sｐort３1KｉｍBasｋetbaｌlGoｌfTeｎnis２BillFｏotbａｌlＡｎsweｒ：Ｃ－－-－－-－－--－--－－－－－－－3２．Consｉdｅrthefolloｗingｄatastep:dataWＯRＫ.NＥW;sｅtＷＯRK.OＬD;Cｏuｎｔ+1；rｕn;ＴhｅvａｒiabｌeＣｏuｎtiｓｃreatedusiｎgasuｍｓｔａt(yī)ement．Wｈichstaｔｅmentregarｄｉｎgthisvａriａbｌeｉstruｅ?Ａ．Iｔｉｓａsｓignedavａluｅ０ｗheｎｔheｄａt(yī)asｔepbeginseｘecutｉon．Ｂ．Iｔiｓａssｉgnedａvａlueｏfmisｓingwhenｔheｄａt(yī)aｓtepbeginｓｅxｅｃutiｏn.C.Iｔiｓaｓsignｅdavaｌｕｅ0atｃoｍpiletiｍe.Ｄ．Iｔisassｉｇｎedaｖalｕｅofｍｉssingａｔcｏｍpiletｉmｅ．Anｓｗer：Ｃ－--－－－－－－－－－－－-－3３．TheｆollowinｇSＡSprograｍissｕbmitｔed：daｔaＷＯRK.TＥＳT;ｓeｔWOＲＫ.PILOＴS;iｆJｏｂｃode=＇Ｐiｌot２'thenDｅscｒiｐｔioｎ='ＳeｎiorＰilｏt';elseDeｓcriptｉoｎ＝＇Unｋｎoｗｎ'；ｒun;ＴｈｅvａlｕｅｆortｈeｖariableJobcｏｄeｉs:PＩLＯT２.WhaｔｉsthevaｌｕｅｏfｔheｖaｒｉabｌeＤescrｉptiｏｎ?A.PILOT2B.UnknownＣ.ＳｅnioｒPilotD.''（ｍｉｓsingｃhａractｅrｖａlｕｅ)Answer:B－－--－－－－--－-－－－-－－－－-－－－-－--－-－--3４．Aｕseｒ－ｄｅfinedforｍatｈaｓbｅｅncrｅatedusinｇｔheFＯＲMＡＴｐrｏｃeｄｕrｅ.Hｏwiｓｉtstｏｒｅd？Ａ．iｎaSAScaｔalogB．inａmeｍoryresidｅnｔlooｋuptableC．ｉｎaSASdaｔasｅtiｎtｈeＷＯRKlｉbｒaｒyD.ｉnａSAＳdatasetiｎａpermaｎenｔSＡSdatａlibｒaryＡnｓwer:ATheｓeforｍaｔsmustbeｓｔoｒedｉnｔｈeWOＲＫ.FORMAＴSorSAＳＵSＥＲ.FORMATScaｔａｌog－--－－--－--－--－－－－－－－--－-35.givｅntｈｅＳASｄａt(yī)aseｔSＡＳDATA．TWO:XY－-－-523１56ThefollowiｎｇＳASpｒｏｇramiｓsubmiｔｔed:ｄataＳＡSUＳＥR.ＯNESＡＳUSER.ＴWＯOTHER;seｔSＡSＤATA．TＷO；iｆXeq5theｎoｕｔputＳＡＳUＳER.ONＥ;ifYlt5ｔheｎｏｕtpuｔSAＳUSER．TWO;outpuｔ;ｒun；Ｗhatisthｅresult?A.datａsetＳＡＳUSEＲ.ONＥhａs5ｏｂservatｉｏnsｄaｔaｓｅtSASUＳＥR.ＴWＯｈaｓ5obｓerｖatiｏnsdaｔａsetWORK．ＯTHERhas３obseｒｖatioｎsB．ｄataseｔSASUSＥＲ．ONＥｈａs2obseｒvaｔioｎsｄatasetSAＳUSEＲ.TWＯｈａs２observationsdaｔaｓｅｔWORＫ.OTＨEＲhas１ｏｂsｅrｖationsＣ．datａsetSＡSUSＥR.OＮEhas2oｂseｒvaｔiｏnsdａt(yī)aｓｅｔSＡSUSER.TWOhａs2obseｒvaｔioｎsdaｔaｓetWOＲK.OTHＥＲｈａs5obｓerｖatiｏｎsＤ．Ｎodaｔaｓeｔｓarｅｏuｔｐｕt.ＴｈeDＡTＡstｅｐｆａilｓｅxeｃuｔｉｏｎdueｔosｙｎｔaｘerｒors.Aｎswer:Ａ－－－－－--－--－－－－－－--－－-－36.Ｇｉvｅntheｃoｎｔeｎｔｓoｆtherａwdatａfilｅ'EMＰＬＯＹEＥ．TXＴ＇:－+-－--10-－-+－--－2０-－-+30--Xing219２0２3ACＣTBoｂ５2２2023MＫTＧJoｒge3142023EDUＣThefｏlｌｏwingSASprogｒａmiｓsｕbmitｔed:dａt(yī)aＷORK.EMＰLOYＥE；ｉnfile＇ＥＭPLOYEE．ＴXT';input@1ＦiｒstNａmｅ$＠1５ＳtａrtＤate@２5Ｄepartｍent$;rｕn;ＷhｉchSＡＳinｆｏrmａt(yī)cｏrｒeｃｔlycoｍｐletesthepｒｏｇraｍ?Ａ.daｔｅ9．Ｂ.mmdｄｙy1０．C.ｄｄｍｍｙｙ10.Ｄ.moｎdayｙr１0．Ａnsweｒ:Ｂ-－－－－－－－－-－－－-－－－－-３7.TｈｅSＡSｄataseｔＦed.ＢanｋscoｎtainｓavａrｉａbleOpｅn_Ｄatｅwhｉcｈhaｓbeenassigｎedaｐｅｒｍａnｅnｔｌａbｅlof＂ＯpeｎDatｅ".WhichSASproｇｒamｔemｐｏraｒｉｌyrepｌacｅstｈelaｂeｌ＂ＯpenDａｔe"ｗitｈtheｌabel"SｔarｔｉｎgDate＂ｉntｈｅoutpｕｔ?Ａ.ｐｒｏｃpｒｉntｄatａ=SASUＳEＲ.ＨOUＳESlａbeｌ；ｌabelOpen＿Date"ＳtaｒｔiｎgＤate＂;ruｎ;B．proｃprinｔdaｔa=SASＵSER．HOUSESlａｂｅl；lａbｅｌOｐen_Ｄaｔｅ=＂StａｒｔingDａｔｅ"；run;Ｃ.ｐｒocｐrintdaｔａ=SASUSＥR.ＨOUSEＳ;labeｌＯpeｎ_Ｄatｅ＝"StａrｔinｇDate"；ｒun；D.pｒｏcprinｔdaｔa=SASUＳER．HOＵSＥS;Open＿Ｄａt(yī)e=＂StａrtingDaｔe＂;rｕn；Anｓｗer:Ｂ--－-－-－－-－－－-－－－-－－－－-－-－-－-－－-－38.GiveｎtheSＡSdａt(yī)asetWORK.ONＥ：ＸＹＺ-－--１A271Ａ３31B45２A5２2B69３Ｂ7０４A８24C91ＴhefｏｌlowiｎgSAＳprograｍissｕｂmitteｄ:ｄａt(yī)aWORＫ.TWO;setWORK.ONE;byＸY;ifFｉrst.Y；ruｎ;prｏｃｐｒintｄata=ＷOＲK.ＴWＯnoobs;rｕn；Ｗｈichreｐortiｓproduｃed?A.XYZ-－--－－1B452A5２２B6９3B７04A8２4C9１B.XＹZ-－－－--１A271Ｂ4５2A522B６９3B70４A８２4C91C.XYZ------1A331B452A522Ｂ６９３B704Ａ8２４Ｃ９1Ｄ．ＴｈePRINTprocedureｆａilsbｅcａuｓｅthｅdａt(yī)aｓeｔWORK．TWOiｓnotcｒｅａt(yī)edｉntheDＡTＡstｅp.Ａnswｅr:B-－--－－-－－-－－－--－－--－-－－－--－－--－--－－－-－-－-39.TｈeｆｏlｌｏｗinｇＳＡSprｏgｒａｍisｓｕｂｍｉtｔｅｄ:daｔaＷＯＲK．AUＴＨＯRS;ａrｒayFavｏrｉtes｛3}$8(＇Shaｋeｓpeａre','Ｈeｍingway'，＇McＣａfｆrey');ｒｕn；WｈaｔiｓthevａｌueofｔhｅseｃoｎdvariａｂleinｔhｅdａｔａsetWORK.AＵTHOＲS？A.HeｍｉnｇwayＢ．ＨemingｗaＣ．'＇（aｍissｉngｖaluｅ)Ｄ.Thｅprogramcｏntaｉｎseｒｒoｒｓ.Nｏvariableｓarｅｃreａt(yī)ed.Ａnsweｒ:Ｂ－-－－－-－－--－－－-－-－－－-－-－－--－-40.ThｅｆollowinｇＳASｐrogramissubｍittｅd:dａt(yī)aWORＫ.PRODＵCＴS;Ｐrｏｄ=1；ｄowｈile(PｒｏｄLE6）;Prｏd＋1；end;ｒun;Wｈａt(yī)isｔhｅｖalｕeｏfｔhevarｉabｌePｒodｉｎthｅoutpｕtdataｓet?A.６B.7C.８Ｄ．.（mｉｓsｉngnｕｍerｉc)Anｓwer:Ｂ-－－－－－－－－--－－－-－-－－－--－--－－4１．Giｖenｔｈeｒawｄａt(yī)ａｒｅｃoｒｄinｔheｆｉlepｈone.ｔxｔ:-－--|－１0|-－-－2０－--｜－３0|ＳｔｅvｅｎsJａmeｓSＡLES3０4－９23-3７2114ThｅfｏlｌowｉｎｇＳASpｒogramｉsｓｕｂmｉtted：ｄaｔaＷORＫ.ＰHＯＮEＳ;ｉnfiｌe'ｐhｏne.txt＇;inputＥmｐＬN(yùn)ame$EmｐFName$Deｐt$Pｈone$Extensｉｏn；<＿iｎserｔ＿codｅ_>rｕｎ；WhicｈSAＳstａt(yī)emｅｎtcｏmpleteｓtheprogrａmandresuｌｔｓiｎａｖalｕｅｏf"JaｍｅsＳtevenｓ"ｆｏrtｈｅvaｒiableFullName？A．FｕlｌName＝CAＴX('',EmｐFNａme,EmpＬN(yùn)ame)；B.FuｌｌＮａme=CAT（'',EｍｐFName,EｍpＬＮａme）;C．ＦｕllＮaｍｅ=EmｐＦＮaｍｅ!！EmｐLNａmｅ；Ｄ.FｕｌｌNamｅ=EmｐＦＮamｅ+ＥmpLＮａmｅ；Aｎsｗeｒ:A-－－--－－-－－－-－－－－－－－-－－－－－-－－4２.TｈefollowiｎｇSASｐｒoｇramｉssｕｂmitteｄ：ｄaｔａWOＲK.ONＥ;Tｅxt＝＇Aｕstralia,ＵＳ，Denｍaｒk'；Pos＝fｉnｄ(Texｔ,＇UＳ＇,'i'，5);rｕｎ;WhatｖａluewｉlｌSASaｓsigntｏＰｏs？A．0B.1C．２D.1２Ａnsｗeｒ:D－-－－－-－-－-－--－－－－－－－－－-－－--－－－－4３.GivｅｎtheSASdatａsｅｔWORK．ORDＥＲS:WOＲK．ORDERSorｄer_idｃｕstoｍershiｐped-－－-－－-－-934１JｏｓhMartin０2FＥB202398７４ＲａchelＬoｒds１4MAR2023１0２３３ＴakasｈiＳaｔo０7ＪUL2０２3Thｅｖａrｉabｌeｏrdeｒ＿ｉdｉｓnｕmｅric;cuｓtｏmeｒiscｈａrａｃteｒ;andsｈｉppｅdisnumｅｒic，ｃontaiｎsaSASｄａt(yī)evaｌue,aｎdiｓshｏwｎwiｔhtheDＡＴE９.formａt(yī).Aｐrogramｍｅrwｏuldlikｅtocrｅatｅaｎeｗｖａriａbｌｅ,shｉｐ_ｎoｔｅ，tｈatｓhowsaｃharaｃtｅrvaluewiththeordeｒ＿id,sｈｉppeddate,andcｕstｏｍerｎａme.Foreｘaｍple，giveｎtｈeｆｉrsｔｏbｓerｖａt(yī)ｉｏnship_noｔｅwoｕldｈavｅtheｖaｌuｅ"Oｒｄｅr9３41sｈiｐpedoｎ0２ＦEＢ20２３toJoｓhMartｉn".Wｈicｈofthｅｆollｏwｉngsｔatemeｎｔｗillcｏrrecｔlycｒeatｅｔhevalueandassignittｏsｈｉp_ｎoｔｅ?Ａ．sｈip_note＝caｔｘ('','Ordeｒ',order_iｄ，'ｓhipｐedon'，iｎｐut(shiｐpeｄ，daｔe9.)，＇ｔo',cuｓtoｍer);B.ship_ｎote=cａt(yī)x(＇＇,＇Order',order_ｉｄ，'shippｅdｏn',chａｒ(shipped，ｄａt(yī)ｅ9．),＇to',cｕsｔoｍeｒ）;C.sｈiｐ_nｏte=ｃatｘ(＇＇，'Order＇，oｒder_iｄ，＇shｉｐｐeｄon＇,traｎswrd(ｓhｉpｐed,ｄate9．),'ｔo'，custoｍer);Ｄ.ship＿note＝catｘ(＇','Ordeｒ',orｄｅr_iｄ，'sｈippedｏn',put(sｈiｐｐed，ｄaｔe9.）,'to',cuｓtomｅr);Anｓwer:D-－－－-－--－－－-－－－－-－－－－-－-－－－--－－--－－--－--４4．ThｅfollｏwingSＡSｐrｏgraｍｉssｕbmiｔｔeｄ:dａｔaＯＮETＷOＳASUSＥR．TWＯｓｅtSASＵＳER.ＯＮＥ;rｕｎ;AssumｉngｔｈaｔSＡSUSER．ONEｅxiｓts,ｈｏwmａnytｅmpｏｒaｒyaｎｄperｍａｎｅntSASｄatａｓetsａrｅcrｅatｅｄ?A.2ｔeｍｐorａryａnｄ1permａnentＳAＳdaｔaｓetsaｒｅｃreaｔedB．3ｔeｍpｏrａryand2ｐermａnｅｎtSＡSｄaｔasetsaｒecreatedC.2temporarｙaｎd２ｐｅｒmaｎenｔSＡSdaｔａseｔｓarecrｅａt(yī)edD.thereisanerroｒandnonewｄataseｔｓａreｃreａt(yī)ｅdＡnswer:D-－--－-－--－－-－－－－-－-－-－-－－－--－--－－-4５.ＴhｅfｏllowingSAＳpｒogramissubmitｔｅｄ：ｏｄｓcsvallｆｉle=＇ｃ：\test.cvs';prｏcｐriｎtｄa