The SAS Output Delivery System and reporting techniques

Zero Values Highlighted in Red - Formatting Issue

Reply
N/A
Posts: 0

Zero Values Highlighted in Red - Formatting Issue

I currently have a format that makes anything with a negative value red with ( ) around them. For the most part this works, but every once in a while there is a "positive" zero value that gets highlighted red. I am not sure why this is happening. Below is a sample of the code.

Example of Format:
*********************************;
proc format;
value difffmt
-100000000 - 0.0001 = 'red';
picture NegDol (multilabel)
-100000000 - 0.00001 = '000,000,000,000)' (prefix='($')
0.00001 - 100000000000 = '000,000,000,000' (prefix='$');

Example of what's being formatted:
Prcnt_Balance_Growth *f=percent7.2* [style=[foreground=difffmt.]]
N/A
Posts: 0

Re: Zero Values Highlighted in Red - Formatting Issue

Oops realized I posted in the wrong forum. Please disregard.
Ask a Question
Discussion stats
  • 1 reply
  • 129 views
  • 0 likes
  • 1 in conversation