EViews.com

Posted: **Tue Sep 05, 2017 4:39 pm**

Hi Guys,

I want to get the first observation of a alpha series(alpha1) each time another two series's value changes (alpha2 and series3).
I know we have @fistsby for numeric series, is there any formula (or formula communication) that I could do something like:

alpha alpha1_new=@firstsby(alpha1, alpha2, series3)?

Please advise!

Best,
BC

Posted: **Wed Sep 06, 2017 9:44 am**

Hello,

I believe you'll have to use an explicit loop, e.g.:

Code: Select all


series tmp = @firstsby(@obsnum, alpha2, series3)
alpha alpha1_new
for !i = 1 to @obsrange
	alpha1_new(!i) = alpha1(tmp(!i))
next
delete tmp

Posted: **Thu Sep 14, 2017 5:46 pm**

Thank you Matt.
Hope there will be an @firstby() for alpha series soon.

Best,
BC

EViews.com

SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?

SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?

Re: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?

Re: SIMILAR FORMULA OF @FIRSTSBY() FOR ALPHA SERIES?