求教一个adv 机经题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

我写的

dataProduct;

inputProduct_id Product;

datalines;

1 1001

2 1002

3 1003

;

dataSales;

inputProduct_id Sales;

datalines;

3 100

1 200

5 100

1 200

3 100

1 100

;

以下我copy机经上的code,

Proc sql;

Select p.product,s.totalsales

From product as p

left join (

select sum(sales)as totalsales

from sales as s)

onp.product_id=s.product_id;

quit;

不能得到以下结果。

Whatis the output?

Answer:

ProductTotalsales

1001500

1002.

1003 200

406  Proc sql;

407  Select p.product, s.totalsales

408  From product as p

409  left join (

410  select sum(sales) as totalsales

411  from sales as s)

412  on p.product_id=s.product_id;

ERROR: Column totalsales could not be found in the table/viewidentified with the correlation

       name S.

413  quit;

NOTE:The SAS System stopped processing this step because of errors.

NOTE:PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01

扫码加我 拉你入群

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

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

分享0 收藏1 回帖

关键词：correlation identified Processing left join Procedure

稍微改了一下：data product;
input product_id product;
datalines;
1 1001
2 1002
3 1003
;

data sales;
input product_id sales;
datalines;
3 100
1 200
5 100
1 200
3 100
1 100
;

proc sql;
select p.product,totalsales
from product as p
left join (
select sum(sales) as totalsales
from sales as s
group by product_id
)
on p.product_id=s.product_id;
quit;

Thanks a lot for your kindness. I could not figure out what was wrong before.