Help using Base SAS procedures

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

Reply
Contributor
Posts: 31

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

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?

Super User
Posts: 17,949

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

Look up RETAIN

Ask a Question
Discussion stats
  • 1 reply
  • 196 views
  • 0 likes
  • 2 in conversation