BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mona4u
Lapis Lazuli | Level 10

I want to assign on people to work on the stores based on the stores revenue. The revenue will be equaly or almost equally distributed between 3 managers. 

 

Partner Name Area Revenue
Store 1  $                                         268,144.38
Store 2  $                                         257,660.73
Store 3  $                                         250,675.20
Store 4  $                                         174,474.83
Store 5  $                                         168,140.60
Store 6  $                                         145,631.76
Store 7  $                                         138,761.64
Store 8  $                                         135,393.91
Store 9  $                                         114,173.34
Store 10  $                                         109,770.67
Store 11  $                                         106,283.21
Store 12  $                                           40,844.72
Store 13  $                                           37,127.90
Store 14  $                                           22,112.36
Store 15  $                                           16,358.29
Store 16  $                                             7,984.21
sum  $                                     1,993,537.75
sum/3  $                                         664,512.58

 

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

If I understand, you want to assign each store to one of three manager in such a way that they manage about the same revenue. A decent heuristic to do this is to assign each store to the manager with the least revenue, in decreasing order of revenue. For example:

 

data have;
input store $ revenue;
datalines;
Store1     268144.38
Store2     257660.73
Store3     250675.20
Store4     174474.83
Store5     168140.60
Store6     145631.76
Store7     138761.64
Store8     135393.91
Store9     114173.34
Store10        109770.67
Store11        106283.21
Store12          40844.72
Store13          37127.90
Store14          22112.36
Store15          16358.29
Store16            7984.21
;

proc sort data=have; by descending revenue; run;

data want;
array m manager1-manager3 (3*0);
set have;
manager = whichn(min(of m{*}), of m{*});
m{manager} = m{manager} + revenue;
*keep store manager;
run;

proc print data=want noobs; run;

PGStats_0-1647372045962.png

 

PG

View solution in original post

2 REPLIES 2
PaigeMiller
Diamond | Level 26

I'm not sure what the question is, and I'm not sure which part you are having trouble with in SAS?

--
Paige Miller
PGStats
Opal | Level 21

If I understand, you want to assign each store to one of three manager in such a way that they manage about the same revenue. A decent heuristic to do this is to assign each store to the manager with the least revenue, in decreasing order of revenue. For example:

 

data have;
input store $ revenue;
datalines;
Store1     268144.38
Store2     257660.73
Store3     250675.20
Store4     174474.83
Store5     168140.60
Store6     145631.76
Store7     138761.64
Store8     135393.91
Store9     114173.34
Store10        109770.67
Store11        106283.21
Store12          40844.72
Store13          37127.90
Store14          22112.36
Store15          16358.29
Store16            7984.21
;

proc sort data=have; by descending revenue; run;

data want;
array m manager1-manager3 (3*0);
set have;
manager = whichn(min(of m{*}), of m{*});
m{manager} = m{manager} + revenue;
*keep store manager;
run;

proc print data=want noobs; run;

PGStats_0-1647372045962.png

 

PG

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 284 views
  • 1 like
  • 3 in conversation