DATA Step, Macro, Functions and more

format in proc sql

Reply
Contributor
Posts: 34

format in proc sql

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

 

SAS Employee
Posts: 126

Re: format in proc sql

Hi @FP12

 

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

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

 

Hope that helps.


Cheers,
Damo

PROC Star
Posts: 765

Re: format in proc sql

Use 8. informat in your INPUT function instead.

Ask a Question
Discussion stats
  • 2 replies
  • 75 views
  • 0 likes
  • 3 in conversation