《SASBase认证考试—70题6170》由会员分享，可在线阅读，更多相关《SASBase认证考试—70题6170（11页珍藏版）》请在金锄头文库上搜索。
1、SAS-Base认证考试70题(61-70) 作者： 日期：SAS Base认证考试70题(61-70)Q 61Consider 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.
2、 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 62The following SAS program is submitted: proc means data=SASUSER.SHOES; w
3、here Product in (Sandal , Slipper , Boot); run; 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=
4、sales.html; ods file close; 答案：C本题知识点：PROC COTENTS过程ODS的主要输出目标：LISTING、RESULTS、OUTPUT、HTML、CSVALL、RTF、PDF、其他。ODS HTML适用于数据较少的数据集、或汇总的数据集，如TABULATE过程。Q 63The 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 outp
5、ut data set?A. . (missing) B. 6C. 7D. Undetermined, infinite loop. 答案：C本题知识点：WHERE语句参考第40题。Q 64The 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.Whi
6、ch 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是规定新建的数值变量的默认长度8改为n。 数值变量对于数值变量，
7、LENGTH范围为3-8字节。LENGTH可放在任意位置。在PROC SQL中ALERT不能改变数值变量长度。 字符变量对于字符变量，LENGTH范围为1-32767字节，空格占一个字符。LENGTH必须放在SET语句之前。实际上，较少使用LENGTH语句，而是通过PROC SQL中ALERT改变字符变量长度。Q 65The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; label Jobcode=Job Description; run;Which statement is tru
8、e about the output dataset?A. The label of the variable Jobcode is Job (only the first word).B. The label of the variable Jobcode is Job Desc (only the first 8 characters). C. The label of the variable Jobcode is Job Description.D. The program fails to execute due to errors. Labels must be defined i
9、n a PROC step.答案：C本题知识点：LABEl标签语句参考第37题。Q 66The following SAS program is submitted: data WORK.SALES; do Year=1 to 5; do Month=1 to 12; X + 1; end; end; run;How many observations are written to the WORK.SALES data set? A. 0 B. 1 C. 5 D. 60答案：B本题知识点：默认的OUTPUT语句参考第40题。Q 67Consider the following data st
10、ep: data WORK.NEW; set WORK.OLD(keep=X); if X = 10 AND X LT 20 then X=2; else X=3; run; In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value? A. X would get a value of 1.B. X would get a value of 3.C. X
11、would retain its original value of missing. D. This step does not run because of syntax errors.答案：A本题知识点：缺失值的计算逻辑计算时按ASCII进行比较，缺失值主要是空格（ASCII值为32）和英文句号（ASCII值为46）。0-9为48-57A-Z为65-90a-z为97-122Q 68The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; length EmpId $6; CharE
12、mpid=EmpId; run;If data set WORK.DEPARTMENT has a numeric variable EmpId, which statement is true about the output dataset?A. The type of the variable CharEmpid is numeric.B. The type of the variable CharEmpid is unknown.C. The type of the variable CharEmpid is character.D. The program fails to exec
13、ute due to errors. 答案：D本题知识点：数据类型的转换、LENTH定义长度参考第10题。Q 69Given the data set WORK.EMPDATA: Employee_ Manager_ ID Job_Title Department ID - - - - 120101 Director Sales Management 120261 120102 Sales Manager Sales Management 120101 120103 Sales Manager II Sales Management 120101 120104 Administration Manager Administration 120101 120105 Secretary I Administration 120101Which
