Currency format in SAS 9.3

Whitlea — Thu, 30 Mar 2023 19:53:37 GMT

Is there a way to format currency in SAS 9.3 with the dollar sign and no decimals in a proc tabulate statement?

Thanks for your help!

Re: Currency format in SAS 9.3

ballardw — Thu, 30 Mar 2023 20:03:15 GMT

Use the Dollar format with a decimal indicator of 0 such as

Format x dollar15.0 ;

or the statistic in tabulate

Amount * sum*f=dollar15.0

The Dollar format will also place commas in the value so may need to wider than you think.

If you do not want the commas then use proc format to create a custom format with the currency symbol of choice as a PREFIX= option on a Picture statement.

topic Re: Currency format in SAS 9.3 in SAS Programming

Currency format in SAS 9.3

Re: Currency format in SAS 9.3