Combining 3 series with 3 different base years

[obviou191]

I have a single variable that is only available to download in 3 different time periods (2000-2016, 2010-2018 and 2015-present) using 3 different bases (2005, 2010 and 2015).

Is there any easy way to merge these seamlessly in EViews?

OB

[EViews Gareth]

Almost certainly yes.

[obviou191]

Thanks Gareth - any suggestions?

[EViews Gareth]

You’ll need to provide more details

[obviou191]

Thanks Gareth. Attached are the 3 series. retail 1 base 2005=100, retail 2 base 2010=100, retail 3 base 2015=100.

Thanks,
OB

[EViews Gareth]

And what are you trying to do with those 3 series?

[startz]

And what are you trying to do with those 3 series?

Especially RETAIL1, which is all NA.

[obviou191]

Apologies - see attached updated. What I am basically trying to figure out is a way to automate a process that I can combine the three and have 2015 as base year. I know its not a complicated process but I have over 100 series with similar and am looking for a quick way to do this for multiple series.

Thanks for your help!

[startz]

Something like

Code: Select all

smpl 2000 2009
series retail = retail1*(130/100)
smpl 2010 2014
retail = retail2*(103/100)
smpl 2015 @last
retail = retail3
smpl @all

where the factors in parentheses are whatever adjustment you want to make to put the series on a common base year.

[obviou191]

This is brilliant - thanks so much for this! Greatly appreciated

OB