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
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;
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;
Just retain a new variable max_cnt, and do max_cnt = max(max_cnt,cnt).
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.