topic Re: convert character variable to numeric in SAS Programming

convert character variable to numeric

kumarnaidu — Fri, 27 Apr 2012 10:11:18 GMT

Hi all if a variable is of character type and having numeric values then how to convert it to numeric.

Patrick — Fri, 27 Apr 2012 10:32:23 GMT

Use the input() function with an appropriate informat, eg. Numvar=input(charvar,20.);

Linlin — Fri, 27 Apr 2012 10:33:15 GMT

data have;

input a$ @@;

cards;

1 2 3

;

data want;

set have;

b=input(a,best12.);

run;

proc contents data=want;run;

kumarnaidu — Fri, 27 Apr 2012 10:43:24 GMT

thanks patrick