topic Re: How to send an email report even with zero records? in SAS Programming

How to send an email report even with zero records?

Stalk — Mon, 12 Sep 2022 18:17:07 GMT

I want to send a report to myself every weekday even if the counts are zero..

My code so far..

proc sql;
create table cars_temp as
select make, origin, count(*) as total
from sashelp.cars
group by make, origin;
quit;

options emailsys=smtp emailhost=xxxxxxxxx emailport=25;

filename temp email

to = ( 'xxx@xxxxx.xom' )
from='xxx@xxxxx.xom'
subject="Daily discrepancies - &rptdt."
type="text/html"
ODS html body=temp style = journal;

TITLE justify= left "Below counts are calculated based on Yesterday's Date ";
*ods html text = "";
PROC REPORT DATA=cars_temp nowd HEADLINE HEADSKIP SPLIT='*'
style (report) = {background = white
font_face = "Verdana" font_size = 7pt just=left }
style (column) = {background = white CELLHEIGHT = 2.5%
font_face = "Verdana" font_size = 7pt just=left}
style (header) = {foreground = cx5e2750 font_face="Verdana"
font_size = 8pt just=left
background = white} ;

column A B C ;
define A / group width= 15 "Region * ID";
define B / group width= 30 "Region * Name";
define C / mean width= 30 "Total # * of items ";
run;

ods html text=" Daily counts";

ods html text = ".";

ods _all_ close;

Thank you

Re: How to send an email report even with zero records?

ChrisHemedinger — Mon, 12 Sep 2022 18:31:06 GMT

There are several ways to accomplish this but here's one from my code.

/* after your PROC SQL step, SQLOBS will have the record count */ %let itemcount=&sqlobs.; %macro emailbody; %if &itemcount. > 0 %then %do; title "The following items were added in the past 5 days (&SYSDATE.)"; proc print data=recent; run; %end; %else %do; title; ods text="NO recent items added (past 5 days)."; %end; %mend; filename msg email to=&TO_LINE. FROM = "me@email.com" subject="Recent entries as of &SYSDATE." type='text/html' CT ='text/html' ; ods html(id=email) file=msg style=dove; %emailbody; ods html (id=email) close;

Re: How to send an email report even with zero records?

Stalk — Mon, 12 Sep 2022 21:25:25 GMT

Thank you Chris. It worked as desired. &sqlobs is very helpful. Also registered at SAS Explore using the link from your signature line:-)