Description

Dear Prof Rutherford,

I am sorry to bother you again. If you recall I was having difficulty
with the ‘rank’ function. I wasn’t able to run it in loop and use the
95th percentile value as a constraint in the next run of the loop,
while also retaining a value of the 95th percentile for every
iteration of the loop. [model below].

In the loop $libInclude rank call I ask GAMS to place the ranked
values in pct, it only runs for 1 iteration before the ‘user error’ in
rank. Whereas if I ask gams to put the ranked values in pct2, it runs
for 2 iterations before saying ‘user error’.

This must mean that the rank function only allows pct to be
over-written once, after which it ‘fills up’ and generates a user
error? How can I over come this?

In your last email you though the problem was that the original values
are being over written. So I introduced xparam95(iter). I think rank
does not allow them to be overwritten.

I am only a novice and have been stuck on this for sometime, your help
will be invaluable.

Kind regards,
Ashar

Category : GAMS Data Utilities library

Main file : rank04.gms   includes :  rank04.gms

$title Repeated computation of percentiles within a loop (rank04,SEQ=138)

$onText
Dear Prof Rutherford,

I am sorry to bother you again. If you recall I was having difficulty
with the ‘rank’ function. I wasn’t able to run it in loop and use the
95th percentile value as a constraint in the next run of the loop,
while also retaining a value of the 95th percentile for every
iteration of the loop. [model below].

In the loop $libInclude rank call I ask GAMS to place the ranked
values in pct, it only runs for 1 iteration before the ‘user error’ in
rank. Whereas if I ask gams to put the ranked values in pct2, it runs
for 2 iterations before saying ‘user error’.

This must mean that the rank function only allows pct to be
over-written once, after which it ‘fills up’ and generates a user
error? How can I over come this?

In your last email you though the problem was that the original values
are being over written. So I introduced xparam95(iter). I think rank
does not allow them to be overwritten.

I am only a novice and have been stuck on this for sometime, your help
will be invaluable.

Kind regards,
Ashar
$offText

    
Set
   iter             'Iterations'                 / iter1*iter10   /
   week             'Weeks in the year'          / 1*52           /
   percentile       'Percentiles (all of them)'  / 1*100          /
   pctl(percentile) 'Percentiles to be computed' / 50, 75, 80, 95 /;

Parameter
   z(week)        'Values to be sorted'
   rnk(week)      'Rank values'
   pct(*)         'Percentiles to be computed (input) and those values (output)'
   pct0(*)        'Percentiles to be computed'
   pctval(iter,*) 'Percentile values in successive iterations';

* Generate a "permanent copy" of the percentiles to be computed.
* This will be used to initialize pct before each call to rank;
pct0(percentile)$pctl(percentile) = ord(percentile);

* Assume that a model solution delivers the values;
z(week) = uniform(0,1);

* Assign the percentile values to be computed here:
pct(pctl) = pct0(pctl);

display 'Here are the INPUT values of PCT0 and PCT prior to the call to rank:', pct0, pct;

$libInclude rank z week rnk pct

display 'Here are the values of PCT0 and PCT after the call to rank:', pct0,
        'Note that rank has changed the OUTPUT value of pct', pct;

* Do several iterations, computing percentiles in each step:

loop(iter,
*  Substitute a call to the NLP solver by a call to the random
*  number generator.  In many applications, this substitution
*  produces profoundly more sensible results.
*
*  solve catchment using nlp maximizing max;

   z(week) = uniform(0,1);

*  If you want to retrieve percentile values, you need to reassign
*  the percentiles that you wish to retrieve at this point in the
*  program.  If pct() were not reassigned at this point, the INPUT
*  values would correspond to the OUTPUTs from the previous call.

   pct(pctl) = pct0(pctl);

$  libInclude rank z week rnk pct

   pctval(iter,pctl) = pct(pctl);
);

display pctval;