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
Creating string of date of last observation minus 1
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Creating string of date of last observation minus 1
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?
Follow us on Twitter @IHSEViews
Re: Creating string of date of last observation minus 1
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
Doesn't matter if the prenultimate value is NA
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Creating string of date of last observation minus 1
Code: Select all
@otod(@ilast(x)-1)
where X is the series.
Follow us on Twitter @IHSEViews
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 32 guests