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).
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.