topic format in proc sql in SAS Programming

format in proc sql

FP12 — Thu, 05 Oct 2017 11:45:14 GMT

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 — Thu, 05 Oct 2017 12:15:43 GMT

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 — Thu, 05 Oct 2017 12:22:40 GMT

Use 8. informat in your INPUT function instead.