topic Re: VA 7.1 - remove $ sign when we choose the format type as Currency in SAS Visual Analytics

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

Explore_SAS — Fri, 12 Feb 2016 16:40:18 GMT

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.

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

Sam_SAS — Fri, 12 Feb 2016 17:00:06 GMT

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

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

ballardw — Fri, 12 Feb 2016 18:36:50 GMT

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.

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

Explore_SAS — Fri, 12 Feb 2016 18:39:49 GMT

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

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

Explore_SAS — Fri, 12 Feb 2016 18:41:04 GMT

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

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

Sam_SAS — Fri, 12 Feb 2016 18:56:34 GMT

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.

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

Explore_SAS — Mon, 29 Feb 2016 19:26:33 GMT

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.

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

svobodova_v — Fri, 11 Mar 2016 12:19:24 GMT

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!

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

svobodova_v — Fri, 11 Mar 2016 12:24:33 GMT

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!

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

Sam_SAS — Fri, 11 Mar 2016 15:10:02 GMT

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

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

Explore_SAS — Mon, 14 Mar 2016 15:08:31 GMT

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.

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

Sam_SAS — Mon, 14 Mar 2016 15:31:46 GMT

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.

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

svobodova_v — Wed, 16 Mar 2016 13:14:46 GMT

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!

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

Sam_SAS — Wed, 16 Mar 2016 14:20:43 GMT

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