/* 方法一: SQL
data crackman;
input income @@;
datalines;
3000 2000 5000 1400 5400 2800
;
run;
proc sql;
create table crackman as select *, sum(income) as total label="income总计" from crackman;
quit;
*/
/* 方法二:LAG函数
data crackman;
input income @@;
total=lag(income)+lag2(income)+lag3(income)+lag4(income)+lag5(income);
call symput("total",total);
datalines;
3000 2000 5000 1400 5400 2800
;
run;
data crackman;
set crackman;
total=&total.;
run;
*/
/* 方法三:DATA PDV +merge
data crackman;
input income @@;
datalines;
3000 2000 5000 1400 5400 2800
;
run;
data crackman1;
set crackman end=end;
total+income;
if end=1;
run;
data crackman;
merge crackman1 crackman;
run;
data crackman;
set crackman;
newtotal+total;
drop total;
run;
*/
|