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
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;
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.
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;
Data a;
Input before after;
Cards;
200 150
;
Run;
Data b;
Set a;
PCT_Change=(After-before)/before;
Format PCT_Change percentN9.2;
Run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.