SASBase认证考试70题6170.docx

1、SASBase认证考试70题6170SAS-Base认证考试70题(61-70)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 63The following SAS program is

2、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. 6C. 7D. Undetermined, infinite loop. 答案：C本题知识点：WHERE语句参考第40题。Q 64The following SAS program is submitted:data work.accounting; length jobcode $ 12; set w

3、ork.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本题

4、知识点：LENGTH语句LEGTH规定的是变量的字节长度，不是格式，不能含小数点。LENGTH variable-specification(s) 其中，DEFAULT=n是规定新建的数值变量的默认长度8改为n。 数值变量对于数值变量，LENGTH范围为3-8字节。LENGTH可放在任意位置。在PROC SQL中ALERT不能改变数值变量长度。 字符变量对于字符变量，LENGTH范围为1-32767字节，空格占一个字符。LENGTH必须放在SET语句之前。实际上，较少使用LENGTH语句，而是通过PROC SQL中ALERT改变字符变量长度。Q 65The following SAS prog

5、ram is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; label Jobcode=Job Description; run;Which statement is true 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 la

6、bel of the variable Jobcode is Job Description.D. The program fails to execute due to errors. Labels must be defined in 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

7、written to the WORK.SALES data set? A. 0 B. 1 C. 5 D. 60答案：B本题知识点：默认的OUTPUT语句参考第40题。Q 67Consider the following data step: 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

8、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 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

9、-z为97-122Q 68The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; length EmpId $6; CharEmpid=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 typ

10、e of the variable CharEmpid is unknown.C. The type of the variable CharEmpid is character.D. The program fails to execute due to errors. 答案：D本题知识点：数据类型的转换、LENTH定义长度参考第10题。Q 69Given the data set WORK.EMPDATA: Employee_ Manager_ ID Job_Title Department ID - - - - 120101 Director Sales Management 12026

11、1 120102 Sales Manager Sales Management 120101 120103 Sales Manager II Sales Management 120101 120104 Administration Manager Administration 120101 120105 Secretary I Administration 120101Which one of the following where statements would display observations with job titles containing the word Manage

12、r?A. where substr(Job_Title,(length(Job_Title)-6)=Manager; B. where upcase(scan(Job_Title,-1, )=MANAGER;C. where Job_Title=% Manager ; D. where Job_Title like %Manager%; 答案：D本题知识点：WHERE语句WHERE语句与数据集中WHERE选项是在观察读入PDV之前必须满足的一个条件。WHERE where-expression-1 运算符说 明 between and选择一定数据范围的观测 is missing/null选择变

13、量值为缺失值的观测 contain/?选择包含规定字符的观察 like匹配选择观测 same and增加多个从句LIKE：下划线表示与一个字符匹配，百分号表示任意的多个字符。Q 70After a SAS program is submitted, the following is written to the SAS log: 105 data WORK.JANUARY; 106 set WORK.ALLYEAR(keep=Product Month Quantity Cost); 107 if Month=JAN then output WORK.JANUARY; 108 Sales=Co

14、st * Quantity; 109 drop=Month Quantity Cost; - 22 ERROR 22-322: Syntax error, expecting one of the following: !, !, &, *, *, +, -, , =, , =, , =, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, =, |, |, =. 110 run;What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?A. (drop Month Quantity Cost)B. (drop Month, Quantity, Cost)C. (drop=Month, Quantity, Cost)D. (drop=Month Quantity Cost)答案：D本题知识点：DROP选项参考6题。与KEEP=选项类似。