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

shiyiming

From crackman's blog on Baidu


               
                <p><font size="4">52.Given the SAS data set WORK.EMP_NAME:<br>
<br>
  Name  EmpID<br>
  ----  -----<br>
  Jill&nbsp;&nbsp;  1864<br>
  Jack&nbsp;&nbsp;  2121<br>
  Joan&nbsp;&nbsp;  4698<br>
  John&nbsp;&nbsp;  5463<br>
<br>
Given the SAS data set WORK.EMP_DEPT:<br>
<br>
  EmpID  Department<br>
  -----  ----------<br>
&nbsp;&nbsp;  2121  Accounting<br>
&nbsp;&nbsp;  3567  Finance<br>
&nbsp;&nbsp;  4698  Marketing <br>
&nbsp;&nbsp;  5463  Accounting<br>
<br>
The following program is submitted:<br>
<br>
  data WORK.ALL;<br>
&nbsp;&nbsp;&nbsp;&nbsp;  merge WORK.EMP_NAME(in=Emp_N) <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  WORK.EMP_DEPT(in=Emp_D);<br>
&nbsp;&nbsp;&nbsp;&nbsp;  by Empid; <br>
&nbsp;&nbsp;&nbsp;&nbsp;  if (Emp_N and not Emp_D) or (Emp_D and not Emp_N);<br>
  run;<br>
<br>
How many observations are in data set WORK.ALL after submitting the program?</font></p>
<p><font size="4">&nbsp;&nbsp;&nbsp;&nbsp;  A. 1 <br>
&nbsp;&nbsp;&nbsp;&nbsp;  B. 2 <br>
&nbsp;&nbsp;&nbsp;&nbsp;  C. 3 <br>
&nbsp;&nbsp;&nbsp;&nbsp;  D. 5 </font></p>
<p><font size="4">Answer: B</font></p>
<p><font size="4">这个里面考察的还是merge语句+BY语句。<br>
具体解释可以看看文章：<br>
</font><a href="http://hi.baidu.com/crack_man/blog/item/16acc5bbfa88ce1a18d81f76.html"><font size="4"><!-- m --><a class="postlink" href="http://hi.baidu.com/crack_man/blog/item/16acc5bbfa88ce1a18d81f76.html">http://hi.baidu.com/crack_man/blog/item ... 81f76.html</a><!-- m --></font></a></p> <a href="http://hi.baidu.com/crack%5Fman/blog/item/a2cc05d3d838cccda044df40.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/a2cc05d3d838cccda044df40.html#comment">查看评论</a>