BookmarkSubscribeRSS Feed
cecily
Calcite | Level 5

the following is original data

class   count

1          2

1          1

1          2

1          3

1          2

2          4

2          2

2          4

3          5

3          1

3          5

I would like to create a new variable that record the largest count from the first.class until the current class in a group.

Here is what I want to get.

class   count     record(the largest)

1          2             2

1          1             2

1          2             2

1          3             3

1          2             3

2          4             4

2          2             4

2          3             4

3          3             3

3          1             3

3          5             5

I tried :

data object_chapter_number4 ;

set object_chapter_number2;

if count> record then record=count;

by class count;

if first.class  then record=count ;

run;

But it is not what I want to get.....How could I do?

1 REPLY 1

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

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 1 reply
  • 892 views
  • 0 likes
  • 2 in conversation