BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RajK
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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;

View solution in original post

2 REPLIES 2
Reeza
Super User

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
Tourmaline | Level 20

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

Data never sleeps

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 859 views
  • 3 likes
  • 3 in conversation