Dollar format

[JHE]

I have summary data:

$40134399,

it was the result of

PROC SQL;

 SELECT SUM(PAID_AMT)  FORMT==dollar10. AS PAID_AMT;

QUIT;

it has no position, no decimal, dose not looking good.

Then I did this way:

PROC SQL;

 SELECT SUM(PAID_AMT)  FORMT==dollar10.2 AS PAID_AMT;

QUIT;

this result even worse as :

40134399.0

please advise, what was wrong .

Thank you

Joanne

[novinosrin]

shouldn't it be

PROC SQL;

 SELECT SUM(PAID_AMT)  FORMAT==dollar10.2 AS PAID_AMT;

QUIT;

[PaigeMiller · Accepted solution]

Use format=dollar16.2

When you specify dollar10., the format is not wide enough for a long number plus commas and a dollar sign and decimal place.

[JHE]

thank you, this is working.