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).
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.