topic Re: How to sum a particular column in SAS through data step. in SAS Programming

How to sum a particular column in SAS through data step.

ajay_mishra — Mon, 15 Jan 2018 11:10:49 GMT

How to sum a particular column in SAS.

If I have a data then

age

How can I get the sum of the variable Age in Data Step.

RW9 — Mon, 15 Jan 2018 11:22:33 GMT

data want;
  set have;
  retain sum_age 0;
  sum_age=sum(sum_age,age);
run;

novinosrin — Mon, 15 Jan 2018 14:26:12 GMT

I prefer a sum statement

data have;
input age;
datalines;
15
23
63
56
78
45
;

data want;
set have;
sum_of_age+age;
run;

art297 — Mon, 15 Jan 2018 14:35:31 GMT

The two methods proposed will result in the running sums for each record, with only the last record reflecting the total sum. Is that what you want?

Art, CEO, AnalystFinder.com

novinosrin — Mon, 15 Jan 2018 14:37:17 GMT

Hmm love Art's attention to finer detail:

data have;
input age;
datalines;
15
23
63
56
78
45
;

data want;
set have end=last;
sum_of_age+age;
if last;
run;

Reeza — Mon, 15 Jan 2018 15:51:20 GMT

Change the MAX from this question to SUM. The idea is the same, you should be able to extend it to your new question: