所有的题目,除了70+123+50和论坛上已有的鸡精,只有一题比较新。其余的可能选项内容会稍微改变,但是答案都没有变化就不赘述了~
是有关CONTAINS在wherestatement中的用法,我不清楚是版本不同还是原PO记岔了,这是论坛中已存在的版本(灰色部分):
Q 19
The SAS data set WORK.ONE contains a numeric variable named Num and a charactervariable named Char:
WORK.ONE
Num Char
--- ----
1 23
3 23
1 77
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contain(1);
run;
What is output?
A. Num Char
--- ----
1 23
B. Num Char
--- ----
1 23
1 77
C. Num Char
--- ----
1 23
3 23
1 77
D. No output is generated.
答案:D
这题把原来70题里面的Num='1'替换成contain(1),答案不变,contain没这个函数。
实际上我遇到的语句是:
proc print data=WORK.ONE;
where Num=CONTAINS(1);
run;
What is output?
注意这里是CONTAINS而非CONTAIN!原来的版本选D无误,但是我遇到的这题该选啥求大神点拨!!
以下是GUIDE上关于CONSTAINS语句的用法,请参考:
Usingthe CONTAINS Operator
The CONTAINS operatorselects observations that include the specified substring. The
mnemonic equivalent forthe CONTAINS operator is ?. You can use either the CONTAINS
keyword or the mnemonicequivalent in your code, as shown below.
wherefirstname CONTAINS 'Jon';
where firstname ? 'Jon';
关于_ERROR_语句的,果然是出现率高啊我遇到了三题!
以下70题里不知道为什么被crackman删掉的18题……大概是因为太弱智了吧……答案选C,今天我碰到的也是加了ONLY的版本!
Which statement describes acharacteristic of the SAS automatic variable _ERROR_?
A. The _ERROR_ variablemaintains a count of the number of data errors in a DATA step.
B. The_ERROR_ variable is added to the program data vector and becomes part of thedata set being created.
C. The_ERROR_ variable can ONLY be used in expressions in the DATA step.
D. The_ERROR_ variable contains the number of the observation that caused the dataerror.
祝大家考试顺利!我去准备Black Friday血拼了