SAS中文论坛

标题: 跟crakman做sas base认证试题（52） [打印本页]

作者: shiyiming 时间: 2010-11-13 10:36
标题: 跟crakman做sas base认证试题（52）
From crackman's blog on Baidu

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

 类别：<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> <a href="http://hi.baidu.com/crack%5Fman/blog/item/a2cc05d3d838cccda044df40.html#comment">查看评论</a>

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)