Display Numbers between paranthes in Report

MohamedS — Tue, 18 Dec 2007 11:24:57 GMT

Hi,

do any one know how to display numbers in report between paranthes i.e. (455.0)

thanks

Re: Display Numbers between paranthes in Report

deleted_user — Tue, 18 Dec 2007 12:41:47 GMT

there is format negparen
which puts negative numbers in parentheses. Just try[pre]
data;
valuep = 455.01 ;
value = -valuep;
put value= negparen11.2 ;
put valuep= negparen11.2 ;
run; [/pre]
My SAS log shows [pre]
value=(455.01)
valuep=455.01
NOTE: The data set WORK......[/pre]

If you are unable to make your values negative, in PROC FORMAT try the PICTURE statement to achieve what you need. There is an example in online doc at http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a002473483.htm which you can adapt it to your needs. Something like [pre]
proc format ;
picture parens (round)
low - high = '0,000,000.0)'( prefix='(' ) ;
run;
[/pre]
testing in my SAS log produces [pre]
33 %put demo= %sysfunc( max( -12345.67, 1234.5), parens );
demo= (1,234.5)
[/pre]

Good Luck

PeterC

Re: Display Numbers between paranthes in Report

MohamedS — Sun, 06 Jan 2008 12:11:54 GMT

Hi Peter,

Thanks, It worked.

topic Re: Display Numbers between paranthes in Report in ODS and Base Reporting

Display Numbers between paranthes in Report

Re: Display Numbers between paranthes in Report

Re: Display Numbers between paranthes in Report