Page 1 of 1
End dates?
Posted: Thu Mar 16, 2017 1:06 pm
by timduy
Is there a command that returns the end date of a series - by which I mean the date at which the data of a series ends? I think there must be but I am not seeing it.
Re: End dates?
Posted: Thu Mar 16, 2017 1:38 pm
by TomDoan
You want
INQUIRE. For instance
INQUIRE(SERIES=MYSERIES) mystart myend
will give you MYEND as the last non-NA entry.
Re: End dates?
Posted: Thu Mar 16, 2017 1:53 pm
by timduy
Thank you. My prior workaround:
LINREG(NOPRINT) HOUST1F * *
#CONSTANT
DISPLAY(STORE=LASTVALUE) %datelabel(%REGEND()) " values:" $
"\\" $
"\\1 unit =" ###.# HOUST1F(%REGEND()) $
"\\2-4 units =" ###.# HOUST2F(%REGEND()) $
"\\5 or more units =" ###.# HOUST5F(%REGEND())