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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.