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.)"
from='RAR@test.edu'
to = 'me@test.edu'
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;
ods html close;
Thanks,
Nick
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
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.
Register now!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.