topic Print negative number in RED - E-mail in ODS and Base Reporting

Print negative number in RED - E-mail

Praveen1 — Mon, 01 Feb 2016 11:06:53 GMT

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

Re: Print negative number in RED - E-mail

Kurt_Bremser — Mon, 01 Feb 2016 11:32:21 GMT

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

Re: Print negative number in RED - E-mail

data_null__ — Mon, 01 Feb 2016 12:03:14 GMT

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

Re: Print negative number in RED - E-mail

Praveen1 — Mon, 01 Feb 2016 12:37:19 GMT

Thanks a lot.

It worked perfectly.

I was not aware of SIGN() function..