data test;
input prov year num other;
cards;
1 2000 1 0
1 2001 2 1
1 2002 3 5
2 2000 2 1
2 2002 5 2
;
proc sql;
create table wanted as
select prov, sum(num) as num
from test
group by 1;
quit;
wwang111 发表于 2014-3-18 16:19
data test;
input prov year num other;
cards;
您好！我还有个问题，就是要对两个分组变量统计，比如省份、行业，统计各年关于两个变量的和。我用下面的程序
proc sql;
create table wanted as
select prov industry, sum(num1) as num1 sum(num2) as num2
from test
group by 1;
quit;
提示在第二个sum那有误，请问要如何改呢？
非常感谢！
扫码加好友，拉您进群
全部版块
我的主页
收藏
