06-11-2015 10:01 PM
Hi SAS pro,
I have a problem here about how I could distributed acct's fairly to each team member(people). The condition is I have as exam 3 team members(A,B, C) and each person has got following numbers account in existing : A - 10 acct's, B - 15 acct's, C - 16 acct's. and I have new 10 account's that should distributed to them but the rule is at the ending total account's that they got is same/almost same, then if do manually new 10 acct's will distribute to A: 7 +(10 existing)=17 acct's, B: 2 +(15 existing)= 17acct's, C: 1 +(16 existing)=17 act's. then we could see that each team member will have 17 acct's. as notes number of team member are fix but not with the next new account will distributed
06-12-2015 11:59 AM
You may need to describe the modules of SAS you have available. This looks like it could fall into an optimization routine which typically are part of SAS/OR or SAS/IML.
06-15-2015 11:03 AM
thanks ballardw for your reply, but I only have SAS base is that possible there's module available there? or I should create it but do you have any idea how to create it?
06-15-2015 12:41 PM
Generic approach: Determine total number of currently assigned customers
Determine total number of customer service reps or what ever you call them
Determine the average number of clients that should be assigned: (new_clients + current_clients)/number of service reps
Subtract the number of current clients per rep from that (rounded) average to get number of new ones.
You'll need a rule for who gets any fraction client left over.
With out a description of how your current data is structured and what you want the final output to look at that's about all I can say at this time as your data structures can make a big difference in how to get the counts mentioned above and how to distribute the new clients.