topic Re: Converting Character amount values to Numeric for Sort Sum in SAS Programming

Converting Character amount values to Numeric for Sort Sum

SASInd — Tue, 27 Feb 2018 10:33:43 GMT

I have one field named 'Amount' which is in character format of 20 bytes i.e. $20.

I want to perform Sort Sum on this amount field but I am getting error as character data can't be added up. Please suggest what needs to be done here?

I have below amounts in my input file which has been set as $20. Also, I have tried changing $20. to PD format but no luck. I want to convert this in numeric format so that it will be printed as it is and sort sum can be performed.

-80.45

-202.07

126995.77

Re: Converting Character amount values to Numeric for Sort Sum

PeterClemmensen — Tue, 27 Feb 2018 10:41:08 GMT

Like this?

data have;
input Amount $20.;
datalines;
-80.45
-202.07
33
126995.77
;

data want;
   set have;
   NumAmount=input(Amount, 20.);
run;

Re: Converting Character amount values to Numeric for Sort Sum

SASInd — Tue, 27 Feb 2018 11:01:50 GMT

Hi @PeterClemmensen

I already tried the below code. But the amounts are not populating as expected.

The decimal digit places are not being printed. Also, I tried 20.2 but it it converting all the values with 2 decimal places.

When I ran code with 20.2 I got below result which is wrong.

Input Output

-79.34 -79.34
0 0.00
854 8.54
-202.07 -202.07

When I ran the code with 20. I got below results.

Input Output

-79.34      -79
  0 0
  854     854
-202.07 -202.

Re: Converting Character amount values to Numeric for Sort Sum

Satish_Parida — Tue, 27 Feb 2018 11:10:28 GMT

Why do you want to use 20.2?
You can use 20. or best12. as well based on the highest length.

Re: Converting Character amount values to Numeric for Sort Sum

Astounding — Tue, 27 Feb 2018 11:17:26 GMT

@PeterClemmensen provided the correct solution. You are getting those results because you added to it something like:

format NumAmount 20.;

Get rid of the FORMAT statement.

Re: Converting Character amount values to Numeric for Sort Sum

SASInd — Tue, 27 Feb 2018 13:09:43 GMT

Below is my code. it's not working properly for decimal places.

DATA WANT;
OPTIONS MISSING='#' LS=MAX PS=MAX ;
INFILE INPFL ;

INPUT @30 AMT $20.;

AMTN = INPUT(AMT, 20.);

FILE FLATFL;

PUT @30 AMTN 20.;

Re: Converting Character amount values to Numeric for Sort Sum

Astounding — Tue, 27 Feb 2018 13:19:38 GMT

So you applied the format in a PUT statement instead of a FORMAT statement. Still, you got what you requested. Change the PUT statement:

put @30 amtn 20.2;