topic Re: Picture Formats in SAS Procedures

Picture Formats

SAS09 — Fri, 12 Oct 2012 17:20:42 GMT

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!

Re: Picture Formats

ballardw — Fri, 12 Oct 2012 22:58:34 GMT

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;

Re: Picture Formats

Tom — Sat, 13 Oct 2012 02:00:08 GMT

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.

Re: Picture Formats

SAS09 — Sat, 13 Oct 2012 13:33:26 GMT

This is perfect! It worked.