Hello, I have a requirement to display negative currency in paranthesis. So I am using a custom format. Here is how the format is created proc format lib=sasrepo; picture DollarParen low - -1 = '000,000,000,000.00)' (prefix='($') -1 <-< 0 = '99)' (prefix='($0.' mult=100) 0 -< 1 = '99' (prefix='$0.' mult=100) 1 - high = '000,000,000,000.00' (prefix='$'); run; My field has the number -142663408.917 when I use the Dollar format, the field displays as -142663408.92 which is correct. but when I use the custom format I get ($142663408.91). For some reason the custom format is stripping the last digit. Even if I round the number round(-142663408.917,.01) and then apply the custom format I still get the field to display ($142663408.91) Can you please look at the custom format and let me know what I need to do to get the right dispaly. I need the negative currency amounts to display in paranthesis and rounded to 2 digit. Thank You Shri
... View more