REBASE

<< Click to Display Table of Contents >>

Navigation:  Gekko commands >

REBASE

Previous pageReturn to chapter overviewNext page

REBASE calculates an index series by dividing every observation of an existing series by a single observation or an average of several observations of the same timeseries. A bank name and/or prefix can be indicated, and the index value can be stated (default: 100).

 

 


 

Syntax

 

REBASE < BANK=...  PREFIX=...  INDEX=... > variables   date1   date2 ;

 

variables

A list of variable names (may include bank names)

date1

 

Starting date for the observations.

date2

 

(Optional). Ending date for the observations. If not indicated, date1 is used as ending date.

BANK

(Optional). A databank name indicating where the timeseries are located.

PREFIX

(Optional). A prefix name for the resulting timeseries.

INDEX

(Optional). The value of the index in the index period(s). Default = 100.

 

If a databank name is not provided, the variable is not searched for in other databanks than the first-position databank.

 

Note: If the timeseries is quarterly or monthly, date1 is annual (a year), and date2 is not stated, Gekko will use the first period of the year as start date, and the last period of the year as end date. If the timeseries y is quarterly, REBASE y 2010; is the same as REBASE y 2010q1 2010q4;.

 

 


 

Example

 

RESET;
MODE data;
TIME 2010 2012;
= 2, 3, 4;
REBASE <prefix=i1> y 2011;
PRT <n> y, i1y;
REBASE <prefix=i2> y 2011 2012;
PRT <n> y, i2y;

 

The result is the following:

 

Rebased 1 variables
 
                    y            i1y 
  2010         2.0000        66.6667 
  2011         3.0000       100.0000 
  2012         4.0000       133.3333 
 
Rebased 1 variables
 
                    y            i2y 
  2010         2.0000        57.1429 
  2011         3.0000        85.7143 
  2012         4.0000       114.2857

 

In the first one (i1y), the index series has the value 100 in 2011. In the second one (i2y), the index series has an average of 100 in 2011 and 2012 (the average of 85.7143 and 114.2857 = 100).

 

 


 

Related commands

 

SERIES, SPLICE