topic What are some to convert numeric values stored in a field that is defined as character to a field defined as numeric. in SAS Programming

What are some to convert numeric values stored in a field that is defined as character to a field defined as numeric.

JIM1949 — Wed, 12 Jun 2013 12:43:55 GMT

What are some to convert numeric values stored in a field that is defined as character to a field defined as numeric.

Tom — Wed, 12 Jun 2013 13:54:58 GMT

INPUT() function. Choose an appropriate informat.

data want ;

set have;

numvar = input(charvar,10.);

run;

PaigeMiller — Wed, 12 Jun 2013 13:55:23 GMT

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)

numericvar=charactervar+0;

ballardw — Wed, 12 Jun 2013 14:55:35 GMT

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.

Astounding — Wed, 12 Jun 2013 16:37:23 GMT

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.