This code works in EG and emails out fine. As soon as i put this into a user written transformation, nothing happens. The job runs with no errors but no email comes through.
Any Idea's?
Thanks, Les
FILENAME mail EMAIL TO=("xxx@xxx")
SUBJECT="Lunch Time Adherence - &sysdate." CONTENT_TYPE="text/html";
ODS LISTING CLOSE;
ODS HTML BODY=mail;
proc report data=sme_ad.lunch_adherance ;
column
Agent
Lunch_Start
Formula_Act_Lunch_Start
Adherance;
compute adherance;
if adherance = "Adherent Lunch" then call define(_col_,"style","style={background=lightgreen}");
if adherance = "Adherent Lunch - Calls Prevented" then call define(_col_,"style","style={background=green}");
if adherance = "Non-Adherent Lunch - No Calls Prevented" then call define(_col_,"style","style={background=red}");
if adherance = "Non-Adherent Lunch" then call define(_col_,"style","style={background=red}");
if adherance = "Non-Adherent Lunch (Before Planned Lunch)" then call define(_col_,"style","style={background=red}");
endcomp;
run;
It would be great if you could have the example using SASHELP.CLASS so everyone could test it.
What does the log say?
I see no macro variables, but this is just for testing? Wouldn't be of much use to have it in a User Written Transform otherwise.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.