topic Re: Character to numeric in SAS Programming

Character to numeric

SASPhile — Tue, 08 Dec 2009 17:15:13 GMT

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

Re: Character to numeric

Peter_C — Tue, 08 Dec 2009 18:24:34 GMT

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

PeterC

Re: Character to numeric

Flip — Tue, 08 Dec 2009 19:02:59 GMT

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

Re: Character to numeric

SASPhile — Tue, 08 Dec 2009 19:46:20 GMT

Thanks Peter

Re: Character to numeric

SASPhile — Tue, 08 Dec 2009 19:46:34 GMT

Thanks Flip.

Re: Character to numeric

SASPhile — Tue, 08 Dec 2009 19:46:47 GMT

Thanks Flip.

Re: Character to numeric

marieK — Wed, 07 Jul 2010 08:27:53 GMT

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

Re: Character to numeric

Patrick — Wed, 07 Jul 2010 10:53:33 GMT

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;

Re: Character to numeric

marieK — Wed, 07 Jul 2010 11:31:52 GMT

Juhuuu 🙂 thanks!

Re: Character to numeric

Ksharp — Wed, 07 Jul 2010 12:47:06 GMT

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

Re: Character to numeric

marieK — Thu, 08 Jul 2010 09:52:28 GMT

Thank you! The translate-function is good 🙂