NA DATA handling

[sportsguy]

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

[TomDoan]

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.