10-05-2017 07:45 AM
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?
10-05-2017 08:15 AM
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.