topic Re: Format Comma10.2 or Dollar10.2 in SAS in SAS Programming

Format Comma10.2 or Dollar10.2 in SAS

user112a2 — Fri, 26 Apr 2019 15:51:07 GMT

Hello. I have a question on format in SAS. Below is my code

 Removed

correction_am is format numeric 8. How do I change this to Comma10.2 or Dollar10.2 in SAS in data step or proc sql code? I have tried various methods that did not work.

I have tried below code which worked but did not retain the two decimal places.

Removed

Re: Format Comma10.2 or Dollar10.2 in SAS

Kurt_Bremser — Tue, 07 Aug 2018 13:24:42 GMT

Try this:

proc sql;
create table OUT.FIN_POP_4a as
select sum(CORR_AM) as correction_am format=dollar10.2
from OUT.FIN_POP_4
;
quit;

Re: Format Comma10.2 or Dollar10.2 in SAS

user112a2 — Fri, 26 Apr 2019 18:04:32 GMT

Hey I tried that and it did not format with commas:

Removed

I want:

Removed

Re: Format Comma10.2 or Dollar10.2 in SAS

Tom — Tue, 07 Aug 2018 13:37:22 GMT

@user112a2 wrote:

Hey I tried that and it did not format with commas:

2084608.44

I want:

2,084,608.44 or $2,084,608.44

You need count the commas (and dollar sign) when setting the width.

1234567890123456
2084608.44
$2,084,608.44

Try DOLLAR13.2 or increase the width even more if your values can be larger than $9,999,999,99