Thanks to everyone for the suggestions. Since this is SAS running on z/OS, I was not able to do most of the suggestions. The proc optex looked like to most promising but that procedures was not available on z/OS. I ended up just sorting them by size and assigning a group number from 1 to 5. Repeating that thru all the obs in descending size order. When I sorted them by number and then broke them out into 5 groups, they where roughly the same size. | | Size ALLOC | Size FREE | # OF Items | |------------+------------+------------ | Size CAP | Sum | Sum | Sum ----------------------------+------------+------------+------------+------------ Group1 | 2136.44| 1347.25| 789.18| 439.00 Group2 | 2117.11| 1321.39| 795.71| 439.00 Group3 | 2136.44| 1350.09| 786.35| 439.00 Group4 | 2161.44| 1372.98| 788.47| 439.00 Group5 | 2022.22| 1269.02| 753.20| 434.00 All | 10573.65| 6660.73| 3912.91| 2190.00 -------------------------------------------------------------------------------- Sometimes you just need some suggestions to get you unstuck from your direction and give you some ideas on where to go. Thanks for all the suggestions.
... View more