跟crackman做sas adv认证试题（4）

shiyiming

From crackman's blog on Baidu


               
                <p><font size="4" face="宋体"> The SAS data set WORK.CHECK has an index&nbsp;&nbsp;&nbsp;&nbsp;  <br>
  on the variable Code and the following SAS&nbsp;&nbsp;  <br>
  program is submitted. <br>
<br>
  proc sort data=WORK.CHECK;&nbsp;&nbsp;&nbsp;  <br>
&nbsp;&nbsp;&nbsp;&nbsp;  by Code; <br>
  run; <br>
<br>
  Which describes the result of submitting&nbsp;&nbsp;&nbsp;&nbsp;  <br>
  the SAS program?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  </font></p>
<p><br>
<font size="4" face="宋体">A. The index on Code is deleted.&nbsp;&nbsp;  <br>
<br>
B.The index on Code is updated.&nbsp;&nbsp;  <br>
<br>
C.The index on Code is uneffected.<br>
<br>
D.The sort does not execute.&nbsp;&nbsp;  </font></p>
<p><font size="4" face="宋体">答案为D.<br>
SORT过程是不能对已经建立索引INDEX的数据集进行SORT或者REPLACE，因为那样会破坏数据集的INDEX文件。<br>
当然如果非要排序，破坏INDEX文件，可以再后面加入一个参数 force。</font></p>
<p><font size="4" face="宋体">其实这里大家可以思考一个问题：sort和index的差别是什么？ </font></p>
<p><font size="4" face="宋体">此问题可以参看文献</font></p>
<p><font size="4" face="宋体"><a href="http://www2.sas.com/proceedings/sugi26/p121-26.pdf"><!-- m --><a class="postlink" href="http://www2.sas.com/proceedings/sugi26/p121-26.pdf">http://www2.sas.com/proceedings/sugi26/p121-26.pdf</a><!-- m --></a>&nbsp;&nbsp;<br>
<br>
</font></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/c5fc72f0ee1b18c9f3d385b0.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/c5fc72f0ee1b18c9f3d385b0.html#comment">查看评论</a>