topic Re: Convert character varaible to numeric in SAS Programming

Convert character varaible to numeric

yonib — Fri, 05 Mar 2010 07:43:38 GMT

Hi,
Let say I have:

data test;
w="8,5";
run;

I want to convert the variable w to numeric but to numeric with period and not with comma .
the result should be 8.5.
I wanted to do it only with input function (not to use scan/translate function before).
Is there a way to do it (a appropriate format)?

Thanks in advance

Re: Convert character varaible to numeric

Cynthia_sas — Fri, 05 Mar 2010 08:22:51 GMT

Hi:
Check out the COMMAX informat for use with the INPUT function:
http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a000204406.htm

cynthia

Re: Convert character varaible to numeric

yonib — Fri, 05 Mar 2010 20:07:30 GMT

Hi Cynthia,
Thanks alot!