topic aggreagte function for each row going backwards in date in SAS Programming

aggreagte function for each row going backwards in date

RajK — Tue, 12 Nov 2013 16:21:38 GMT

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,

Reeza — Tue, 12 Nov 2013 16:29:24 GMT

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 — Tue, 12 Nov 2013 16:33:36 GMT

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