topic Finding the default customers from the data in SAS Programming

Finding the default customers from the data

Shivi82 — Tue, 29 Dec 2015 13:31:27 GMT

Dear Team,

I am working on a collections assignment for one of my clientele.

The requirement is that they need to analyze how's the pay pattern of customers and who are a pain area.

For this i have started with creating day level drill down of customers based on payment days. so customers make payment from a period of 10 days to over 1000 days.

so i used a case statement and created various segments with respective population.

The challenge i have now is that since this data is for past 1 year hence there are instances where a customer (SFX code) might have made a payment in 10 days whereas the same customer would have made the payment in 50 or 100 or even more days.

Hence i need to know % payments made within x number of days.

I could have created a new var as total where total = category + category 2 (first 2 lowest categories)/ total = x% and then i could have filtered however as these categories are calculated columns hence i cannot use this as well.

Request you to please suggest an alternate.

Attached some data for examination.

Regards, Shivi

Re: Finding the default customers from the data

Reeza — Tue, 29 Dec 2015 20:04:38 GMT

Why can't you filter? Are you using SAS BASE or SAS VA?

Re: Finding the default customers from the data

Reeza — Tue, 29 Dec 2015 20:05:07 GMT

For default analysis, or Churn, you can look at survival methods as well.

Re: Finding the default customers from the data

Shivi82 — Wed, 30 Dec 2015 04:54:18 GMT

I am using base SAS 9.3

Re: Finding the default customers from the data

ballardw — Wed, 30 Dec 2015 19:24:45 GMT

If you have data that looks something like

Identification (could be multiple variables) Days

Then you could create a custom format for days of interest. Possibly something like

proc format;

value mydays

0 - 5 = '0 to 5 days'

6 - 10 = '5 to 10 days'

11-20 = '11 to 20 days'

21 - high= '21+ days'

;

then use that format in one of the report procedures such as:

proc tabulate data= have;

class Id;

class Days;

format days mydays.;

table id * days, pctn ;

run;