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

Postby obviou191 » 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

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

Postby EViews Gareth » Wed Jul 29, 2020 3:20 pm

Almost certainly yes.
Follow us on Twitter @IHSEViews

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

Re: Combining 3 series with 3 different base years

Postby obviou191 » Thu Jul 30, 2020 12:07 am

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

Postby EViews Gareth » Thu Jul 30, 2020 7:31 am

You’ll need to provide more details
Follow us on Twitter @IHSEViews

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

Re: Combining 3 series with 3 different base years

Postby obviou191 » 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
Attachments
retail.wf1
(17.97 KiB) Downloaded 5 times

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

Postby EViews Gareth » Fri Jul 31, 2020 3:32 pm

And what are you trying to do with those 3 series?
Follow us on Twitter @IHSEViews

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

Postby startz » Fri Jul 31, 2020 5:02 pm

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

Postby obviou191 » 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!
Attachments
retail updated.WF1
(17.98 KiB) Downloaded 3 times

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

Postby startz » 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.

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

Re: Combining 3 series with 3 different base years

Postby obviou191 » Sun Aug 02, 2020 1:49 am

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

OB


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 8 guests