Hi,
I have a list of incoming payments, the payments are related to debts. The payer is not necessarily same person who the debt belongs to (i.e. someone else can pay off the debt). I want to count how many debts the person whose debt was paid off had BEFORE and AFTER the payment in question.
So one row could look something like this:
Payment date // Payment amount // Payer // Debtor // Debts before payment // Debts after payment
I've looked in to solving this with a conditional COUNT function (e.g.: COUNT(payment date < loan date) but this doesn't seem to work.
Help would be much appreciated.
BR
Post some test data please?
- Cheers -
posted sample data and expected result from that sample data. Someone will be able to help you .
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.