When you convert a character to numeric, you can specify the informat to use when doing the conversion (how SAS will read in the character data). Any invalid numeric data will result in missing values.

An alternative is to do the conversion in your edit check program.


From: Debbie King
To: Support
Subject: Character to Numeric Conversion

If you have a production study with data in the database, can you change a field from character to numeric in the data structure? If so, what will happen if the current value is recorded with a decimal, like 24.0?

I know I can do this on export but the edits run on the live database.