Conditional counting given dates

Svanton — Tue, 11 Jul 2017 12:13:38 GMT

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.

Re: Conditional counting given dates

Oligolas — Tue, 11 Jul 2017 13:38:30 GMT

Post some test data please?

Re: Conditional counting given dates

kiranv_ — Tue, 11 Jul 2017 13:40:35 GMT

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

topic Re: Conditional counting given dates in SAS Programming

Conditional counting given dates

Re: Conditional counting given dates

Re: Conditional counting given dates