finding and replacing problematic cells in a table

Hi,

Attached a data file that I am working on. I want to replace N/A cells with -999. I also want to find empty cells (they appear as "" and NaN values or <undefined> in the data file depending on the type of the column and replace them with -998. How can I identify these codes and replace them in a table? your help is greatly appreciated

Answer 1

[Cris LaPierre]

Look into the standardizemissing,fillmissing, ismissing,and rmmissing functions