Sending email with HTML report

nickb — Tue, 11 Oct 2011 18:34:53 GMT

I'm looking to send an HTML email only when the dataset has records. This is what I have:

data _null_;

if _n_ eq 1 and eof then stop;

file out email

subject="Grade check results as of %sysfunc(date(),mmddyy10.)"

type="text/html";

stop;

set WORK.grade_check(drop=_all_) end=eof;

run;

ods html body=out;

proc print data=WORK.grade_check noobs label;

run;

ods html close;

run;

Thanks,

Nick

Ksharp — Wed, 12 Oct 2011 05:27:08 GMT

Or you can use macro variable to make a condition.

%let dsid=%sysfunc(open(work.class));

%let nobs=%sysfunc(attrn(&dsid,nobs));

%let dsid=%sysfunc(close(&dsid));

.........

%if &nobs gt 0 %then %do;

..............

Ksharp

topic Sending email with HTML report in SAS Procedures