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
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;
I am using base SAS 9.3
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.