topic Re: Summinng on first and last. in SAS Procedures

Summinng on first and last.

deleted_user — Mon, 01 Jun 2009 09:54:51 GMT

Hi

i have a data i want the income sum betweeen where first=1 and last=1;

id inco first last
1 2 1 0
1 2 0 0
2 2 0 1
3 4 1 0
4 6 0 0
5 7 0 1

the output is like this

id inc first last final_tot
1 2 1 0
1 2 0 0
2 2 0 1 4
3 4 1 0
4 6 0 0
5 7 0 1 12

Re: Summinng on first and last.

LinusH — Mon, 01 Jun 2009 10:04:11 GMT

You should explore the use of BY group processing techniques in the data step such as FIRST. and LAST., together with RETAIN.

/Linus

Re: Summinng on first and last.

deleted_user — Mon, 01 Jun 2009 10:20:14 GMT

in the o/p you have shown ,
you are adding id and inco where last=1.

but you are saying "income sum betweeen where first=1 and last=1"
here is solution.

data i;
input id inco first last;
cards;
1 2 1 0
1 2 0 0
2 2 0 1
3 4 1 0
4 6 0 0
5 7 0 1
;

data i1;
set i;
retain tot 0;
if first=1 then tot = inco;
else if last = 1 then final_tot = tot + inco;
else tot = tot + inco;
drop tot;
run;

o/p - i1

id inc first last final_tot
1 2 1 0
1 2 0 0
2 2 0 1 6
3 4 1 0
4 6 0 0
5 7 0 1 17