DATA Step, Macro, Functions and more

Conditional counting given dates

Reply
Frequent Learner
Posts: 1

Conditional counting given dates

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

 

 

Frequent Contributor
Posts: 129

Re: Conditional counting given dates

Post some test data please?

________________________

- Cheers -

PROC Star
Posts: 325

Re: Conditional counting given dates

posted sample data and expected result from that sample data. Someone will be able to help you .

Ask a Question
Discussion stats
  • 2 replies
  • 65 views
  • 0 likes
  • 3 in conversation