02-12-2016 11:40 AM
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.
02-12-2016 12:00 PM
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.
03-11-2016 07:24 AM
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!
02-12-2016 01:36 PM
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.
02-12-2016 01:56 PM
02-29-2016 02:26 PM
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.
03-11-2016 07:19 AM
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!
03-11-2016 10:10 AM
03-14-2016 11:08 AM
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.
03-14-2016 11:31 AM
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.
03-16-2016 09:14 AM
thanks for your suggestions. The currency format I would prefer is CZK. I don´t think the CZK is supported format, is it?
03-16-2016 10:20 AM - edited 03-16-2016 10:20 AM
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".