SAS中文论坛

标题: 如何实现同一层数据的叠加 [打印本页]

作者: shiyiming 时间: 2006-5-25 17:13
标题: 如何实现同一层数据的叠加
我的数据库如下：
id country cost;
1  1       23
1  1       34
1  2       21
1  2       21
1  3       12
1  3       10
2  1       10
2  1       23
2  2       12
2  2       23

我想把同一个id 和country的 cost值相加得到下列的数据
id country cost;
1  1       57
1  2       42
1  3       22
2  1       33
2  2       35

请问如何实现，谢谢

作者: shiyiming 时间: 2006-5-26 04:24
标题: RE:
[code:5881a]
proc sql;
  create table b as
  select id,country, sum(cost) as cost
  from a
  group by id, country;
quit;
[/code:5881a]

作者: shiyiming 时间: 2006-6-4 20:12
标题: data 步
proc sort data = A;
   by id country;
run;

proc summary data = A nway missing;
   class id country;
   var cost;
   output out = B sum=;
run;

欢迎光临 SAS中文论坛 (http://mysas.net/forum/)