topic Re: Convert char values to numeric values in SAS Procedures

Convert char values to numeric values

Lani — Fri, 05 Feb 2010 01:07:48 GMT

Hi all,

I am trying to remove "$", "," and then convert from char values to numeric values

amount (from input data)
$1,100.1
$1000
$59,000
$59

n_amount (the output)
1100.10
1000.00
59000.00
59.00

my codes:
attrib amount length=$10.
n_amount length=10.;

n_amount = input(amount,comma10.2);

However, the output I got:
n_amount
1100.1
10
590
0.59

Please help! Thank you.

-Lani

Re: Convert char values to numeric values

sbb — Fri, 05 Feb 2010 01:18:58 GMT

Where is your INPUT statement logic to read up your data and assign a SAS character variable? It's best to share all your SAS code and ideally share it in a SAS session log (pasted in your post/reply).

You can add SAS PUTLOG _ALL_; commands to display all variable values - this may help you self-diagnose the situation.

Scott Barry
SBBWorks, Inc.

Re: Convert char values to numeric values

deleted_user — Fri, 12 Feb 2010 06:39:41 GMT

Hi Lani,

See here you are assigning the length of the string as 10 to the variable char Amount.
When you apply the comma10.2 to read it in input statement it will take the last two digits as the digits after decimal point.
for example:

data test;
input chars $10.;
cards;
$1,100.100
$1000.0000
$59,000.00
$59.000000
;
run;

data temp;
set test;
newnum=input(chars,dollar10.2);
run;
proc print;
run;

Running the above code will give you the right result. since the length is exactly 10 chars.

If you want to get the desired result on the data which you have provided just use comma10. or dollar10. format and not the decimal part of the formats.
Try following this code:

data test;
input chars $10.;
cards;
$1,100.1
$1000
$59,000
$59
;
run;

data temp;
format newnum 10.2;
set test;
newnum=input(chars,dollar10.);
run;
proc print;
run;

Thanks,
Saurabh. Message was edited by: emerald85