SAS ADVANCE 63 题的一道看晕头的题疑问

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Given the following SAS data sets:   

  WORK.VISIT1             WORK.VISIT2   

  Id     Expense          Id     Cost   
  —    ——-          —    —-   
  001        500          001     300   
  001        400          002     600   
  003        350

  The following result set was summarized and
  consolidated using the SQL procedure:

  Id     Cost
  —    —-
  001     300
  001     900
  002     600
  003     350

  Which of the following SQL statements was   
  most likely used to generate this result?   
A.
select
   Id,
   sum(Expense) label=’COST’   
from WORK.VISIT1
group by 1   
union all   
select
   Id,
   sum(Cost)
from WORK.VISIT2
group by 1   
order by 1,2
;     

B.
select
   id,
   sum(expense) as COST
from  
   WORK.VISIT1(rename=(Expense=Cost)),  
   WORK.VISIT2
where VISIT1.Id=VISIT2.Id      
group by Id  
order by     
   Id,
   Cost
;     

C.
select
   VISIT1.Id,
   sum(Cost) as Cost   
from  
   WORK.VISIT1(rename=(Expense=Cost)),  
   WORK.VISIT2
where VISIT1.Id=VISIT2.Id      
group by Id  
order by     
   Id,
   Cost
;     

D.
select
   Id,
   sum(Expense) as Cost
from WORK.VISIT1
group by Id  
outer union corr
select
   Id,
   sum(Cost)
from WORK.VISIT2
group by Id  
order by 1,2

大牛们, 有的选a, 有的选d.  正确答案应该是什么?

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：ADVANCE VANCE advan ance NCE following

data visit1;
input id Expense;
cards;
001 500
001 400
003 350
;
run;
data visit2;
input id cost;
cards;
001 300
002 600
;

proc sql;
select
   Id,
   sum(Expense) label="COST"   
from WORK.VISIT1
group by 1   
union all   
select
   Id,
   sum(Cost)
from WORK.VISIT2
group by 1   
order by 1,2
;     
quit;
id COST
1 300
1 900
2 600
3 350

proc sql;
select
   Id,
   sum(Expense) as Cost
from WORK.VISIT1
group by Id  
outer union corr
select
   Id,
   sum(Cost)
from WORK.VISIT2
group by Id  
order by 1,2   
;
quit;
The SAS System


id Cost   
1 . 300
1 900 .
2 . 600
3 350 .

选A

其实d改一下，就对了proc sql;
select
   Id,
   sum(Expense) as Cost
from WORK.VISIT1
group by Id  
outer union corr
select
   Id,
   sum(Cost) as cost
from WORK.VISIT2
group by Id  
order by 1,2   
;
quit;

D最后生成了  三列  第二个SELECT里面  sum（cost）是一个没有名字的单独列。。。。。。

楼上的有SAS高手不？（在校学生），偶有朋友急需sas培训师，有意向的盆友们联系我哦！qq：2579858093 tel:13810097914

doudoudphyn 发表于 2014-3-11 10:35
楼上的有SAS高手不？（在校学生），偶有朋友急需sas培训师，有意向的盆友们联系我哦！qq：2579858093 tel ...

你可以让你的朋友报一个SAS的培训班，更靠谱

a, d 语法都对，但是A里面的COST是大写，和结果不符合，所以选D