I'm trying to import Excel files where users have used various missing value codes for numerical variables. Sometimes they use blank, sometimes ".", sometimes "N/A", etc. A small example: The excel file data may be like this: Var1 Var2 Var3 Var4 140 125 10 17 . . . . 143.04 126.72 13.029 32.817 N/A N/A N/A N/A 120 150.879 11 10 I want to import Var1-Var as numeric into a SAS data step, assigning a missing value to anything that is not a number. I could of course recode the Excel file, but there are too many users that code missing values in a different way; I want the import procedure to be foolproof.
... View more
