Page 1 of 1
First not NA value of series
Posted: Sat Apr 26, 2014 4:59 am
by Julia336699
Hello,
how can I get the first not NA value of a series. I want to use this value (series 1) as the starting point of a new series (series 3) and add another one to it (series 2).
1 2 3
NA NA NA
NA NA NA
NA NA NA
100 0 100
102 3 103
103 4 104
Thank you very much for helping.
Re: First not NA value of series
Posted: Sat Apr 26, 2014 5:15 am
by EViews Gareth
@first(series1)
Re: First not NA value of series
Posted: Sun Apr 27, 2014 2:32 am
by Julia336699
Thanks for replying. However, it does not work.
I want to calculate: series a= @first(b)+c.
Re: First not NA value of series
Posted: Sun Apr 27, 2014 7:51 am
by startz
Works for me.
Exactly what commands did you use and what went wrong?
Re: First not NA value of series
Posted: Mon Apr 28, 2014 11:31 am
by Julia336699
I used the equation series a = @first(p10) + cr_10 and then an error message come and writes @FIRST is not a Genr or series expression function?!
Thank you very much for your help.
Re: First not NA value of series
Posted: Mon Apr 28, 2014 11:36 am
by EViews Gareth
Re: First not NA value of series
Posted: Tue Apr 29, 2014 7:12 am
by Julia336699
I use EViews 6.
Re: First not NA value of series
Posted: Tue Apr 29, 2014 7:55 am
by EViews Gareth
That function isn't included in EViews 6. There is no equivalent.
Re: First not NA value of series
Posted: Tue Apr 29, 2014 10:46 am
by Julia336699
Ok. Thanks.