topic Re: Numeric Format for negative sign in ODS and Base Reporting

Numeric Format for negative sign

deleted_user — Thu, 29 Mar 2007 12:58:32 GMT

Hi Friends,

I tried with Format negparen6.2 for numeric column. If the field is wide enough, NEGPARENw.d places parentheses around a number to represent a negative value. But i need to be negative sign. Please help me. Very urgent.

Thanks,
Selvi.

Re: Numeric Format for negative sign

Cynthia_sas — Thu, 29 Mar 2007 15:06:18 GMT

Try making your width value -smaller- in order to get the parentheses to go away and show a negative sign (with negparen format) or simply use a w.d format as shown below. For more help with formatting numbers, there is extensive documentation in the SAS on-line doc or you can always call on Tech Support for help with a user-defined PICTURE format of your own.
cynthia
[pre]
data fmtnum;
input num;
return;
datalines;
-1
-.045
4
.065
;
run;

ods listing;
proc print data=fmtnum;
title 'with negparen format -- format cannot be too big';
format num negparen5.3 ;
run;

proc print data=fmtnum;
title 'with simple w.d format';
format num 5.3 ;
run;
[/pre]

Re: Numeric Format for negative sign

Smora0713 — Tue, 02 Jun 2020 16:22:53 GMT

How would you go about having both parentheses and a dollar sign? e.g. ($20.01).

Is there a present format that I can use if not would I need to create one with Proc Format?

Re: Numeric Format for negative sign

Cynthia_sas — Tue, 02 Jun 2020 23:50:33 GMT

Hi:

Rather than piggyback on such an old posting, you might want to start a new post. I nearly didn't read this when I saw how old the original post was.

I think your only choice is a PICTURE format, as shown in example #3:

Hope this helps,

Cynthia