Email code works in EG not in DI

[Leslie6860]

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;

[LinusH]

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.

• Are you using the same user?
• Is it on the same Workspace Server?
• What happens if you deploy the job an run it in batch?