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
Combining 3 series with 3 different base years
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13318
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Combining 3 series with 3 different base years
Almost certainly yes.
Follow us on Twitter @IHSEViews
Re: Combining 3 series with 3 different base years
Thanks Gareth - any suggestions?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13318
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Combining 3 series with 3 different base years
You’ll need to provide more details
Follow us on Twitter @IHSEViews
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
Thanks,
OB
- Attachments
-
- retail.wf1
- (17.97 KiB) Downloaded 271 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13318
- 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?
Follow us on Twitter @IHSEViews
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- 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.
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.
Thanks for your help!
Thanks for your help!
- Attachments
-
- retail updated.WF1
- (17.98 KiB) Downloaded 283 times
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: Combining 3 series with 3 different base years
Something like
where the factors in parentheses are whatever adjustment you want to make to put the series on a common base year.
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.
Re: Combining 3 series with 3 different base years
This is brilliant - thanks so much for this! Greatly appreciated
OB
OB
Who is online
Users browsing this forum: No registered users and 8 guests