SAS中文论坛

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

---

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


               
                <p><font size="4" face="宋体">60.Given the SAS data set WORK.PRODUCTS:<br>
<br>
  ProdId&nbsp;&nbsp;&nbsp;  Price&nbsp;&nbsp;&nbsp;  ProductType&nbsp;&nbsp;&nbsp;  Sales&nbsp;&nbsp;&nbsp;  Returns <br>
  ------&nbsp;&nbsp;&nbsp;  -----&nbsp;&nbsp;&nbsp;  -----------&nbsp;&nbsp;&nbsp;  -----&nbsp;&nbsp;&nbsp;  ------- <br>
  K12S&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  95.50&nbsp;&nbsp;&nbsp;  OUTDOOR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  2 <br>
  B132S&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  2.99&nbsp;&nbsp;&nbsp;  CLOTHING&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  10 <br>
  R18KY2&nbsp;&nbsp;&nbsp;  51.99&nbsp;&nbsp;&nbsp;  EQUIPMENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  5 <br>
  3KL8BY&nbsp;&nbsp;&nbsp;&nbsp;  6.39&nbsp;&nbsp;&nbsp;  OUTDOOR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  15 <br>
  DY65DW&nbsp;&nbsp;&nbsp;&nbsp;  5.60&nbsp;&nbsp;&nbsp;  OUTDOOR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  5 <br>
  DGTY23&nbsp;&nbsp;&nbsp;  34.55&nbsp;&nbsp;&nbsp;  EQUIPMENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  67&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  2 <br>
<br>
The following SAS program is submitted:<br>
<br>
  data WORK.REVENUE(drop=Sales Returns Price);<br>
&nbsp;&nbsp;&nbsp;&nbsp;  set WORK.PRODUCTS(keep=ProdId Price Sales Returns); <br>
&nbsp;&nbsp;&nbsp;&nbsp;  Revenue=Price*(Sales-Returns);<br>
  run;<br>
<br>
How many variables does the WORK.REVENUE data set contain?</font></p>
<p><font size="4" face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;  A. 2 <br>
&nbsp;&nbsp;&nbsp;&nbsp;  B. 3 <br>
&nbsp;&nbsp;&nbsp;&nbsp;  C. 4 <br>
&nbsp;&nbsp;&nbsp;&nbsp;  D. 6 </font></p>
<p><font size="4" face="宋体">Answer: A</font></p>
<p><font size="4" face="宋体">本文属于博客：</font><a href="http://hi.baidu.com/crack_man/home"><font size="4" face="宋体"><!-- m --><a class="postlink" href="http://hi.baidu.com/crack_man/home">http://hi.baidu.com/crack_man/home</a><!-- m --></font></a><font size="4" face="宋体"> 版权归作者所有，欢迎转载！如有转载，请务必注明出处！未经本文作者同意</font></p>
<p><font size="4" face="宋体">不得用于商业应用。</font></p>
<p><font size="4" face="宋体">答案是A，只有两个，一个是prodid，一个是revenue。</font></p>
<p><font size="4" face="宋体">SET WORK.PRODUCTS(keep=ProdId Price Sales Returns)这条语句，在建立PDV时，就已经对ProdId Price Sales Returns做了KEEP操</font></p>
<p><font size="4" face="宋体">作，所以当你在：</font></p>
<p><font size="4" face="宋体">  data WORK.REVENUE(drop=Sales Returns Price);<br>
&nbsp;&nbsp;&nbsp;&nbsp;  set WORK.PRODUCTS(keep=ProdId Price Sales Returns); <br>
&nbsp;&nbsp;&nbsp;&nbsp;  Revenue=Price*(Sales-Returns);<br>
&nbsp;&nbsp;&nbsp;&nbsp;  PUT  ProductType；<br>
  run;<br>
<br>
ProductType是缺失值，等于是在DATA 步中再次建立一个变量，名字叫 ProductType。</font></p>
<p> </p>
<p> </p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/d9e3838667961580f703a6c5.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/d9e3838667961580f703a6c5.html#comment">查看评论</a>

---

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

Powered by Discuz! X3.2