SAS中文论坛

标题: 跟crakman做sas base认证试题（19） [打印本页]

---

作者: shiyiming    时间: 2010-11-11 11:11
标题: 跟crakman做sas base认证试题（19）
From crackman's blog on Baidu


               
                <p><font size="4"> <br>
19.The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:<br>
<br>
  WORK.ONE <br>
<br>
  Num&nbsp;&nbsp;  Char<br>
  ---&nbsp;&nbsp;  ----<br>
&nbsp;&nbsp;&nbsp;  1&nbsp;&nbsp;  23 <br>
&nbsp;&nbsp;&nbsp;  3&nbsp;&nbsp;  23 <br>
&nbsp;&nbsp;&nbsp;  1&nbsp;&nbsp;  77 <br>
<br>
The following SAS program is submitted:<br>
<br>
  proc print data=WORK.ONE;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  where Num='1';<br>
  run;<br>
<br>
What is output?</font></p>
<p><br>
<font size="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  A.<br>
Num&nbsp;&nbsp;  Char<br>
---&nbsp;&nbsp;  ----<br>
1&nbsp;&nbsp;&nbsp;&nbsp;  23<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  B.<br>
Num&nbsp;&nbsp;  Char&nbsp;&nbsp;&nbsp;  <br>
---&nbsp;&nbsp;  ----<br>
1&nbsp;&nbsp;&nbsp;&nbsp;  23<br>
1&nbsp;&nbsp;&nbsp;&nbsp;  77<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  C.<br>
Num&nbsp;&nbsp;  Char&nbsp;&nbsp;&nbsp;&nbsp;  <br>
---&nbsp;&nbsp;  ----<br>
1&nbsp;&nbsp;&nbsp;&nbsp;  23<br>
3&nbsp;&nbsp;&nbsp;&nbsp;  23<br>
1&nbsp;&nbsp;&nbsp;&nbsp;  77<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  D. No output is generated.</font></p>
<p><font size="4">Answer: D<br>
本题考察的是数值型和字符型数据在表达式中的应用。<br>
答案是D<br>
因为WHERE语句无法找到满足条件的观测。<br>
NUM是数值型变量，表达式右边是字符型数据，肯定无法查询到满足条件的观测。</font></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/0ce740509f479844574e0009.html">阅读全文</a>
               
                <br/><b>类别：</b><a href="http://hi.baidu.com/crack%5Fman/blog/category/%B8%FAcrackman%D7%F6sas%20base%C8%CF%D6%A4%CA%D4%CC%E2">跟crackman做sas base认证试题</a>&nbsp;<a href="http://hi.baidu.com/crack%5Fman/blog/item/0ce740509f479844574e0009.html#comment">查看评论</a>

---

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

Powered by Discuz! X3.2