value of last observation

[miorinnovo]

I know this is simple but I can't find the answer in the manual. Whats the command that will give me the value of the last observation in a series?

[EViews Gareth]

Series.@last

[miorinnovo]

I tried that but it gives me the date of the last observation, not the value.

[EViews Gareth]

@last(seriesname)

[miorinnovo]

It says cannot assign numeric expression to string variable. The observations are dates, maybe that's the problem.

[EViews Gareth]

Sounds like you're trying to assign the value into a string, not a number.

[miorinnovo]

My series is a list of observations and I'm trying to figure a way to use the first/last in the list to change the sample range, any idea on how to do that?

[EViews Gareth]

Grab the date as a number, the use @datestr to convert to a string that smpl will understand

[miorinnovo]

Do you mean something like

smpl 2000 @datestr(@last(seriesname))?

That gives me an error saying its an illegal date.

[EViews Gareth]

Code: Select all

%date = @datestr(@last(seriesname)) smpl 2000 {%date}

[miorinnovo]

Thanks Gareth