SAS中文论坛

标题: 跟crakman做sas base认证试题（48） [打印本页]
作者: shiyiming    时间: 2010-11-13 00:31
标题: 跟crakman做sas base认证试题（48）
From crackman's blog on Baidu


               
                <p><font size="4">48.The following SAS program is submitted:<br>
<br>
  data WORK.TEST;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  drop City;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  infile datalines; <br>
&nbsp;&nbsp;&nbsp;&nbsp;  input <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Name $ 1-14 /<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Address $ 1-14 / <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  City $ 1-12 ;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  if City='New York  ' then input @1 State $2.; <br>
&nbsp;&nbsp;&nbsp;&nbsp;  else input; <br>
  datalines; <br>
  Joe Conley <br>
  123 Main St.<br>
  Janesville <br>
  WI<br>
  Jane Ngyuen<br>
  555 Alpha Ave. <br>
  New York <br>
  NY<br>
  Jennifer Jason <br>
  666 Mt. Diablo <br>
  Eureka<br>
  CA<br>
  ;<br>
<br>
What will the data set WORK.TEST contain?</font></p>
<p><br>
<font size="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  A.<br>
Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  State <br>
--------------&nbsp;&nbsp;&nbsp;  ----------------&nbsp;&nbsp;  ------<br>
Joe Conley&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  123 Main St. <br>
Jane Ngyuen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  555 Alpha Ave.&nbsp;&nbsp;&nbsp;&nbsp;  NY<br>
Jennifer Jason&nbsp;&nbsp;&nbsp;  666 Mt. Diablo<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  B.<br>
Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  City&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  State<br>
--------------&nbsp;&nbsp;&nbsp;  ----------------  -----------  ------<br>
Joe Conley&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  123 Main St.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Janesville<br>
Jane Ngyuen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  555 Alpha Ave.&nbsp;&nbsp;&nbsp;  New York&nbsp;&nbsp;&nbsp;&nbsp;  NY<br>
Jennifer Jason&nbsp;&nbsp;&nbsp;  666 Mt. Diablo&nbsp;&nbsp;&nbsp;  Eureka <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  C.<br>
Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  State <br>
--------------&nbsp;&nbsp;&nbsp;  ----------------&nbsp;&nbsp;  ------<br>
Jane Ngyuen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  555 Alpha Ave.&nbsp;&nbsp;&nbsp;&nbsp;  NY<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;  D. O observations,there is a syntax error in the data step.<br>
<br>
Answer:A</font></p>
<p><font size="4">本文属于博客：</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">这道题考察的时候INPUT语句中读入数据的指针走向，现在解析如下：<br>
程序编译后，建立PDV，此时只有三个Name Address City ，在DATA步执行语句中加入另外一个变量STATE到PDV中。<br>
Name $ 1-14 /<br>
Address $ 1-14 / <br>
City $ 1-12 ;<br>
按照指定的列项读取每一行数据，/表示换行读取。<br>
当CITY数据读入之后，指针进入下一行，就是WI，此时，根据判断，进入ELSE中的执行语句INPUT，此时的INPUT没有指定此行数据读</font></p>
<p><font size="4">入PDV中那个变量，等于是让指针释放此行数据，进入下一个数据行。那么STATE为默认缺失值。重复前面的过程。<br>
</font></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/86c09e0ea75d7c0f94ca6b78.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/86c09e0ea75d7c0f94ca6b78.html#comment">查看评论</a>



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