SAS中文论坛

标题: 跟crakman做sas base认证试题(36) [打印本页]

作者: shiyiming    时间: 2010-11-12 16:25
标题: 跟crakman做sas base认证试题(36)
From crackman's blog on Baidu


               
                <p><font size="4">36.Given the contents of the raw data file 'EMPLOYEE.TXT':<br>
<br>
  ----+----10---+----20---+----30--<br>
  Xing&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  2 19 2004 ACCT<br>
  Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  5 22 2004 MKTG<br>
  Jorge&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  3 14 2004 EDUC<br>
<br>
The following SAS program is submitted:<br>
<br>
  data WORK.EMPLOYEE;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  infile 'EMPLOYEE.TXT' ;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  input <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  @1  FirstName $<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  @15 StartDate  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  @25 Department $;<br>
  run;<br>
<br>
Which SAS informat correctly completes the program?<br>
&nbsp;&nbsp;&nbsp;&nbsp;  A. date9.<br>
&nbsp;&nbsp;&nbsp;&nbsp;  B. mmddyy10.<br>
&nbsp;&nbsp;&nbsp;&nbsp;  C. ddmmyy10.<br>
&nbsp;&nbsp;&nbsp;&nbsp;  D. mondayyr10.</font></p>
<p><font size="4">Answer: B<br>
本文属于博客:</font><a href="http://hi.baidu.com/crack_man/home"><font size="4"><!-- 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"> 版权归作者所有,欢迎转载!如有转载,请务必注明出处!未经本文作者同意</font></p>
<p><font size="4">不得用于商业应用。</font></p>
<p><font size="4">本题考察的是时间日期数据的格式问题。</font></p>
<p><font size="4">完成的程序是:<br>
data WORK.EMPLOYEE;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  infile 'EMPLOYEE.TXT' ;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  informat startdate mmddyy10.;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  input <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  @1  FirstName $<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  @15 StartDate  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  @25 Department $;<br>
  run;</font></p>
<p><font size="4">MMDDYY10.数据格式:<br>
&nbsp;&nbsp;&nbsp;  08 11 2009<br>
&nbsp;&nbsp;&nbsp;  8  11 2009<br>
&nbsp;&nbsp;&nbsp;  11 12 2009<br>
&nbsp;&nbsp;&nbsp;  08-11-2009<br>
&nbsp;&nbsp;&nbsp;  08/11/2009<br>
等等这些格式都可以读取。<br>
@1其实列指针指向第一列,@15就是指向第十五列读取数据。</font></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/6a9ad4c0ee79d2db38db49c8.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/6a9ad4c0ee79d2db38db49c8.html#comment">查看评论</a>




欢迎光临 SAS中文论坛 (https://mysas.net/forum/) Powered by Discuz! X3.2