跟crakman做sas base认证试题（24）

shiyiming

From crackman's blog on Baidu


               
                <p><font size="4">24.Given the following raw data records:<br>
<br>
  ----|----10---|----20---|----30<br>
  Susan*12/29/1970*10<br>
  Michael**6<br>
<br>
The following output is desired: <br>
<br>
  Obs  employee&nbsp;&nbsp;  bdate  years <br>
&nbsp;&nbsp;  1&nbsp;&nbsp;  Susan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  4015&nbsp;&nbsp;&nbsp;  10<br>
&nbsp;&nbsp;  2&nbsp;&nbsp;  Michael&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  .&nbsp;&nbsp;&nbsp;&nbsp;  6<br>
<br>
Which SAS program correctly reads in the raw data? <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  A.<br>
data employees; <br>
&nbsp;&nbsp;  infile 'file specification' dlm='*';<br>
&nbsp;&nbsp;  input employee $ bdate : mmddyy10. years; <br>
run; <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  B.<br>
data employees; <br>
&nbsp;&nbsp;  infile 'file specification' dsd='*';<br>
&nbsp;&nbsp;  input employee $ bdate mmddyy10. years; <br>
run; <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  C.<br>
data employees; <br>
&nbsp;&nbsp;  infile 'file specification' dlm dsd;<br>
&nbsp;&nbsp;  input employee $ bdate mmddyy10. years; <br>
run; <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  D.<br>
data employees; <br>
&nbsp;&nbsp;  infile 'file specification' dlm='*' dsd;<br>
&nbsp;&nbsp;  input employee $ bdate : mmddyy10. years; <br>
run; <br>
<br>
Answer: D</font></p>
<p><font size="4">本文属于博客：<a href="http://hi.baidu.com/crack_man/home"><!-- m --><a class="postlink" href="http://hi.baidu.com/crack_man/home">http://hi.baidu.com/crack_man/home</a><!-- m --></a> 版权归作者所有，如有转载，请注明出处！未经本作者同意不得用于商业应用。<br>
其他本博客文章均作此声明！</font></p>
<p><font size="4">本题中考察的就是INFILE语句中DLM DSD的作用。<br>
DSD：就是处理两个分隔符之间没有数据时，默认为缺失值<br>
DLM：指定分隔符。<br>
关于这两个参数前面有文章将的很清楚。<br>
</font></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/2c30be41b3bbca36cefca378.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/2c30be41b3bbca36cefca378.html#comment">查看评论</a>