2021年新版SASBase认证考试合集.docVIP

2021年新版SASBase认证考试合集 2021年新版SASBase认证考试合集 PAGE / NUMPAGES 2021年新版SASBase认证考试合集 SAS Base认证考试—70题(11-20) Q 11 Given the existing SAS program: ???? proc format; ??????? value agegrp ?????????? low-12 =Pre-Teen ??? ???????13-high = Teen; ???? run; ???? proc means data=SASHELP.CLASS; ??????? var Height; ??????? class Sex Age； ??????? format Age agegrp.; ???? run; Which statement in the proc means step needs to be modified or added to generate the following results： ???????????????????? Analysis Variable ：Height ??????????????????? N ?? Sex? Age???????? Obs?????? Minimum???????? Maximum??????????? Mean ?? ?? F??? Pre-Teen????? 3????????? 51.3?????? ?????59.8??????????? 55.8 ??????? Teen????????? 6????????? 56.5??????????? 66.5??????????? 63.0 ?? M??? Pre-Teen????? 4????????? 57.3??????????? 64.8??????????? 59.7 ??????? Teen????????? 6????????? 62.5??????????? 72.0??????????? 66.8 ?? A. var Height / nobs min max mean maxdec=1; B. proc means data=SASHELP.CLASS maxdec=1 ; C. proc means data=SASHELP.CLASS min max mean maxdec=1; D. output nobs min max mean maxdec=1; 答案：C ? 本题知识点：PROC MEANS过程 PROC MEANS options statistic-keywords; 语句; RUN; options data=：数据集 maxdec=：指定输出成果小数位数，默以为7位 noprint：禁止成果在OTPUT窗口输出 alpha：设定可信区间α水平，默以为0.05 statistic-keywords MAX、MIN、MEAN、MEDIAN、N、NMISS、RANGE、STDDEV、SUM 若不加记录核心词，默认打印顺序：非缺失值个数（N）、均值（MEAN）、原则差（STDDEV）、最小值（MIN）、最大值（MAX）。 ?语句 若在PROC MEAN过程中没有其她语句，默认输出所有观测值和所有数值变量记录量。 BY：分变量单独分析，数据必要先按变量顺序排序，即PROC SORT CLASS：分变量单独分析，不用排序 VAR：指定使用数值变量 ? Q 12 The Excel workbook QTR1.XLS contains the following three worksheets: ??? JAN ???? FEB ???? MAR Which statement correctly assigns a library reference to the Excel workbook? A. libname qtrdata qtr1.xls； B. libname qtr1.xls sheets=3; C. libname jan feb mar qtr1.xls; D. libname mydata qtr1.xls WORK.heets=(jan,feb,mar); 答案：A ? 本题知识点：LIBNAME语句格式 LIBNAME libref engine ‘SAS-data-library’ options engine/host-options; ? Q 13 The following SAS program is submitted: ?data WORK.TEST; ??? set WORK.MEASLES(keep=J