The TRANSLATE-INTO statement translates missing values (.) into the string
No data
.
translate _val_=. into 'No data';