EViews.com

Posted: **Wed Jul 29, 2020 2:23 pm**

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

Posted: **Wed Jul 29, 2020 3:20 pm**

Almost certainly yes.

Posted: **Thu Jul 30, 2020 12:07 am**

Thanks Gareth - any suggestions?

Posted: **Thu Jul 30, 2020 7:31 am**

You’ll need to provide more details

Posted: **Fri Jul 31, 2020 10:39 am**

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

Thanks,
OB

Posted: **Fri Jul 31, 2020 3:32 pm**

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

Posted: **Fri Jul 31, 2020 5:02 pm**

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

Especially RETAIL1, which is all NA.

Posted: **Fri Jul 31, 2020 11:46 pm**

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!

Posted: **Sat Aug 01, 2020 7:41 am**

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.

Posted: **Sun Aug 02, 2020 1:49 am**

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

OB

EViews.com

Combining 3 series with 3 different base years

Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years

Re: Combining 3 series with 3 different base years