topic how transforme currency representation value monetary em real in the sas in SAS Visual Analytics

how transforme currency representation value monetary em real in the sas

romartins — Tue, 07 Feb 2023 20:31:27 GMT

I have a dataset that deals with monetary values, and some of its values, by business rule, end up being positive values, but also negative values. We found some formats but without success of representation, according to the attached images.

The question is, how do I transform a NUMERIC value (not char) to represent it with the real R$ Symbol to use in the sas visual analytics?

I have at the moment:

nlmnlbrl

nlmnibrl

I'm looking for something like:

100,00 -> R$ 100,00
0,00 -> R$ 0,00

-100,00 -> R$ -100,00

Re: how transforme currency representation value monetary em real in the sas

Sam_SAS — Tue, 07 Feb 2023 21:06:47 GMT

Hello,

What version of Visual Analytics do you have?

In 8.5 and later, I can select "Currency (local)" and then pick "Brazil" to get "R$" format:

This is likely also available for earlier versions, but I only have 8.5 and later easily accessible to me.

Is that what you are looking for?

Thanks,

Sam

Re: how transforme currency representation value monetary em real in the sas

romartins — Wed, 08 Feb 2023 12:38:21 GMT

Hi Sam,
The version I have is 8.5.2. Yes, this is exactly what we are looking for. We are even using this same option.

The issue is that I need to modify this representation of the SYMBOL to negative NUMERIC values, by default, it comes with "(" ")", and this is not ideal for the client, I need it to be something like "R$ -100,00" for example. Do you know if there is such a possibility?

Re: how transforme currency representation value monetary em real in the sas

Sam_SAS — Wed, 08 Feb 2023 13:05:48 GMT

Thanks for the clarification.

@Madelyn_SAS @HunterT_SAS , can you help with this numeric formatting issue?

Thanks,

Sam

Re: how transforme currency representation value monetary em real in the sas

HunterT_SAS — Wed, 08 Feb 2023 14:29:56 GMT

Unfortunately displaying negative currency values with a hyphen/dash instead of within parenthesis is not an option in Visual Analytics version 8.5.2. Currency will always use the parenthesis to show negative values.

You *might* be able to achieve this with a user-defined format, but this is not something I have explored:

https://go.documentation.sas.com/doc/en/calcdc/3.5/caldatamgmtcas/n0jtz261h5qtg7n1j6ql02gd65lo.htm

Or using a non-currency format will also show the negative symbol (hyphen/dash) if you can get away with that, but I realize that is not ideal either.

This has changed for Viya 4 if moving to that release in the future is an option. In that version of Visual Analytics (version 2023.02 in this example), negative values are used: