Aug 4 2015北美SAS ADV 98%最强机经

楼主，你第一道题里select 后面的column 之间要加逗号哦

谢谢楼主，先mark一下。前天刚100%过了base，下个月的目标advance

yangqin4587 发表于 2016-1-16 10:19
一道新题
left join and in-line view
Product

15         Proc sql;
16           Select p.product, s.totalsales
17            From product as p
18                         left join (select sum(sales) as totalsales from sales as s)
19                         on p.product_id=s.product_id;
ERROR: Column totalsales could not be found in the table/view identified with the correlation name S.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

if i remove the s. from s.totalsale,

15         Proc sql;
16           Select p.product, totalsales
17            From product as p
18                         left join (select sum(sales) as totalsales from sales as s)
19                         on p.product_id=s.product_id;
NOTE: The query requires remerging summary statistics back with the original data.
and output is :
product totalsales
1001 800
1001 800
1001 800
1002 .
1003 800
1003 800

any ideas?

谢谢楼主~~

多谢您的分享

多谢楼主

lovedieer 发表于 2016-10-27 02:42
15         Proc sql;
16           Select p.product, s.totalsales
17            From product as p ...

我跑出来也是这个结果，不知您在考试的时候有没有遇到类似的题目呢？