Page 1 of 1

Creating string of date of last observation minus 1

Posted: Mon Jun 03, 2019 11:10 am
by zsaijid
Hello,

What is the easiest way to return date of last observation minus 1. (i.e. if my data series goes through 2019m4, i want 2019m3)

Thanks

Re: Creating string of date of last observation minus 1

Posted: Mon Jun 03, 2019 11:28 am
by EViews Gareth
Penultimate observation of workfile, or penultimate non-NA value of a particular series, or last non-NA value of a particular series minus one observation?

Re: Creating string of date of last observation minus 1

Posted: Mon Jun 03, 2019 11:57 am
by zsaijid
The penultimate observation of a data series, but the date value. So if {%x}.@last gives you last date of that series and I want the prenultimate date.

Re: Creating string of date of last observation minus 1

Posted: Mon Jun 03, 2019 11:58 am
by zsaijid
Doesn't matter if the prenultimate value is NA

Re: Creating string of date of last observation minus 1

Posted: Mon Jun 03, 2019 12:57 pm
by EViews Gareth

Code: Select all

@otod(@ilast(x)-1)

where X is the series.