topic Email Reports to end users in SAS Programming

Email Reports to end users

BrahmanandaRao — Tue, 16 Mar 2021 08:54:50 GMT

FILENAME output EMAIL
SUBJECT= "Sales summary report 1"
FROM= "anandsasjobs@gmail.com"
TO= "anandsasjobs@gmail.com";
ODS HTML BODY=output STYLE=sasweb;
TITLE JUSTIFY=left
 "Total Sales by Country and Product type as of %sysfunc(date(),yymmdd10.)";
PROC REPORT DATA=sashelp.class NOWD	;
COLUMNS NAME SEX AGE;
DEFINE NAME /DISPLAY;
DEFINE SEX /DISPLAY;
DEFINE AGE/DISPLAY ;

RUN;
ODS HTML CLOSE;

Re: Email Reports to end users

yabwon — Tue, 16 Mar 2021 09:21:35 GMT

Hi,

1) try to add:

CONTENT_TYPE='text/html'

to the filename definition.

2) check if you google account has enabled "acces by less secure applications"

All the best

Bart

Re: Email Reports to end users

Kurt_Bremser — Tue, 16 Mar 2021 09:55:47 GMT

Check with your SAS administrator which originating email addresses are allowed by the mail agent configured in SAS. If in doubt, omit the FROM option.

Re: Email Reports to end users

BrahmanandaRao — Tue, 16 Mar 2021 09:56:15 GMT

filename output email
subject= "sales summary report 1"
from= "anandsasjobs@gmail.com"
to= "anandsasjobs@gmail.com"
content_type= "text/html"  ;
ods html body=output style=sasweb;
title justify=left
 "total sales by country and product type as of %sysfunc(date(),yymmdd10.)";
proc report data=sashelp.class nowd	;
columns name sex age;
define name /display;
define sex /display;
define age/display ;
run;
ods html close;

same error

Re: Email Reports to end users

Sajid01 — Tue, 16 Mar 2021 14:16:32 GMT

Please see the sasnotes https://support.sas.com/kb/19/767.html and https://support.sas.com/kb/41/961.html .
Check if from address can be a gmail address from your email / system admin.