getting max and min value by group

[Adnan_Razaq]

Hi,

I have

account   date   arrears 

1              Jan      0         

1              Feb      1             

1              Mar      0             

1              Apr       2            

2              Jan       0             

2              Feb       1             

2              Mar       2             

I need

account   date   arrears  max_arrears

1              Jan      0              0

1              Feb      1              1

1              Mar      0              1

1              Apr       2              2

2              Jan       0              0

2              Feb       1              1

2              Mar       2              2

Any coding suggestions please?

Thanks in advance

Adnan

[LinusH]

Not sure if you request matches your subject...

But, use RETAIN within a data step.

[Reeza]

There is no max or min that I see, only keeping the previous value. Can you clarify your requirements? 

It may be as a simple as:

if first.account then max_value =arrears;

else max_value = max(max_value, arrears);

[Adnan_Razaq]

Apologies for the confusion.

What I require is  the max arrears value by account and date.

Thanks

Adnan

[RW9]

Post test data in the form of a datastep.

Just a guess:

data want;
  set have;
  retain max_arrears;
  by account;
  if first.account then max_arrears=0;
  if arrears > max_arrears then max_arrears=arrears;
run;