06-12-2013 08:43 AM
What are some to convert numeric values stored in a field that is defined as character to a field defined as numeric.
06-12-2013 09:54 AM
INPUT() function. Choose an appropriate informat.
data want ;
numvar = input(charvar,10.);
06-12-2013 09:55 AM
You can't convert the field to numeric.
You can create a new numeric variable that has the same value as the character variable (except that it is translate to a number)
06-12-2013 10:55 AM
Not really the best but you'll find it in some folks code is to do arithmetic with it.
numvar = 0 + charactervariable;
This will generate warning messages about conversion of strings to numeric.
06-12-2013 12:37 PM
Very similar ...
If you have already defined a new variable as numeric, just copy:
length numvar 8;
numvar = charactervariable;
If the character variable takes on unusual values that can't be converted to numeric, you will receive a warning.