we have to use the currency feature format for some columns, like showing negative nos in bracket.
when we choose format as currency by default sas VA is appending the $ sign to the nos.
Does anyone know how we can remove the $ sign from the currency format.
Do you want to show a different symbol other than the $ sign? Or do you want the behavior for negative numbers while having no currency symbol at all? It might be necessary to create a custom format in your data preparation to have no currency symbol.
we dont need the symbols in front of the numbers as our column are derived by a parameter. but we definitely need to see the negative number in parenthesis.
when we choose only currency as a option by default it automatically takes $ sign.
Base SAS has a NLMNICZK format, but it doesn't appear that the CURRENCY format in VA will output values in CZK. 😞
I tried it with my locale as Czech and I was surprised to see that the format names are localized. So if you are using the Czech user interface, the format I am talking about is apparently "Mĕna".
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.