topic Re: Dollar format in SAS Programming

Dollar format

JHE — Thu, 11 Oct 2018 16:54:10 GMT

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 — Thu, 11 Oct 2018 16:55:41 GMT

shouldn't it be

PROC SQL;

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

QUIT;

PaigeMiller — Thu, 11 Oct 2018 16:55:44 GMT

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 — Thu, 11 Oct 2018 17:05:11 GMT

thank you, this is working.