format in proc sql

[FP12]

Hi all,

I have a table A with a column amountA, which is character length 11

There is only one row where in this case amountA = "236761", but it could be "99999.09" (there can be decimals)

I want to transform it into numeric 20.2

So I do something like this:

PROC SQL;
   CREATE TABLE B AS 
   SELECT
            (input(t1.amountA,comma20.2)) FORMAT=20.2 AS Calculation
      FROM A t1;
QUIT;

In the output the value is 2367.61 => The amount have been divided by 100...

Whereas I need something like 236761 or 236761.00

Do you know how to manage it?

Thanks

[Damo]

Hi @FP12

If you simply use the below statement it should do the trick (I think :))

  (input(t1.amountA,8.)) FORMAT=20.2 AS Calculation

Hope that helps.

Cheers,
Damo

[PeterClemmensen]

Use 8. informat in your INPUT function instead.