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