aggreagte function for each row going backwards in date

[RajK]

Hi all,

Can any one help me out with the following?

i want to get max(cnt) by date upto that particular date. For example i want my result dataset to be like below.

datalines;

date               cnt

23march2013 10

24march2013 25

14april2013 15

15april2013 30

18april2013 17

result dataset:

date max(cnt)

23march2013 10

24march2013 25

14april2013 25

15april2013 30

18april2013 30

Thanks in advance,

RK

[Reeza · Accepted solution]

Look up the retain statement.

You want to retain the variable and if the CNT is larger then change it to the new maximum.

data want;

set have;

retain max_cnt 0;

if cnt>max_cnt then max_cnt=cnt;

run;

[LinusH]

Just retain a new variable max_cnt, and do max_cnt = max(max_cnt,cnt).