<< Click to Display Table of Contents >> INTERPOLATE 

INTERPOLATE transforms one lowerfrequency timeseries to a higherfrequency timeseries, for instance converting annual data to quarterly data. Use COLLAPSE to perform the inverse transformation. INTERPOLATE does not yet support daily frequency.
INTERPOLATE vars1 = vars2 method;
vars1 
Higher frequency timeseries. Frequency can be indicated with suffix !a, !q or !m. Banknames may be used. Lists can be use like for instance {#m}. 
vars2 
Lowerfrequencey timeseries. Frequency can be indicated with suffix !a, !q or !m. Banknames may be used. Lists can be use like for instance {#m} 
method 
(Optional). Choose between:
•repeat: Repeats the lowerfreq observation (rep may be used as synonym) •prorate: Also repeats, but divides the result so that the sum of the higherfreq observations corresponds to the lowerfreq observation.
Note: default is repeat. More methods may be added by popular demand. 
•If a variable without databank indication is not found in the firstposition databank, Gekko will look for it in other open databanks if databank search is active (cf. MODE).
Use this to convert frequency:
INTERPOLATE x!q = x!a; 
Since the method is repeat as default, this will create the quarterly timeseries x where each quarterly observation in x!q is the same as the corresponding annual observation in x!a.
INTERPOLATE qbank:x!q = abank:x!a prorate; 
With option prorate, the quarters will sum up to x!a instead of just being repeated.
If a frequency indicator is omitted, Gekko will use the current frequency.
More to come by popular demand, for instance using patterns, splines, etc., to create the highfrequency series.
Related commands