Get the date of the last non empty cell in a serie

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

melamel
Posts: 30
Joined: Tue May 10, 2016 3:49 am

Get the date of the last non empty cell in a serie

Postby melamel » Sat May 14, 2016 9:26 am

Hello everyone,

I have a dated serie and I want to instruct eviews to give me the date of the last non empty cell in that serie, is there a way to do it?

Thank you for your responses.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Get the date of the last non empty cell in a serie

Postby EViews Gareth » Sat May 14, 2016 9:30 am

Series.@last

melamel
Posts: 30
Joined: Tue May 10, 2016 3:49 am

Re: Get the date of the last non empty cell in a serie

Postby melamel » Sun May 15, 2016 1:52 am

Thank you for your response, but I want to put that date in a replacement variable, so that I can use it in the if condition, what's the syntax to do it please ?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Get the date of the last non empty cell in a serie

Postby EViews Gareth » Sun May 15, 2016 2:25 am

Code: Select all

%myvar = myseries.@last

melamel
Posts: 30
Joined: Tue May 10, 2016 3:49 am

Re: Get the date of the last non empty cell in a serie

Postby melamel » Wed May 18, 2016 1:29 am

Thank you !


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 1 guest