SAS中文论坛

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

---

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


               
                <p><font size="4" face="宋体">Given the following partial SAS log:&nbsp;&nbsp;  <br>
<br>
  NOTE: SQL table SASHELP.CLASS was created like: <br>
<br>
  create table SASHELP.CLASS( bufsize=4096 )&nbsp;&nbsp;  <br>
&nbsp;&nbsp;&nbsp;  (  <br>
&nbsp;&nbsp;&nbsp;&nbsp;  Name char(8),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <br>
&nbsp;&nbsp;&nbsp;&nbsp;  Sex char(1),<br>
&nbsp;&nbsp;&nbsp;&nbsp;  Age num, <br>
&nbsp;&nbsp;&nbsp;&nbsp;  Height num,<br>
&nbsp;&nbsp;&nbsp;&nbsp;  Weight num <br>
&nbsp;&nbsp;&nbsp;  ); <br>
<br>
  Which SQL procedure statement <br>
  generated this output?</font></p>
<p><br>
<font size="4" face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  A.<br>
CONTENTS FROM SASHELP.CLASS;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  B.<br>
CREATE FROM SASHELP.CLASS INTO LOG;&nbsp;&nbsp;&nbsp;&nbsp;  <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  C.<br>
DESCRIBE TABLE SASHELP.CLASS;&nbsp;&nbsp;&nbsp;&nbsp;  <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  D.<br>
VALIDATE SELECT * FROM SASHELP.CLASS;&nbsp;&nbsp;  </font></p>
<p><font size="4" face="宋体">本题考察的是SQL中DESCRIB语句<br>
DESCRIB语句和CONTENTS过程相似，都是了解一个数据集的属性信息。</font></p>
<p><font size="4" face="宋体">示例程序：<br>
proc sql;<br>
describe table sashelp.class;<br>
quit;<br>
</font></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/fef5283bae26d9fc55e72355.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/fef5283bae26d9fc55e72355.html#comment">查看评论</a>

---

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

Powered by Discuz! X3.2