Finding the default customers from the data

Solved
Frequent Contributor
Posts: 92

Finding the default customers from the data

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

Accepted Solutions
Solution
‎01-04-2016 04:35 AM
Super User
Posts: 13,507

Re: Finding the default customers from the data

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;

All Replies
Super User
Posts: 23,677

Re: Finding the default customers from the data

Why can't you filter? Are you using SAS BASE or SAS VA?
Frequent Contributor
Posts: 92

Re: Finding the default customers from the data

I am using base SAS 9.3

Super User
Posts: 23,677

Re: Finding the default customers from the data

For default analysis, or Churn, you can look at survival methods as well.
Solution
‎01-04-2016 04:35 AM
Super User
Posts: 13,507

Re: Finding the default customers from the data

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;

🔒 This topic is solved and locked.