topic Re: remove parentheses from percent format in SAS Programming

remove parentheses from percent format

Ronein — Sat, 16 Dec 2017 07:27:40 GMT

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

Re: remove parentheses from percent format

novinosrin — Sat, 16 Dec 2017 08:09:07 GMT

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.

Re: remove parentheses from percent format

Ronein — Sat, 16 Dec 2017 08:55:33 GMT

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;

Re: remove parentheses from percent format

Ksharp — Sat, 16 Dec 2017 09:40:21 GMT


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

 

 

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