My problem is that the output create a Traffic light report, but if a negative $ value is returned, the font is red. However, the background for that cell will also be red because of the traffic light rules. I need to be able to reset the format in Excel to make sure that the font color is black.
What do I need to do to send the desired font color to Excel?
Are you using PROC PRINT, PROC REPORT or PROC TABULATE for setting your traffic lighting?? User-defined format?? or CALL DEFINE??
The reason I ask is that, when I run this code in SAS (not as a stored process, just as a regular step), I get a red background color and black font in Excel.
You may want to contact Tech Support and have them look over your entire program and suggest how you can change your code to achieve what you want. It seems odd to me that your traffic lighting would make both the foreground and background color red.
My foreground color is black when I submit this code:[pre]
if age gt 14 then age = age * -1;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.