- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-30-2023 03:53 PM
(621 views)
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!
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.