Format to convert char comma values into numeric

[David_Billa]

I've a data as follows and I want to convert the field 'value' numeric, I tried with best32. format with input function but I didn't get the values as needed. Any help?

Value (char)

0,3

2,3

0,5

4,2

Required output is,

Value (num)

0.3

2.3

0.5

4.2

[Patrick · Accepted solution]

You need an INformat for reading a text string into a numerical variable.

data demo;
  var_char='0,3';
  var_num=input(var_char,commax32.);
  format var_num best32.;
run;

proc print data=demo;
run;