topic Re: Format to convert char comma values into numeric in SAS Programming

Format to convert char comma values into numeric

David_Billa — Sat, 13 Jun 2020 07:52:22 GMT

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

Re: Format to convert char comma values into numeric

Patrick — Sat, 13 Jun 2020 08:01:45 GMT

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;