Combining 3 series with 3 different base years

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

obviou191
Posts: 10
Joined: Thu Dec 08, 2011 5:17 am

Combining 3 series with 3 different base years

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
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12540
Joined: Tue Sep 16, 2008 5:38 pm

Re: Combining 3 series with 3 different base years

Almost certainly yes.

obviou191
Posts: 10
Joined: Thu Dec 08, 2011 5:17 am

Re: Combining 3 series with 3 different base years

Thanks Gareth - any suggestions?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12540
Joined: Tue Sep 16, 2008 5:38 pm

Re: Combining 3 series with 3 different base years

You’ll need to provide more details

obviou191
Posts: 10
Joined: Thu Dec 08, 2011 5:17 am

Re: Combining 3 series with 3 different base years

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

Thanks,
OB
Attachments
retail.wf1

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12540
Joined: Tue Sep 16, 2008 5:38 pm

Re: Combining 3 series with 3 different base years

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

startz
Non-normality and collinearity are NOT problems!
Posts: 3573
Joined: Wed Sep 17, 2008 2:25 pm

Re: Combining 3 series with 3 different base years

EViews Gareth wrote:And what are you trying to do with those 3 series?

Especially RETAIL1, which is all NA.

obviou191
Posts: 10
Joined: Thu Dec 08, 2011 5:17 am

Re: Combining 3 series with 3 different base years

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.

Attachments
retail updated.WF1

startz
Non-normality and collinearity are NOT problems!
Posts: 3573
Joined: Wed Sep 17, 2008 2:25 pm

Re: Combining 3 series with 3 different base years

Something like

Code: Select all

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

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

obviou191
Posts: 10
Joined: Thu Dec 08, 2011 5:17 am

Re: Combining 3 series with 3 different base years

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

OB