Picture Formats

[SAS09]

Could some one please let me know how I could insert parentheses as well as the $ sign for negative values using picture formats.  I can do parentheses or the $ sign but dont know how to apply both.  I am using them in Proc Report  Any thoughts?

Thanks in advance!

[ballardw · Accepted solution]

Does this do what you want (look in log for output):

proc format library=work;

picture pay low-<0 ='000,009.99)' (prefix='($')

0 -high='000,009.99' (prefix='$');

run;

data _null_;

x= -1.25; put x pay.;

x= 1.25; put x pay.;

run;

[Tom]

You should add a space to the end of the picture for positive numbers so that the decimal place lines up with the negative numbers.

[SAS09]

This is perfect!  It worked.