topic Re: getting max and min value by group in SAS Programming

getting max and min value by group

Adnan_Razaq — Wed, 07 Jun 2017 13:56:34 GMT

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

Re: getting max and min value by group

LinusH — Wed, 07 Jun 2017 14:06:07 GMT

Not sure if you request matches your subject...

But, use RETAIN within a data step.

Re: getting max and min value by group

Reeza — Wed, 07 Jun 2017 14:18:21 GMT

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);

Re: getting max and min value by group

Adnan_Razaq — Wed, 07 Jun 2017 14:29:04 GMT

Apologies for the confusion.

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

Thanks

Adnan

Re: getting max and min value by group

RW9 — Wed, 07 Jun 2017 14:38:32 GMT

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;