Character to numeric

[SASPhile]

How to convert the values to numeric,at times there will be a comma sometimes there will not be a comma.
29,652 units
60mg

[Peter_C]

informat COMMAw. will deal with embedded commas correctly, but you might have a problem with "mg" tight against the numbers.

PeterC

[Flip]

z = input( prxchange('s/[A-Z a-z]/ /',-1, x), comma6.);

[SASPhile]

Thanks Flip.

[SASPhile]

Thanks Peter

[SASPhile]

Thanks Flip.

[marieK]

Hi,

I have the same problem. I want to convert a character-Variable into a numeric. But the tip above doesnt work correctly in my case.

My data is like (character-format):

0,8
1,2
12,3
10
1,2
.
.
.
after converting i want my data like (numeric-format):
0.8
1.2
12.3
10
1.2
.
.
.
if i do like above i get:
8
12
123
10
12
.
.
.

Any idea?

Thank you in advance. Marie Message was edited by: marieK

[Patrick]

Use informat commaX.

data have;
input varHave $;
datalines;
0,8
1,2
12,3
10
1,2
;

data want;
set have;
varWant=input(varHave,commax8.);
put varWant=;
run;

[marieK]

Juhuuu 🙂 thanks!

[Ksharp]

Hi.
For the first question, you can use function translate() to convert ',' into '.',then use input() to get the numeric value.
[pre]
data _null_;
infile datalines;
input char $;
num= translate(char,'.',',');
put num=;
datalines;
0,8
1,2
12,3
10
1,2
;
run;
[/pre]
Note: num is also characteric value.

For the second question,you can use compress() to get rid of comma.then can achieve the numeric value.
[pre]
data _null_;
infile datalines;
input char $;
num= compress(char,',');
put num=;
datalines;
0,8
1,2
12,3
10
1,2
;
run;
[/pre]
Note: num is also characteric value.


Ksharp

[marieK]

Thank you! The translate-function is good 🙂