DATA Step, Macro, Functions and more

remove parentheses from percent format

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 95
Accepted Solution

remove parentheses from percent format

Hello

I am using  percent9.2 format in order to show values as percentage with % symbol.

When the value is negative it is presented with parentheses ( )

How can I remove parentheses please?

I want to see for example  -23.2%  and not  (23%)

 

 

thanks

Ron


Accepted Solutions
Solution
‎12-16-2017 04:48 AM
Frequent Contributor
Posts: 95

Re: remove parentheses from percent format

Posted in reply to novinosrin

I don't understand

Please look here

I want to see  -25%   and not (25%)

 

Data   a;

Input  before   after;

Cards;

200     150

;

Run;

 

 

Data b;

Set a;

PCT_Change=(After-before)/before;

Format     PCT_Change     percent9.2;

Run;

View solution in original post


All Replies
PROC Star
Posts: 1,340

Re: remove parentheses from percent format

why didn't you use

 

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002980019.htm

 

   

 

PERCENTNw.d Format



Produces percentages, using a minus sign for negative values.

Solution
‎12-16-2017 04:48 AM
Frequent Contributor
Posts: 95

Re: remove parentheses from percent format

Posted in reply to novinosrin

I don't understand

Please look here

I want to see  -25%   and not (25%)

 

Data   a;

Input  before   after;

Cards;

200     150

;

Run;

 

 

Data b;

Set a;

PCT_Change=(After-before)/before;

Format     PCT_Change     percent9.2;

Run;

Super User
Posts: 10,618

Re: remove parentheses from percent format


Data   a;
Input  before   after;
Cards;
200     150
;
Run;

 

 

Data b;
Set a;
PCT_Change=(After-before)/before;
Format     PCT_Change     percentN9.2;
Run;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 198 views
  • 0 likes
  • 3 in conversation