Delete element from series
Posted: Tue Feb 15, 2011 8:53 am
Hello there. Thanks again for the help.
I wanted to ask how can I delete a particular element from a series if that element is a "NA".
It happens that I need to structure the workfile with a date series I am importing from excel and before that I need to drop all the "NAs" from the date series.
I was trying domething like this:
for !i=21 to @rows(Date)
if Date(!i)=NA then
Delete Date(!i)
endif
next
But it doesn´t work.
Can anyone tell me how can I do this?
Thanks!
I wanted to ask how can I delete a particular element from a series if that element is a "NA".
It happens that I need to structure the workfile with a date series I am importing from excel and before that I need to drop all the "NAs" from the date series.
I was trying domething like this:
for !i=21 to @rows(Date)
if Date(!i)=NA then
Delete Date(!i)
endif
next
But it doesn´t work.
Can anyone tell me how can I do this?
Thanks!