SAS-Base认证考试（70真题+答案详解）

SAS_Base认证考试（70真题+答案详解）SASBase认证考试—70题SAS分多个认证种类：base，advanced，clinic等，但大多需要先通过base认证。但凡这类商业组织提供的考证，基本都是题库型，所以想考过难度并不大。对于只想拿SAS认证的人，如果熟练掌握网上流传甚广的sas真题70题，通过base认证基本就没问题。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本题知识点：自动变量在SAS读取数据时，在PDV过程中会产生很多自动变量，在输出的数据集中是不可见的。·FIRST.VARIABLE：同一个BY变量（组），若新的变量值第一次出现时，其first.variable值为1。·LAST.VARIABLE：同一个BY变量（组），若新的变量值最后一次出现时，其last.variable值为1。另外，在BY变量右面有多个变量时，先按第一个变量排序，若第一个变量的观测存在重复时，才按第二个变量排序。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本题知识点：INFILE语句与指示器@、@@INFILEfilespecificationoptions;其中，filespecification用来定义文件,options给出选择项;·filespecification有以下三种形式:①、fileref(文件标志)②、’filename’(文件名)③、CARDS指明输入的数据，紧跟着CARDS语句·下列选择项(options)可以出现在INFILE语句中:①、COLUMN=variable或COL=variable定义一个变量,其值是指针所在的当前列位置。②、END=variable定义一个变量,作为文件结束的标志。③、EOF=label是一个语句标号,当INFILE语句读到文件末尾时,作为隐含的GOTO语句的目标。④、LENGHT=variable定义一个变量,其值是当前输入数据行的长度。⑤、FIRSTOBS=linenumber要求从指定的行开始读取数据,而不是从文件的第一个记录开始。⑥、OBS=n指定从一个顺序输入文件中读取数据的最后一个行(即第1～第n行)。一个观察可能占n行。⑦、DLM=若分隔符不是空格，则使用DLM=指定⑧、DSD忽略引号中数值的分隔符；自动将字符数据中的引号去掉；将两个相邻分隔符视为缺失值处理。⑨、MISSOVER阻止INPUT进入下一行读取，未赋值变量视为缺失值。⑩、TRUNCOVER与MISSOVER相似，但在COLUMNINPUT或FORMATTEDINPUT中使用。比较@与@@的区别：·@用于1个数据行用多个input语句读取，停留到下一个INPUT语句。·@@用于1个数据行含有多个观测值读取时，停留到下一个DATA步。Q3ThefollowingSASprogramissubmitted:dataWORK.DATE_INFO;Day="01";Yr=1960;X=mdy(Day,01,Yr);run;WhatisthevalueofthevariableX?A.thenumericvalue0B.thecharactervalue"01011960"C.amissingvalueduetosyntaxerrorsD.thestepwillnotcompilebecauseofthecharacterargumentinthemdyfunction.答案：A本题知识点：数据类型的自动转换在SAS中，日期时间是以1960年1月1日0时0分0秒作为起点的。因此，mdy(1,1,1960)=0。若把日期时间表示为常数时，要使用相应的格式，带单或双引号，在后面紧跟一个D（日期）、T（时间）、DT（日期时间）。在本题中，日期函数的参数应该是数值，若是字符串，会先尝试字符串是否可以转换为数值，这是自动转换。自动转换是指系统产生一个临时的变量来完成赋值或运算。当自动转换发生时，会在LOG窗口中给出提示。1）、字符型变量->数值型变量在下面的情况中，VarB是一个字符型变量，其它是数字型变量。·赋值于一个数字型变量，如：VarA=VarB;·在算术运算中使用，如：VarA=VarB+0;·与一个数字型变量进行比较，如：ifVarB>=VarA;·在函数中，参数要求数字型变量，如：VarA=sum(VarB,0);2）、数值型变量->字符型变量在下面的情况中，VarB是一个数字型变量，其它是字符型变量。·赋值于一个字符型变量，如：VarA=VarB;·在与要求字符的运算符一起使用，如：VarA=''||VarB;·在函数中，参数要求字符型变量，如：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本题知识点：打印Excel的某个工作表的数据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本题知识点：INFILE的选项FIRSTOBS=常数，要求从指定的行开始读取数据,而不是从文件的第一个记录开始。OBS=常数，指定从一个顺序输入文件中读取数据的最后一个行(即第1～第n行)。一个观测可能占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本题知识点：KEEP语句与KEEP=选项在处理大型数据集时，KEEP=选项的效率较高。·KEEP语句：KEEPvariable(s);不能用于过程步。·KEEP=选项：data-set-name(KEEP=variable(s))可以用于数据步（如，DATA语句、SET语句）、过程步。其中，variable(s)是具体变量，不能是数组、_N_、_ERROR_等。Q7WhichofthefollowingchoicesisanunacceptableODSdestinationforproducingoutputthatcanbeviewedinMicrosoftExcel?A.MSOFFICE2KB.EXCELXPC.CSVALLD.WINXP答案：D本题知识点：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页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本题知识点：类似第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本题知识点：PROCFORMAT语句PROCFORMAT;VALUEnamerange-1=’formatted-text-1′;range-2=’formatted-text-2′;……range-n=’formatted-text-n’;若name为字符串设计格式，则必须在开头加$，长度不超过32字节；name不能以数字结尾，除了下划线外，不能含其他的任何特殊字符。在range右侧文本可达到32767字节。·变量值是字符串要加引号。·range是多个值，要用逗号。·连续的要用-。·关键字low、high指代变量中最小和最大的非缺失值。·用<排除或指代某些范围。·other是给其他没列在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本题知识点：标准数据、以及数据类型的自动转换非标准数据·含逗号的数值，如：1,00,001；·包含美元符号、十六进制、压缩十进制的数据；·日期是最普通的非标准数据。标准数据·数字0-9·英文句号·科学计数、E·+、-如果字符型变量转换后不能作为标准数值读入，被转换成的字符型变量有格式要求，必须进行显式转换。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本题知识点：PROCMEANS过程PROCMEANS;语句;RUN;data=：数据集maxdec=：指定输出结果的小数位数，默认为7位noprint：禁止结果在OTPUT窗口输出alpha：设定可信区间的α水平，默认为0.05MAX、MIN、MEAN、MEDIAN、N、NMISS、RANGE、STDDEV、SUM若不加统计关键词，默认打印的顺序：非缺失值个数（N）、均值（MEAN）、标准差（STDDEV）、最小值（MIN）、最大值（MAX）。语句若在PROCMEAN过程中没有其他语句，默认输出所有观测值和所有数值变量的统计量。BY：分变量单独分析，数据必须先按变量顺序排序，即PROCSORTCLASS：分变量单独分析，不用排序VAR：指定使用的数值变量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本题知识点：LIBNAME语句格式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本题知识点：数组与其他编程语言的数组相比不同在于，SAS数组的每个元素都对应一个变量名。数值型数组数组说明中的初始值可省略，默认为缺失值。数组说明中变量可省略，变量名默认为数组名+序号。序号从1开始。ARRAYtest(3)MathChineseEnglish(0,0,0);数组元素的个数由变量个数决定。ARRAYtest(*)test3-test8;二维数组，数组元素按行排列。ARRARx(2,2)x11x12x21x22;字符型数组字符型数组药指定数组元素的最大长度，其他与数值型数组相同。ARRAYtest(2)$10mathorfather;临时数组若SAS数组每个元素不对应变量名，即为临时数组。这与其他编程语言相同。ARRAYtest(3)_TEMPORARY_(0,0,0);临时数组只用于中间计算，不保存入数据集。在数据步中，临时数组在数据步隐含循环中能自动保留上一步得到的值。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本题知识点：/debug语法DEBUG过程的调用方法：在DATA步后面增加DEBUG选项。Q15WhichstatementistrueconcerningtheSASautomaticvariable_ERROR_?A.Itcannotbeusedinanif/thencondition.B.Itcannotbeusedinanassignmentstatement.C.Itcanbeputintoakeepstatementorkeep=option.D.Itisautomaticallydropped.答案：D本题知识点：自动变量_ERROR_在PDV过程中，产生很多自动变量，可以在数据步的表达式中使用，在输出数据集中不可见。在PDV过程中，_N_、_ERROR_默认为DROP。在KEEP语句或KEEP=选项中，可以使用除了_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本题知识点：SAS中日期时间及函数起点：1960年1月1日0时0分0秒。若将日期时间标示为数值型常数，需使用相应格式。格式值带单引号，后跟一个D（日期）、T（时间）、DT（日期时间）。日期函数返回值为数值。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本题知识点：IF语句若执行语句不能在一个语句完成，则使用复合语句DO和ENDIF条件THEN语句;没有ENDIF，没有IF-ELSEIF-ELSE多分支结构,语句1只能是一个语句。IF条件THEN语句1;；Q18WhichstatementdescribesacharacteristicoftheSASautomaticvariable_ERROR_?A.The_ERROR_variablemaintainsacountofthenumberofdataerrorsinaDATAstep.B.The_ERROR_variableisaddedtotheprogramdatavectorandbecomespartofthedatasetbeingcreated.C.The_ERROR_variablecanbeusedinexpressionsintheDATAstep.D.The_ERROR_variablecontainsthenumberoftheobservationthatcausedthedataerror.答案：C本题知识点：WHERE语句类似第15题。Q19TheSASdatasetWORK.ONEcontainsanumericvariablenamedNumandacharactervariablenamedChar:WORK.ONENumChar-------123323177ThefollowingSASprogramissubmitted:procprintdata=WORK.ONE;whereNum='1';run;Whatisoutput?A.NumChar-------123B.NumChar-------123177C.NumChar-------123323177D.Nooutputisgenerated.答案：D本题知识点：WHERE语句WHERE语句无法找到满足条件的观测。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本题知识点：FORMAT语句FORMAT语句为非执行语句。FORMAT语句在SET语句前后均无差别。FORMAT可以使用在数据步和过程步中，前者把格式永久存储，后者只是临时存储（当前过程中有作用）。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本题知识点：IF子集、OUPUT语句子集IF语句对满足条件的观测输出到正在被创建的数据集中。Q22WhichstepdisplaysalistingofallthedatasetsintheWORKlibrary?A.proccontentslib=WORKrun;B.proccontentslib=WORK.all;run;C.proccontentsdata=WORK._all_;run;D.proccontentsdata=WORK_ALL_;run;答案：C本题知识点：PROCCONTENTS过程默认自动打印最近创建的数据集的描述信息PROCCONTENTS;RUN;打印当前目录下的全部数据集的描述信息PROCCONTENTSDATA=_ALL_;RUN;打印WORK临时逻辑库下数据集的描述信息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本题知识点：LIBNAME定义逻辑库参考第12题。Q24Giventhefollowingrawdatarecords:----|----10---|----20---|----30Susan*12/29/1970*10Michael**6Thefollowingoutputisdesired:Obsemployeebdateyears1Susan4015102Michael.6WhichSASprogramcorrectlyreadsintherawdata?A.dataemployees;infile'filespecification'dlm='*';inputemployee$bdate:mmddyy10.y