Show the code you tried.
Show the result you want.
Take the time to convert the data into code that create a dataset so those that want to help don't have to type in your numbers.
Notice it is not actually any more work than you already did to post the listing of the data.
data have;
input Customer_num Current_bads Total_bads;
cards;
19 19 41
10 10 31
25 25 6
20 6 0
30 0 0
15 0 0
;
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.