End dates?

[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.

[TomDoan]

You want INQUIRE. For instance

INQUIRE(SERIES=MYSERIES) mystart myend

will give you MYEND as the last non-NA entry.

[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())