VA 7.1 - remove $ sign when we choose the format type as Currency

[Explore_SAS]

Hi All,

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.

[Sam_SAS]

Hello,

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.

Sam

[Explore_SAS]

we dont want to show any signs but just wanted to use the formatting for currency.

[svobodova_v]

Hello,

according to your answer- could you please help me, if I would need the firts possiblity you wrote- I need to change the dollar sign for other currency symbol.

Please, do you know how to do it? 

Thanks a lot!

[ballardw]

You might investigate if the SAS format NEGPAREN is available. That would display values of 2000 as 2,000 and -2000 as (2,000) with suitable width (need at least 3 more than you think you need for the (-) characters.

[Explore_SAS]

NEGPAREN format is not available in visual analytics.
Thanks for your inputs.

[Sam_SAS]

Negparen can be set in the Visual Data Builder. I believe it should be honored in your report, but I cannot test it at the moment.

[Explore_SAS]

we did cross checked by changing the format to Negparen, but its not reflecting in VA.

looks like that VA supports only those format which are there on UI.

[svobodova_v]

Hello,

I would need an advice about the second option- I need to change the dollar sign for another one. 

Does anyone know how to change the currency symbol please? 

Thanks a lot!

[Sam_SAS]

Hi,

Which symbol do you need?

The CURRENCY format is supposed to display the appropriate currency symbol for your current locale (for example, £ for the United Kingdom). I am not sure how many currencies are supported by this format, but you should give it a try.

We also have the DOLLAR, EURO, POUND, WON, and YEN formats if you want to specify one of those specific currencies.

Does that help?

Sam

[Explore_SAS]

Hi Sam,

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.

[Sam_SAS]

My reply about CURRENCY was intended for +svobodova_v.

Unfortunately I don't think there is a currently a way to get the NEGPAREN format in Visual Analytics.

[svobodova_v]

Hello,

thanks for your suggestions. The currency format I would prefer is CZK. I don´t think the CZK is supported format, is it? 

Thanks!

[Sam_SAS]

Hi svobodova_v,

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".