Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Display negative percents in parenthesis in SAS-VA

Reply
New Contributor
Posts: 4

Display negative percents in parenthesis in SAS-VA

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!

Respected Advisor
Posts: 2,913

Re: Display negative percents in parenthesis in SAS-VA

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

New Contributor
Posts: 4

Re: Display negative percents in parenthesis in SAS-VA

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

Respected Advisor
Posts: 2,913

Re: Display negative percents in parenthesis in SAS-VA

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.

Post a Question
Discussion Stats
  • 3 replies
  • 185 views
  • 0 likes
  • 2 in conversation