BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ronein
Onyx | Level 15

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

1 ACCEPTED SOLUTION

Accepted Solutions
Ronein
Onyx | Level 15

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

3 REPLIES 3
novinosrin
Tourmaline | Level 20

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.

Ronein
Onyx | Level 15

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;

Ksharp
Super User

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

 

 

Data b;
Set a;
PCT_Change=(After-before)/before;
Format     PCT_Change     percentN9.2;
Run;
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 4912 views
  • 1 like
  • 3 in conversation