sas base認(rèn)證考試(70真題+答案詳解）

1、1SASBase認(rèn)證考試—70題SAS分多個(gè)認(rèn)證種類：base，advanced，clinic等，但大多需要先通過base認(rèn)證。但凡這類商業(yè)組織提供的考證，基本都是題庫型，所以想考過難度并不大。對于只想拿SAS認(rèn)證的人，如果熟練掌握網(wǎng)上流傳甚廣的sas真題70題，通過base認(rèn)證基本就沒問題。Q11.ThefollowingSASprogramissubmitted:dataWK.TOTALsetWK.SALARYbyDepartmen

2、tGenderifFirst.thenPayroll=0PayrollWagerateifLast.runTheSASdatasetWK.SALARYiscurrentlyderedbyGenderwithinDepartment.WhichedcodewillaccumulatesubtotalsfeachGenderwithinDepartmentA.GenderB.DepartmentC.GenderDepartmentD.Dep

3、artmentGender答案：A本題知識點(diǎn)：自動(dòng)變量在SAS讀取數(shù)據(jù)時(shí)，在PDV過程中會(huì)產(chǎn)生很多自動(dòng)變量，在輸出的數(shù)據(jù)集中是不可見的。FIRST.VARIABLE：同一個(gè)BY變量（組），若新的變量值第一次出現(xiàn)時(shí)，其first.variable值為1。LAST.VARIABLE：同一個(gè)BY變量（組），若新的變量值最后一次出現(xiàn)時(shí)，其last.variable值為1。另外，在BY變量右面有多個(gè)變量時(shí)，先按第一個(gè)變量排序，若第一個(gè)變量的觀測存

4、在重復(fù)時(shí)，才按第二個(gè)變量排序。Q2GiventhefollowingrawdatarecdsinTEXTFILE.TXT:3runprocprintdata=WK.NUMBERSrunC.dataWK.NUMBERSlengthName$4Month$3Status$7infileTEXTFILE.TXTdlm=inputName$Month$@ifMonth=FEBtheninputWeek1Week2Week3Week4Status

5、$elseifMonth=MARtheninputWeek1Week2Week3Week4Week5Status$fmatWeek1Week5dollar6.runprocprintdata=WK.NUMBERSrunD.dataWK.NUMBERSlengthName$4Month$3Status$7infileTEXTFILE.TXTdsd@inputName$Month$ifMonth=FEBtheninputWeek1Week2

6、Week3Week4Status$elseifMonth=MARtheninputWeek1Week2Week3Week4Week5Status$fmatWeek1Week5dollar6.runprocprintdata=WK.NUMBERSrun答案：C本題知識點(diǎn)：INFILE語句與指示器@、@@INFILEfilespecificationoptions其中，filespecification用來定義文件options給出選擇項(xiàng)f