topic Display negative percents in parenthesis in SAS-VA in SAS Visual Analytics

Display negative percents in parenthesis in SAS-VA

JGreenberg — Mon, 17 Oct 2016 15:30:32 GMT

Hi SAS-VA community,

I am trying to display a scorecard with 4 columns as a table: metric, value, average, and percent delta from the average. Ideally, I would like the negative percent changes to display in parenthesis such as they do with the PERCENTw.d format in base SAS; So I want -x.xx% to become (x.xx%).Unfortunately when applying the PERCENTw.d format to the delta column in my custom query in SAS-VA the negative percentages are still displayed as -x.xx%, not (x.xx%).

Does anyone know how to fix this display issue?

Thanks!

Re: Display negative percents in parenthesis in SAS-VA

SASKiwi — Tue, 18 Oct 2016 01:15:09 GMT

Well that's strange. That's the behaviour of PERCENTNw.d. What happens with that format?

Re: Display negative percents in parenthesis in SAS-VA

JGreenberg — Thu, 20 Oct 2016 20:08:37 GMT

Thanks for the response SASKiwi, unfortunately PERCENTNw.d yields the same results.

Re: Display negative percents in parenthesis in SAS-VA

SASKiwi — Fri, 21 Oct 2016 06:04:35 GMT

I checked SAS Notes on this and couldn't find anything. I suggest you open a track to SAS Tech Support if you haven't done so already. The only workaround I can think of is a custom PICTURE format and these are explicitly not supported in VA.