The RATS Software Forum

Posted: **Tue Dec 29, 2009 1:01 pm**

How do I identify an NA in a data series, such that %IF(Symbol == NA, new value, existing value)
primary use is to assign data to holiday dates without programming the data prior to importing into rats

thanks

sportsguy

Posted: **Tue Dec 29, 2009 2:05 pm**

How do I identify an NA in a data series, such that %IF(Symbol == NA, new value, existing value)
primary use is to assign data to holiday dates without programming the data prior to importing into rats

thanks

sportsguy

Use %VALID(Symbol) to test whether a value is NA or not. (It returns 1 if it's not missing). So something like

Code: Select all

SET PATCH = %IF(%VALID(SYMBOL),existing value,new value)

would be what you want.

The RATS Software Forum

NA DATA handling

NA DATA handling

Re: NA DATA handling