sbokka Tracker
https://communities.sas.com/kntur85557/tracker
sbokka TrackerSun, 19 May 2024 08:52:43 GMT2024-05-19T08:52:43ZRe: How to find an Optimal(max) count in each Bin
https://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318593#M1593
<P>can we print all three bins with count instead of just the max bin</P>Tue, 13 Dec 2016 15:34:45 GMThttps://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318593#M1593sbokka2016-12-13T15:34:45ZRe: How to find an Optimal(max) count in each Bin
https://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318362#M1582
<P>yes i am trying to maximize the maximum percentage. sorry about the confusion</P>Mon, 12 Dec 2016 19:51:49 GMThttps://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318362#M1582sbokka2016-12-12T19:51:49ZRe: How to find an Optimal(max) count in each Bin
https://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318360#M1580
<P>i couldnt test them, since RobPratt used Proc optmodel and i do not have SAS/OR package and Ksharp used GA and somehow its giving me IML error and asking me to contact SAS support(this might be due to Version 9.3).</P><P> </P><P>And also RobPratt Suggest me to use MILPSOLVE, so i am trying to use it. no luck yet.</P><P> </P><P>What i am really looking is, trying to find a fee bucket range which has the highest frequency. so that i can assing the fee range to the client. in the example iteration 2 has bucket 330-450 with 60% .</P>Mon, 12 Dec 2016 19:38:50 GMThttps://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318360#M1580sbokka2016-12-12T19:38:50ZRe: How to find an Optimal(max) count in each Bin
https://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318277#M1577
<P>thanks for the response.</P>Mon, 12 Dec 2016 14:18:57 GMThttps://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318277#M1577sbokka2016-12-12T14:18:57ZRe: How to find an Optimal(max) count in each Bin
https://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318276#M1576
<P>thanks for such a quick response.</P>Mon, 12 Dec 2016 14:17:14 GMThttps://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318276#M1576sbokka2016-12-12T14:17:14ZHow to find an Optimal(max) count in each Bin
https://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318190#M1573
<P>I am trying to find Maximun count for each bin range, but bin range can move depending on data. Trying to find three bins and minumum three count in each bin. For example, for this sample</P><P> </P><TABLE cellspacing="0" cellpadding="0" border="0"><TBODY><TR><TD>ID</TD><TD>fee</TD></TR><TR><TD>2</TD><TD>330</TD></TR><TR><TD>4</TD><TD>330</TD></TR><TR><TD>15</TD><TD>330</TD></TR><TR><TD>17</TD><TD>330</TD></TR><TR><TD>1</TD><TD>350</TD></TR><TR><TD>5</TD><TD>350</TD></TR><TR><TD>18</TD><TD>370</TD></TR><TR><TD>8</TD><TD>390</TD></TR><TR><TD>12</TD><TD>390</TD></TR><TR><TD>19</TD><TD>390</TD></TR><TR><TD>20</TD><TD>430</TD></TR><TR><TD>3</TD><TD>450</TD></TR><TR><TD>13</TD><TD>480</TD></TR><TR><TD>7</TD><TD>500</TD></TR><TR><TD>6</TD><TD>530</TD></TR><TR><TD>10</TD><TD>530</TD></TR><TR><TD>11</TD><TD>530</TD></TR><TR><TD>9</TD><TD>540</TD></TR><TR><TD>14</TD><TD>550</TD></TR><TR><TD>16</TD><TD><P>550</P><P> </P></TD></TR></TBODY></TABLE><P> </P><P> </P><P>these are three different iterations and i want the best optimal solution, something like iteration 2.</P><P> </P><TABLE><TBODY><TR><TD> </TD><TD> </TD><TD>Bins</TD><TD>count</TD><TD>%</TD></TR><TR><TD>Iteration 1</TD><TD>1</TD><TD>330-390</TD><TD>10</TD><TD>50.00%</TD></TR><TR><TD> </TD><TD>2</TD><TD>391-530</TD><TD>7</TD><TD>35.00%</TD></TR><TR><TD> </TD><TD>3</TD><TD>531-550</TD><TD>3</TD><TD>15.00%</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Iteration 2</TD><TD> </TD><TD>Bins</TD><TD>count</TD><TD>%</TD></TR><TR><TD> </TD><TD>1</TD><TD>330-450</TD><TD>12</TD><TD>60.00%</TD></TR><TR><TD> </TD><TD>2</TD><TD>451-530</TD><TD>5</TD><TD>25.00%</TD></TR><TR><TD> </TD><TD>3</TD><TD>531-550</TD><TD>3</TD><TD>15.00%</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Iteration 3</TD><TD> </TD><TD>Bins</TD><TD>count</TD><TD>%</TD></TR><TR><TD> </TD><TD>1</TD><TD>330-350</TD><TD>6</TD><TD>30.00%</TD></TR><TR><TD> </TD><TD>2</TD><TD>351-530</TD><TD>11</TD><TD>55.00%</TD></TR><TR><TD> </TD><TD>3</TD><TD>531-550</TD><TD>3</TD><TD>15.00%</TD></TR></TBODY></TABLE><P> </P><P>Can we do this in auto process? if so what would be the best approach.</P><P> </P><P> </P>Mon, 12 Dec 2016 03:52:26 GMThttps://communities.sas.com/t5/Mathematical-Optimization/How-to-find-an-Optimal-max-count-in-each-Bin/m-p/318190#M1573sbokka2016-12-12T03:52:26Z