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
compute percent;
if sign(percent) eq -1 then call define(_col_,'style','style=[color=RED]');
endcomp;
I don't see how you implemented the red color logic in the first place. Could you also supply that piece of the code?
compute percent;
if sign(percent) eq -1 then call define(_col_,'style','style=[color=RED]');
endcomp;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.