How to link a series and a formula through frml

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

lbenci
Posts: 9
Joined: Fri Mar 23, 2018 8:17 am

How to link a series and a formula through frml

Postby lbenci » Mon Oct 28, 2019 11:06 am

Hi, I want to build a series linking two series, one back in time (which is fixed) and the second one, which is take from an external database and is continuously updated (and the same operation for 69 more series).
if I run the following code, I end up only with the second part of the series


***************************************
copy(link) external_DB::xxxxx pr_2015_1 ' Copy the series from external DB

smpl 2015m1 2015m12
scalar m1 = @mean(pr_2015_1) ' This to compute the scaling factor (the scalar should not change over time)

smpl 2011m1 2015m12
series pr_tot_1 = (1/m1)*pr_2010_1 ' pr_2010_1 is the old series

smpl 2016m2 @now
frml pr_tot_1 = pr_2015_1
*******************************************

any suggestions?
thx

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

Re: How to link a series and a formula through frml

Postby EViews Gareth » Mon Oct 28, 2019 11:21 am

Not sure I follow the question exactly, but you might find @recode useful in the frml.
Follow us on Twitter @IHSEViews


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 6 guests