用于下列数据集
data example;
input x y;
cards;
1 8
2 7
3 6
4 5
;
run;我想创建一个新的数据集,其中添加了以下列:
sum
10
9
7
410来自于第一列(1+2+3+4)的求和,9来自(2+3+4),等等。
发布于 2016-06-25 21:01:36
考虑使用proc sql的相关聚合子查询
proc sql;
create table cumsum as
(select sup.x, sup.y,
(select sum(sub.x) from example as sub where sub.x >= sup.x) as sum
from example as sup);
quit;
x y sum
1 8 10
2 7 9
3 6 7
4 5 4或者,您可以通过数据步骤运行累积和。由于您需要一个递减的累积和,所以需要先排序和后排序:
proc sort data=example out=example;
by descending x;
run;
data cumsum2;
set example;
if first.x then sum = 0;
sum + x;
run;
proc sort data=cumsum2 out=cumsum2;
by x;
run;
x y sum
1 8 10
2 7 9
3 6 7
4 5 4https://stackoverflow.com/questions/38032726
复制相似问题