SAS-Base認(rèn)證考試（70真題+答案詳解）

SAS_Base認(rèn)證考試（70真題+答案詳解）SASBase認(rèn)證考試—70題SAS分多個(gè)認(rèn)證種類：base，advanced，clinic等，但大多需要先通過(guò)base認(rèn)證。但凡這類商業(yè)組織提供的考證，基本都是題庫(kù)型，所以想考過(guò)難度并不大。對(duì)于只想拿SAS認(rèn)證的人，如果熟練掌握網(wǎng)上流傳甚廣的sas真題70題，通過(guò)base認(rèn)證基本就沒(méi)問(wèn)題。Q11.ThefollowingSASprogramissubmitted:dataWORK.TOTAL;setWORK.SALARY;byDepartmentGender;ifFirst.<_insert_code_>thenPayroll=0;Payroll+Wagerate;ifLast.<_insert_code_>;run;TheSASdatasetWORK.SALARYiscurrentlyorderedbyGenderwithinDepartment.WhichinsertedcodewillaccumulatesubtotalsforeachGenderwithinDepartment?A.GenderB.DepartmentC.GenderDepartmentD.DepartmentGender答案：A本題知識(shí)點(diǎn)：自動(dòng)變量在SAS讀取數(shù)據(jù)時(shí)，在PDV過(guò)程中會(huì)產(chǎn)生很多自動(dòng)變量，在輸出的數(shù)據(jù)集中是不可見(jiàn)的?！IRST.VARIABLE：同一個(gè)BY變量（組），若新的變量值第一次出現(xiàn)時(shí)，其first.variable值為1?！AST.VARIABLE：同一個(gè)BY變量（組），若新的變量值最后一次出現(xiàn)時(shí)，其last.variable值為1。另外，在BY變量右面有多個(gè)變量時(shí)，先按第一個(gè)變量排序，若第一個(gè)變量的觀測(cè)存在重復(fù)時(shí)，才按第二個(gè)變量排序。Q2GiventhefollowingrawdatarecordsinTEXTFILE.TXT:----|----10---|----20---|----30John,FEB,13,25,14,27,FinalJohn,MAR,26,17,29,11,23,CurrentTina,FEB,15,18,12,13,FinalTina,MAR,29,14,19,27,20,CurrentThefollowingoutputisdesired:ObsNameMonthStatusWeek1Week2Week3Week4Week51JohnFEBFinal$13$25$14$27.2JohnMARCurrent$26$17$29$11$233TinaFEBFinal$15$18$12$13.4TinaMARCurrent$29$14$19$27$20WhichSASprogramcorrectlyproducesthedesiredoutput?A.dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT'dsd;inputName$Month$;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=WORK.NUMBERS;run;B.dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT'dlm=','missover;inputName$Month$;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=WORK.NUMBERS;run;C.dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT'dlm=',';inputName$Month$@;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=WORK.NUMBERS;run;D.dataWORK.NUMBERS;lengthName$4Month$3Status$7;infile'TEXTFILE.TXT'dsd@;inputName$Month$;ifMonth='FEB'theninputWeek1Week2Week3Week4Status$;elseifMonth='MAR'theninputWeek1Week2Week3Week4Week5Status$;formatWeek1-Week5dollar6.;run;procprintdata=WORK.NUMBERS;run;答案：C本題知識(shí)點(diǎn)：INFILE語(yǔ)句與指示器@、@@INFILEfilespecificationoptions;其中，filespecification用來(lái)定義文件,options給出選擇項(xiàng);·filespecification有以下三種形式:①、fileref(文件標(biāo)志)②、’filename’(文件名)③、CARDS指明輸入的數(shù)據(jù)，緊跟著CARDS語(yǔ)句·下列選擇項(xiàng)(options)可以出現(xiàn)在INFILE語(yǔ)句中:①、COLUMN=variable或COL=variable定義一個(gè)變量,其值是指針?biāo)诘漠?dāng)前列位置。②、END=variable定義一個(gè)變量,作為文件結(jié)束的標(biāo)志。③、EOF=label是一個(gè)語(yǔ)句標(biāo)號(hào),當(dāng)INFILE語(yǔ)句讀到文件末尾時(shí),作為隱含的GOTO語(yǔ)句的目標(biāo)。④、LENGHT=variable定義一個(gè)變量,其值是當(dāng)前輸入數(shù)據(jù)行的長(zhǎng)度。⑤、FIRSTOBS=linenumber要求從指定的行開(kāi)始讀取數(shù)據(jù),而不是從文件的第一個(gè)記錄開(kāi)始。⑥、OBS=n指定從一個(gè)順序輸入文件中讀取數(shù)據(jù)的最后一個(gè)行(即第1～第n行)。一個(gè)觀察可能占n行。⑦、DLM=若分隔符不是空格，則使用DLM=指定⑧、DSD忽略引號(hào)中數(shù)值的分隔符；自動(dòng)將字符數(shù)據(jù)中的引號(hào)去掉；將兩個(gè)相鄰分隔符視為缺失值處理。⑨、MISSOVER阻止INPUT進(jìn)入下一行讀取，未賦值變量視為缺失值。⑩、TRUNCOVER與MISSOVER相似，但在COLUMNINPUT或FORMATTEDINPUT中使用。比較@與@@的區(qū)別：·@用于1個(gè)數(shù)據(jù)行用多個(gè)input語(yǔ)句讀取，停留到下一個(gè)INPUT語(yǔ)句?！@用于1個(gè)數(shù)據(jù)行含有多個(gè)觀測(cè)值讀取時(shí)，停留到下一個(gè)DATA步。Q3ThefollowingSASprogramissubmitted:dataWORK.DATE_INFO;Day="01";Yr=1960;X=mdy(Day,01,Yr);run;WhatisthevalueofthevariableX?A.thenumericvalue0B.thecharactervalue"01011960"C.amissingvalueduetosyntaxerrorsD.thestepwillnotcompilebecauseofthecharacterargumentinthemdyfunction.答案：A本題知識(shí)點(diǎn)：數(shù)據(jù)類型的自動(dòng)轉(zhuǎn)換在SAS中，日期時(shí)間是以1960年1月1日0時(shí)0分0秒作為起點(diǎn)的。因此，mdy(1,1,1960)=0。若把日期時(shí)間表示為常數(shù)時(shí)，要使用相應(yīng)的格式，帶單或雙引號(hào)，在后面緊跟一個(gè)D（日期）、T（時(shí)間）、DT（日期時(shí)間）。在本題中，日期函數(shù)的參數(shù)應(yīng)該是數(shù)值，若是字符串，會(huì)先嘗試字符串是否可以轉(zhuǎn)換為數(shù)值，這是自動(dòng)轉(zhuǎn)換。自動(dòng)轉(zhuǎn)換是指系統(tǒng)產(chǎn)生一個(gè)臨時(shí)的變量來(lái)完成賦值或運(yùn)算。當(dāng)自動(dòng)轉(zhuǎn)換發(fā)生時(shí)，會(huì)在LOG窗口中給出提示。1）、字符型變量->數(shù)值型變量在下面的情況中，VarB是一個(gè)字符型變量，其它是數(shù)字型變量?！べx值于一個(gè)數(shù)字型變量，如：VarA=VarB;·在算術(shù)運(yùn)算中使用，如：VarA=VarB+0;·與一個(gè)數(shù)字型變量進(jìn)行比較，如：ifVarB>=VarA;·在函數(shù)中，參數(shù)要求數(shù)字型變量，如：VarA=sum(VarB,0);2）、數(shù)值型變量->字符型變量在下面的情況中，VarB是一個(gè)數(shù)字型變量，其它是字符型變量?！べx值于一個(gè)字符型變量，如：VarA=VarB;·在與要求字符的運(yùn)算符一起使用，如：VarA=''||VarB;·在函數(shù)中，參數(shù)要求字符型變量，如：VarA=trim(VarB);Q4TheExcelworkbookREGIONS.XLScontainsthefollowingfourworksheets:EASTWESTNORTHSOUTHThefollowingprogramissubmitted:libnameMYXLS'regions.xls';WhichPROCPRINTstepcorrectlydisplaystheNORTHworksheet?A.procprintdata=MYXLS.NORTH;run;B.procprintdata=MYXLS.NORTH$;run;C.procprintdata=MYXLS.'NORTH'e;run;D.procprintdata=MYXLS.'NORTH$'n;run;答案：D本題知識(shí)點(diǎn)：打印Excel的某個(gè)工作表的數(shù)據(jù)WHATISTHAT“$”CHARACTER?LookingatSASExploreritmaybesurprisingthateachdatasetwrittentoExcelappearstwice,oncewiththeexpectednameandoncewithatrailing“$”.Unlikeatypicaldatasource,datainanExcelspreadsheetneednotbeleftandtopaligned.ForthisExcelhasnamedrangeswhichallowdatatobeplacedanywhereinsideaspreadsheet.BydefaultSASreadsandwritesdatafromnamedrangesonspreadsheets,butwillalsoreadspreadsheetdatadirectlyintheabsenceofanamedrange.WhenanewSASdatasetiscreatedinanExcellibrary,SAScreatesbothaspreadsheetandanamedrange.Eachisgiventhesamename,withthespreadsheetdenotedbyatrailing“$”.IntheexampleatrightCLASSisthenamedrangecreatedbytheExcelengineandCLASS$isthespreadsheetcreatedbytheExcelenginetoholdthenamedrange.WithinSAS,thenamedrangeisreferredtoasWrkbk.CLASS,andthespreadsheetisreferencedusingthenameliteralWrkbk.’CLASS$’n.SASnameliteralsarenametokenswrittenasstringswithinquotationmarks,followedbythelettern.NameliteralsallowtheuseofspecialcharactersthatarenototherwiseallowedinSASnames,likethe“$”usedbytheExcellibnameenginetodistinguishworksheetsfromnamedranges.FormoreinformationseetheRecommendedReadings.摘自《De-MystifyingtheSASLIBNAMEEngineinMicrosoftExcel:APracticalGuide》Q5Whichstatementspecifiesthatrecords1through10aretobereadfromtherawdatafilecustomer.txt?A.infile'customer.txt'1-10;B.input'customer.txt'stop@10;C.infile'customer.txt'obs=10;D.input'customer.txt'stop=10;答案：C本題知識(shí)點(diǎn)：INFILE的選項(xiàng)FIRSTOBS=常數(shù)，要求從指定的行開(kāi)始讀取數(shù)據(jù),而不是從文件的第一個(gè)記錄開(kāi)始。OBS=常數(shù)，指定從一個(gè)順序輸入文件中讀取數(shù)據(jù)的最后一個(gè)行(即第1～第n行)。一個(gè)觀測(cè)可能占n行。Q6AfteraSASprogramissubmitted,thefollowingiswrittentotheSASlog:101dataWORK.JANUARY;102setWORK.ALLYEAR(keep=productmonthnum_SoldCost);103ifMonth='Jan'thenoutputWORK.JANUARY;104Sales=Cost*Num_Sold;105keep=ProductSales;-----22ERROR22-322:Syntaxerror,expectingoneofthefollowing:!,!!,&,*,**,+,-,,<=,<>,=,>,>=,AND,EQ,GE,GT,IN,LE,LT,MAX,MIN,NE,NG,NL,NOTIN,OR,^=,|,||,~=.106run;WhatchangesshouldbemadetotheKEEPstatementtocorrecttheerrorsintheLOG?A.keep=(ProductSales);B.keepProduct,Sales;C.keep=Product,Sales;D.keepProductSales;答案：D本題知識(shí)點(diǎn)：KEEP語(yǔ)句與KEEP=選項(xiàng)在處理大型數(shù)據(jù)集時(shí)，KEEP=選項(xiàng)的效率較高?！EEP語(yǔ)句：KEEPvariable(s);不能用于過(guò)程步?！EEP=選項(xiàng)：data-set-name(KEEP=variable(s))可以用于數(shù)據(jù)步（如，DATA語(yǔ)句、SET語(yǔ)句）、過(guò)程步。其中，variable(s)是具體變量，不能是數(shù)組、_N_、_ERROR_等。Q7WhichofthefollowingchoicesisanunacceptableODSdestinationforproducingoutputthatcanbeviewedinMicrosoftExcel?A.MSOFFICE2KB.EXCELXPC.CSVALLD.WINXP答案：D本題知識(shí)點(diǎn)：ODS輸出Mostofthesedestinationsaredesignedtocreateoutputforviewingonascreenorforprinting.TheOUTPUTdestinationcreatesSASdatasets.TheMARKUPdestinationisageneralpurposetoolforcreatingoutputinformatsdefinedbytagsets.ThisincludesXML(eXtensibleMarkupLanguage),EXCELXP,LaTeX,CSV(comma-separatedvalues),andmanyotherformatswheredatacanbethoughtofasseparatedbytags.TheDOCUMENTdestination,ontheotherhand,allowsyoutocreateareusableoutput“document”thatyoucanrerenderforanydestination.So,ifyourbossdecideshereallywantsthatreportinPDF,notRTF,youcanreplaytheoutputdocumentwithouthavingtoreruntheentireSASprogramthatcreatedthedata.Withanoutputdocument,youcanalsorearrange,duplicate,ordeletetablestofurthercustomizeyouroutput.摘自《TheLittleSASBook》(Fourth)P152頁(yè)Q8TheSASdatasetnamedWORK.SALARYcontains10observationsforeachdepartment,andiscurrentlyorderedbyDepartment.ThefollowingSASprogramissubmitted:dataWORK.TOTAL;setWORK.SALARY(keep=DepartmentMonthlyWageRate);byDepartment;ifFirst.Department=1thenPayroll=0;Payroll+(MonthlyWageRate*12);ifLast.Department=1;run;Whichstatementistrue?A.ThebystatementintheDATAstepcausesasyntaxerror.B.ThestatementPayroll+(MonthlyWageRate*12);inthedatastepcausesasyntaxerror.C.ThevaluesofthevariablePayrollrepresentthemonthlytotalforeachdepartmentintheWORK.SALARYdataset.D.ThevaluesofthevariablePayrollrepresentamonthlytotalforallvaluesofWAGERATEintheWORK.SALARYdataset.答案：C本題知識(shí)點(diǎn)：類似第1題Q9datacourse;inputexam;datalines;50.1;run;procformat;valuescore1–50=‘Fail’51–100=‘Pass’;run;procreportdata=coursenowd;columnexam;defineexam/displayformat=score.;run;Whatisthevalueforexam?A.FailB.PassC.50.1D.Nooutput答案：C本題知識(shí)點(diǎn)：PROCFORMAT語(yǔ)句PROCFORMAT;VALUEnamerange-1=’formatted-text-1′;range-2=’formatted-text-2′;……range-n=’formatted-text-n’;若name為字符串設(shè)計(jì)格式，則必須在開(kāi)頭加$，長(zhǎng)度不超過(guò)32字節(jié)；name不能以數(shù)字結(jié)尾，除了下劃線外，不能含其他的任何特殊字符。在range右側(cè)文本可達(dá)到32767字節(jié)?！ぷ兞恐凳亲址右?hào)?！ange是多個(gè)值，要用逗號(hào)?！みB續(xù)的要用-。·關(guān)鍵字low、high指代變量中最小和最大的非缺失值?！び?lt;排除或指代某些范圍。·other是給其他沒(méi)列在VALUE中的變量分配格式。Q10ThefollowingSASprogramissubmitted:dataWORK.RETAIL;Cost='$20.000';Discount=.10*Cost;run;Whatistheresult?A.ThevalueofthevariableDiscountintheoutputdatasetis2000.NomessagesarewrittentotheSASlog.B.ThevalueofthevariableDiscountintheoutputdatasetis2000.AnotethatconversionhastakenplaceiswrittentotheSASlog.C.ThevalueofthevariableDiscountintheoutputdatasetismissing.AnoteintheSASlogreferstoinvalidnumericdata.D.ThevariableDiscountintheoutputdatasetissettozero.NomessagesarewrittentotheSASlog.答案：C本題知識(shí)點(diǎn)：標(biāo)準(zhǔn)數(shù)據(jù)、以及數(shù)據(jù)類型的自動(dòng)轉(zhuǎn)換非標(biāo)準(zhǔn)數(shù)據(jù)·含逗號(hào)的數(shù)值，如：1,00,001；·包含美元符號(hào)、十六進(jìn)制、壓縮十進(jìn)制的數(shù)據(jù)；·日期是最普通的非標(biāo)準(zhǔn)數(shù)據(jù)。標(biāo)準(zhǔn)數(shù)據(jù)·數(shù)字0-9·英文句號(hào)·科學(xué)計(jì)數(shù)、E·+、-如果字符型變量轉(zhuǎn)換后不能作為標(biāo)準(zhǔn)數(shù)值讀入，被轉(zhuǎn)換成的字符型變量有格式要求，必須進(jìn)行顯式轉(zhuǎn)換。Q11GiventheexistingSASprogram:procformat;valueagegrplow-12='Pre-Teen'13-high='Teen';run;procmeansdata=SASHELP.CLASS;varHeight;classSexAge;formatAgeagegrp.;run;Whichstatementintheprocmeansstepneedstobemodifiedoraddedtogeneratethefollowingresults:AnalysisVariable:HeightNSexAgeObsMinimumMaximumMean------------------------------------------------------------------FPre-Teen351.359.855.8Teen656.566.563.0MPre-Teen457.364.859.7Teen662.572.066.8--------------------------------------------------------------------A.varHeight/nobsminmaxmeanmaxdec=1;B.procmeansdata=SASHELP.CLASSmaxdec=1;C.procmeansdata=SASHELP.CLASSminmaxmeanmaxdec=1;D.outputnobsminmaxmeanmaxdec=1;答案：C本題知識(shí)點(diǎn)：PROCMEANS過(guò)程PROCMEANS;語(yǔ)句;RUN;data=：數(shù)據(jù)集maxdec=：指定輸出結(jié)果的小數(shù)位數(shù)，默認(rèn)為7位noprint：禁止結(jié)果在OTPUT窗口輸出alpha：設(shè)定可信區(qū)間的α水平，默認(rèn)為0.05MAX、MIN、MEAN、MEDIAN、N、NMISS、RANGE、STDDEV、SUM若不加統(tǒng)計(jì)關(guān)鍵詞，默認(rèn)打印的順序：非缺失值個(gè)數(shù)（N）、均值（MEAN）、標(biāo)準(zhǔn)差（STDDEV）、最小值（MIN）、最大值（MAX）。語(yǔ)句若在PROCMEAN過(guò)程中沒(méi)有其他語(yǔ)句，默認(rèn)輸出所有觀測(cè)值和所有數(shù)值變量的統(tǒng)計(jì)量。BY：分變量單獨(dú)分析，數(shù)據(jù)必須先按變量順序排序，即PROCSORTCLASS：分變量單獨(dú)分析，不用排序VAR：指定使用的數(shù)值變量Q12TheExcelworkbookQTR1.XLScontainsthefollowingthreeworksheets:JANFEBMARWhichstatementcorrectlyassignsalibraryreferencetotheExcelworkbook?A.libnameqtrdata'qtr1.xls';B.libname'qtr1.xls'sheets=3;C.libnamejanfebmar'qtr1.xls';D.libnamemydata'qtr1.xls'WORK.heets=(jan,feb,mar);答案：A本題知識(shí)點(diǎn)：LIBNAME語(yǔ)句格式LIBNAMElibref‘SAS-data-library’<options>;Q13ThefollowingSASprogramissubmitted:dataWORK.TEST;setWORK.MEASLES(keep=JanptFebptMarpt);arrayDiff{3}Difcount1-Difcount3;arrayPatients{3}JanptFebptMarpt;run;Whatnewvariablesarecreated?A.Difcount1,Difcount2andDifcount3B.Diff1,Diff2andDiff3C.Janpt,Febpt,andMarptD.Patients1,Patients2andPatients3答案：A本題知識(shí)點(diǎn)：數(shù)組與其他編程語(yǔ)言的數(shù)組相比不同在于，SAS數(shù)組的每個(gè)元素都對(duì)應(yīng)一個(gè)變量名。數(shù)值型數(shù)組數(shù)組說(shuō)明中的初始值可省略，默認(rèn)為缺失值。數(shù)組說(shuō)明中變量可省略，變量名默認(rèn)為數(shù)組名+序號(hào)。序號(hào)從1開(kāi)始。ARRAYtest(3)MathChineseEnglish(0,0,0);數(shù)組元素的個(gè)數(shù)由變量個(gè)數(shù)決定。ARRAYtest(*)test3-test8;二維數(shù)組，數(shù)組元素按行排列。ARRARx(2,2)x11x12x21x22;字符型數(shù)組字符型數(shù)組藥指定數(shù)組元素的最大長(zhǎng)度，其他與數(shù)值型數(shù)組相同。ARRAYtest(2)$10mathorfather;臨時(shí)數(shù)組若SAS數(shù)組每個(gè)元素不對(duì)應(yīng)變量名，即為臨時(shí)數(shù)組。這與其他編程語(yǔ)言相同。ARRAYtest(3)_TEMPORARY_(0,0,0);臨時(shí)數(shù)組只用于中間計(jì)算，不保存入數(shù)據(jù)集。在數(shù)據(jù)步中，臨時(shí)數(shù)組在數(shù)據(jù)步隱含循環(huán)中能自動(dòng)保留上一步得到的值。Q14WhichofthefollowingprogramscorrectlyinvokestheDATAStepDebugger:A.dataWORK.TESTdebug;setWORK.PILOTS;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;B.dataWORK.TESTdebugger;setWORK.PILOTS;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;C.dataWORK.TEST/debug;setWORK.PILOTS;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;D.dataWORK.TEST/debugger;setWORK.PILOTS;State=scan(cityState,2,'');ifState='NE'thendescription='Central';run;答案：C本題知識(shí)點(diǎn)：/debug語(yǔ)法DEBUG過(guò)程的調(diào)用方法：在DATA步后面增加DEBUG選項(xiàng)。Q15WhichstatementistrueconcerningtheSASautomaticvariable_ERROR_?A.Itcannotbeusedinanif/thencondition.B.Itcannotbeusedinanassignmentstatement.C.Itcanbeputintoakeepstatementorkeep=option.D.Itisautomaticallydropped.答案：D本題知識(shí)點(diǎn)：自動(dòng)變量_ERROR_在PDV過(guò)程中，產(chǎn)生很多自動(dòng)變量，可以在數(shù)據(jù)步的表達(dá)式中使用，在輸出數(shù)據(jù)集中不可見(jiàn)。在PDV過(guò)程中，_N_、_ERROR_默認(rèn)為DROP。在KEEP語(yǔ)句或KEEP=選項(xiàng)中，可以使用除了_N_、_ERROR_之外的變量。Q16ThefollowingSASprogramissubmitted:dataWORK.DATE_INFO;X='04jul2005'd;DayOfMonth=day(x);MonthOfYear=month(x);Year=year(x);run;WhattypesofvariablesareDayOfMonth,MonthOfYear,andYear?A.DayOfMonth,Year,andMonthOfYeararecharacter.B.DayOfMonth,Year,andMonthOfYeararenumeric.C.DayOfMonthandYeararenumeric.MonthOfYearischaracter.D.DayOfMonth,Year,andMonthOfYeararedatevalues.答案：B本題知識(shí)點(diǎn)：SAS中日期時(shí)間及函數(shù)起點(diǎn)：1960年1月1日0時(shí)0分0秒。若將日期時(shí)間標(biāo)示為數(shù)值型常數(shù)，需使用相應(yīng)格式。格式值帶單引號(hào)，后跟一個(gè)D（日期）、T（時(shí)間）、DT（日期時(shí)間）。日期函數(shù)返回值為數(shù)值。Q17Giventhefollowingdatastep:dataWORK.GEO;infiledatalines;inputCity$20.;ifCity='Tulsa'thenState='OK';Region='Central';ifCity='LosAngeles'thenState='CA';Region='Western';datalines;TulsaLosAngelesBangor;run;Afterdatastepexecution,whatwilldatasetWORK.GEOcontain?A.CityStateRegion-----------------------TulsaOKWesternLosAngelesCAWesternBangorWesternB.CityStateRegion-----------------------TulsaOKWesternLosAngelesCAWesternBangorC.CityStateRegion-----------------------TulsaOKCentralLosAngelesCAWesternBangorWesternD.CityStateRegion-----------------------TulsaOKCentralLosCAWesternBangor答案：A本題知識(shí)點(diǎn)：IF語(yǔ)句若執(zhí)行語(yǔ)句不能在一個(gè)語(yǔ)句完成，則使用復(fù)合語(yǔ)句DO和ENDIF條件THEN語(yǔ)句;沒(méi)有ENDIF，沒(méi)有IF-ELSEIF-ELSE多分支結(jié)構(gòu),語(yǔ)句1只能是一個(gè)語(yǔ)句。IF條件THEN語(yǔ)句1;；Q18WhichstatementdescribesacharacteristicoftheSASautomaticvariable_ERROR_?A.The_ERROR_variablemaintainsacountofthenumberofdataerrorsinaDATAstep.B.The_ERROR_variableisaddedtotheprogramdatavectorandbecomespartofthedatasetbeingcreated.C.The_ERROR_variablecanbeusedinexpressionsintheDATAstep.D.The_ERROR_variablecontainsthenumberoftheobservationthatcausedthedataerror.答案：C本題知識(shí)點(diǎn)：WHERE語(yǔ)句類似第15題。Q19TheSASdatasetWORK.ONEcontainsanumericvariablenamedNumandacharactervariablenamedChar:WORK.ONENumChar-------123323177ThefollowingSASprogramissubmitted:procprintdata=WORK.ONE;whereNum='1';run;Whatisoutput?A.NumChar-------123B.NumChar-------123177C.NumChar-------123323177D.Nooutputisgenerated.答案：D本題知識(shí)點(diǎn)：WHERE語(yǔ)句WHERE語(yǔ)句無(wú)法找到滿足條件的觀測(cè)。Q20ThedatasetWORK.REALESTATEhasthevariableLocalFeewithaformatof9.andavariableCountryFeewithaformatof7.;ThefollowingSASprogramissubmitted:dataWORK.FEE_STRUCTURE;formatLocalFeeCountryFeepercent7.2;setWORK.REALESTAT;LocalFee=LocalFee/100;CountryFee=CountryFee/100;run;WhataretheformatsofthevariablesLOCALFEEandCOUNTRYFEEintheoutputdataset?A.LocalFeehasformatof9.andCountryFeehasaformatof7.B.LocalFeehasformatof9.andCountryFeehasaformatofpercent7.2C.BothLocalFeeandCountryFeehaveaformatofpercent7.2D.Thedatastepfailsexecution;thereisnoformatforLocalFee.答案：C本題知識(shí)點(diǎn)：FORMAT語(yǔ)句FORMAT語(yǔ)句為非執(zhí)行語(yǔ)句。FORMAT語(yǔ)句在SET語(yǔ)句前后均無(wú)差別。FORMAT可以使用在數(shù)據(jù)步和過(guò)程步中，前者把格式永久存儲(chǔ)，后者只是臨時(shí)存儲(chǔ)（當(dāng)前過(guò)程中有作用）。Q21GiventheSASdatasetWORK.PRODUCTS:ProdIdPriceProductTypeSalesReturns----------------------------------K12S95.50OUTDOOR152B132S2.99CLOTHING30010R18KY251.99EQUIPMENT2553KL8BY6.39OUTDOOR12515DY65DW5.60OUTDOOR455DGTY2334.55EQUIPMENT672ThefollowingSASprogramissubmitted:dataWORK.OUTDOORWORK.CLOTHWORK.EQUIP;setWORK.PRODUCTS;ifSalesGT30;ifProductTypeEQ'OUTDOOR'thenoutputWORK.OUTDOOR;elseifProductTypeEQ'CLOTHING'thenoutputWORK.CLOTH;elseifProductTypeEQ'EQUIPMENT'thenoutputWORK.EQUIP;run;HowmanyobservationsdoestheWORK.OUTDOORdatasetcontain?A.1B.2C.3D.6答案：B本題知識(shí)點(diǎn)：IF子集、OUPUT語(yǔ)句子集IF語(yǔ)句對(duì)滿足條件的觀測(cè)輸出到正在被創(chuàng)建的數(shù)據(jù)集中。Q22WhichstepdisplaysalistingofallthedatasetsintheWORKlibrary?A.proccontentslib=WORKrun;B.proccontentslib=WORK.all;run;C.proccontentsdata=WORK._all_;run;D.proccontentsdata=WORK_ALL_;run;答案：C本題知識(shí)點(diǎn)：PROCCONTENTS過(guò)程默認(rèn)自動(dòng)打印最近創(chuàng)建的數(shù)據(jù)集的描述信息PROCCONTENTS;RUN;打印當(dāng)前目錄下的全部數(shù)據(jù)集的描述信息PROCCONTENTSDATA=_ALL_;RUN;打印WORK臨時(shí)邏輯庫(kù)下數(shù)據(jù)集的描述信息PROCCONTENTSDATA=WORK._ALL_;RUN;Q23WhichisavalidLIBNAMEstatement?A.libname"_SAS_data_library_location_";B.sasdatalibname"_SAS_data_library_location_";C.libnamesasdata"_SAS_data_library_location_";D.libnamesasdatasas"_SAS_data_library_location_";答案：C本題知識(shí)點(diǎn)：LIBNAME定義邏輯庫(kù)參考第12題。Q24Giventhefollowingrawdatarecords:----|----10---|----20---|----30Susan*12/29/1970*10Michael**6Thefollowingoutputisdesired:Obsemployeebdateyears1Susan4015102Michael.6WhichSASprogramcorrectlyreadsintherawdata?A.dataemployees;infile'filespecification'dlm='*';inputemployee$bdate:mmddyy10.y