NA in "if" statement

[utah777]

I'm trying to assign +1 values to a 'trade' series when my 'res' (=residual) series is greater than standard deviation (=s) and -1 when my 'res' series less than negative standard deviation

if res>s then
series trade=1
else
if res<-s then
series trade=-1
endif
endif

but getting a message "NA found in matrix IF RES>S then"

Is there a way to avoid the NA message?

[tchaithonov]

use @recode instead.

[utah777]

@recode will work for the first time, but when I use it for the second, it will overwrite the first results.
Any other suggestions?

[EViews Gareth]

Code: Select all

series trade = @recode(res>s, 1, 0) series trade = @recode(res<-s,-1,trade)

[utah777]

Thank you for the help