Page 1 of 1

Dates and Retrieving Elements

Posted: Sun May 17, 2015 9:51 pm
by at182
Hi,

Complete rookie eViews user. I've managed to link a quarterly timeseries to an excel file but having problems referring to elements within the time series other than @last or @first?

I'm running the following code on the data attached.

The data is indexed as follows

WAGES_TR
.
.
2014Q2 - 118.7
2014Q3 - 119.4
2014Q4 - 120.1

Code: Select all

wages_tr.smooth(n) wages_trsm show wages_sa.@last show (@elem(wages_trsm,"2015Q1")/@elem(wages_sa,"2014Q4")-1)*100
My question is instead of using 2015Q1, can I use something as follows:

Code: Select all

@elem(wages_trsm,@obs(date)-1)

Re: Dates and Retrieving Elements

Posted: Mon May 18, 2015 7:58 am
by EViews Gareth
Use the @otod function to convert the observation number you're interested in into a date, then use the date inside @elem.