SAS Base认证考试—70题(61-70).docVIP

SAS Base认证考试—70题(61-70) Q 61 Consider the data step: ?data WORK.TEST; ?? infile c:\class1.csv dsd; ?? input Name Sex? Age Height Weight; ?? if Age NE 16 and Age NE 15 then Group=1; ?? else Group=2; ?run; Which statement produces a functionally equivalent result for assigning Group a value? A. if Age not in(15,16) then Group=1;? else Group=2; B. if (Age NE 16) or (Age NE 15) then Group=1;? else Group=2; C. where Age not between 15 and 16 then Group=1; else Group=2; D. both A or C will work. 答案：A ? 本题知识点：IF语句、IN的使用 参考第17题。 ? Q 62 The following SAS program is submitted: ? _insert_ods_code_ ?? ??proc means data=SASUSER.SHOES; ??????? where Product in (Sandal , Slipper , Boot); ???? run; ? _insert_ods_code_ Which ODS statements, inserted in the two locations above, create a report stored in an html file? A. ods html open=sales.html;? ?? ods html close; B. ods file=sales.html / html;?? ods file close; C. ods html file=sales.html;?? ods html close; D. ods file html=sales.html;?? ods file close; 答案：C ? 本题知识点：PROC COTENTS过程 ODS的主要输出目标：LISTING、RESULTS、OUTPUT、HTML、CSVALL、RTF、PDF、其他。 ODS HTML适用于数据较少的数据集、或汇总的数据集，如TABULATE过程。 ? Q 63 The following SAS program is submitted: ? data WORK.OUTDS; ???? do until(Prod GT 6); ??????? Prod + 1; ???? end; ? run; What is the value of the variable Prod in the output data set? A. . (missing) B. 6 C. 7 ?D. Undetermined, infinite loop. 答案：C ? 本题知识点：WHERE语句 ? Q 64 The following SAS program is submitted:??data work.accounting;?????? length jobcode $ 12;?????? set work.department;run;The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.Which of the following is the length of the variable JOBCODE in the output data set?A. 5B. 8C. 12D. The length can not be determined as the program fails to execute due to errors. 答案：C ? 本题知识点：LENGTH语句 LEGTH规定的是变量的字节长度，不是格式，不能含小数点。 LENGTH variable-specification(s) DEFAULT=n 其中，DEFAULT=n是规定新建的数值变量的默认长度8改为n。 数值变量 对于数值变量，LENGTH范围为3-8字节。LENGTH可放在任意位置。 在PRO