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

cecily — Fri, 03 Jul 2015 19:50:19 GMT

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?

Re: create a new variable that record the largest count from the first.class until the current class in a group

Reeza — Fri, 03 Jul 2015 20:30:01 GMT

Look up RETAIN