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
Not sure if you request matches your subject...
But, use RETAIN within a data step.
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);
Apologies for the confusion.
What I require is the max arrears value by account and date.
Thanks
Adnan
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.