如何达到如下效果的表格:
Item Average of branch A company overall
Service 4.6 4.5
Quality 3.6 4.1
所有的branch要相同的表格, 但都要比较company overall.
数据格式如下:
branch Service Quality
A 5 4
B 4 4
C 3 3
D 5 5
.......
谢谢了作者: shiyiming 时间: 2010-2-16 17:04 标题: Re: 求助: 如何用proc report创建分组数据时, 加入总部比较? 先瞎写一个占个地
[code:22gvegjd]data raw;
input Branch $ Service Quality;
datalines;
A 5 4
A 4 3
B 4 4
B 3 3
C 3 3
C 2 2
D 5 5
D 4 4
;
proc sql;
create table temp as
select a.*,b.company_val
from (select branch,'service' as Item,avg(service) as branch_val from raw group by branch
union
select branch,'quality' as item,avg(quality) as branch_val from raw group by branch) a
left join
(select 'service' as item,avg(service) as company_val from raw
union
select 'quality' as item,avg(quality) as company_val from raw) b
on a.item=b.item
order by branch,item desc;
quit;