Print negative number in RED - E-mail

[Praveen1]

Hi ,

I am trying to print the negative numbers in RED text and send the contents to my email id

I am able to print numbers in the body of the email using proc report but loosing the red color logic.

Can someone please share the style or format i need to apply to get the negative numbers in red color on the email body

I have a bunch of percentages/dollar values to keep it simple for the users i have created a simple version of code.

data test;
input @1 percent;
datalines;
10.12
-10.30
20.3
-40.30
;
run;
title "";
FILENAME NOTE EMAIL
TO=("user@gmail.com")
SUBJECT ="DAILY"
type="text/html"

;
ods html body=note;

PROC REPORT DATA=TEST;
COL percent;
DEFINE percent / display ;
RUN;

QUIT;

ODS HTML CLOSE;

Thanks

Praveen

[Kurt_Bremser]

I don't see how you implemented the red color logic in the first place. Could you also supply that piece of the code?

[data_null__ · Accepted solution]

compute percent;
   if sign(percent) eq -1 then call define(_col_,'style','style=[color=RED]');
   endcomp;

[Praveen1]

Thanks a lot.

It worked perfectly.

I was not aware of SIGN() function..