Display negative percents in parenthesis in SAS-VA

[JGreenberg]

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!

[SASKiwi]

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

[JGreenberg]

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

[SASKiwi]

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.