SAS中文论坛

标题: 跟crackman做sas adv认证试题（12） [打印本页]

---

作者: shiyiming    时间: 2010-11-17 17:16
标题: 跟crackman做sas adv认证试题（12）
From crackman's blog on Baidu


               
                <p><font size="4" face="宋体">Given the dataset WORK.STUDENTS:&nbsp;&nbsp;&nbsp;&nbsp;  <br>
<br>
  Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Age <br>
  -------&nbsp;&nbsp;  --- <br>
  Mary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  15 <br>
  Philip&nbsp;&nbsp;&nbsp;&nbsp;  16 <br>
  Robert&nbsp;&nbsp;&nbsp;&nbsp;  12 <br>
  Ronald&nbsp;&nbsp;&nbsp;&nbsp;  15 <br>
<br>
&nbsp;&nbsp;&nbsp;  The following SAS program is submitted:<br>
<br>
  %let Value=Philip;&nbsp;&nbsp;&nbsp;  <br>
<br>
  proc print data=WORK.STUDENTS;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  [_insert_WHERE_statement_] <br>
  run; <br>
<br>
&nbsp;&nbsp;&nbsp;  Which WHERE statement successfully completes  <br>
&nbsp;&nbsp;&nbsp;  the program and produces a report?&nbsp;&nbsp;  </font></p>
<p><br>
<font size="4" face="宋体"> A.<br>
where upcase(Name)=upcase(&amp;Value);&nbsp;&nbsp;&nbsp;  <br>
<br>
B.<br>
where upcase(Name)=%upcase(&amp;Value);&nbsp;&nbsp;  <br>
<br>
C.<br>
where upcase(Name)=&quot;upcase(&amp;Value)&quot;;  <br>
<br>
D.<br>
where upcase(Name)=&quot;%upcase(&amp;Value)&quot;; </font></p>
<p><font size="4" face="宋体">答案：D</font></p>
<p><font size="4" face="宋体">此题其实考察的是字符串的引用问题。<br>
记得加引号。<br>
另外%upcase宏函数是对宏字符变量进行字符大写化。<br>
</font></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/cb2398278d0b2a54ac34debb.html">阅读全文</a>
               
                <br/><b>类别：</b><a href="http://hi.baidu.com/crack%5Fman/blog/category/%B8%FAcrackman%D7%F6sas%20adv%C8%CF%D6%A4%CA%D4%CC%E2">跟crackman做sas adv认证试题</a>&nbsp;<a href="http://hi.baidu.com/crack%5Fman/blog/item/cb2398278d0b2a54ac34debb.html#comment">查看评论</a>

---

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)

Powered by Discuz! X3.2