Hello
I am running a code to send an email from SAS program.
I get an error:
ERROR: Email host smtprelay not found.
What is the way to solve it please?
/****Send Report via email***********/
/****Send Report via email***********/
/****Send Report via email***********/
FILENAME mail
EMAIL TO="<Dave.tein@gmail.com>"
CC=("Dave.tein@gmail.com","Dave.tein@gmail.com")
FROM='<Dave.tein@gmail.com>'
SUBJECT="Summary Data"
CONTENT_TYPE="text/html"
encoding="utf-8";
ODS LISTING CLOSE;
ODS HTML BODY=mail;
proc report data=sashelp.cars nowd noheader ;
run;
proc report data = SasHelp.Cars(obs = 5) split = "*";
column Type MPG_Ratio MPG_City MPG_Highway;
define Type / display ;
define MPG_City / display;
define MPG_Highway / display;
define MPG_Ratio / computed 'City/Highway' format = 4.2;
compute MPG_Highway;
MPG_Ratio = MPG_City/MPG_Highway;
endcomp;
run;
ODS HTML CLOSE;
ODS LISTING;
Here is the Log
1 The SAS System 09:54 Sunday, January 1, 2023
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='AAA';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='K:\RON EINSTEIN\LEARN\AAA.sas';
9 %LET _SASPROGRAMFILEHOST='VSK2H010A3280';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HTMLBlue
17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26
27 /****Send Report via email***********/
28 FILENAME mail
29 EMAIL TO="<Dave.tein@gmail.com>"
30 CC=("Dave.tein@gmail.com","Dave.tein@gmail.com")
31 FROM='<Dave.tein@gmail.com>'
32 SUBJECT="פאנל העמדות -פרטיים"
33 CONTENT_TYPE="text/html"
34 encoding="utf-8";
35 ODS LISTING CLOSE;
36 ODS HTML BODY=mail;
NOTE: Writing HTML Body file: MAIL
37
38 proc report data=sashelp.cars nowd noheader ;
39 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 428 observations read from the data set SASHELP.CARS.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.39 seconds
user cpu time 0.38 seconds
system cpu time 0.01 seconds
memory 8210.00k
OS Memory 41400.00k
Timestamp 01/01/2023 01:51:11 PM
Step Count 582 Switch Count 1
Page Faults 0
Page Reclaims 1866
Page Swaps 0
Voluntary Context Switches 23
Involuntary Context Switches 1
Block Input Operations 0
2 The SAS System 09:54 Sunday, January 1, 2023
Block Output Operations 0
40
41 proc report data = SasHelp.Cars(obs = 5) split = "*";
42 column Type MPG_Ratio MPG_City MPG_Highway;
43 define Type / display ;
44 define MPG_City / display;
45 define MPG_Highway / display;
46 define MPG_Ratio / computed 'City/Highway' format = 4.2;
47 compute MPG_Highway;
48 MPG_Ratio = MPG_City/MPG_Highway;
49 endcomp;
50 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 5 observations read from the data set SASHELP.CARS.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 8334.50k
OS Memory 43968.00k
Timestamp 01/01/2023 01:51:11 PM
Step Count 583 Switch Count 1
Page Faults 0
Page Reclaims 1826
Page Swaps 0
Voluntary Context Switches 35
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
51
52 ODS HTML CLOSE;
ERROR: Email host smtprelay not found.
53 ODS LISTING;
54
55 GOPTIONS NOACCESSIBLE;
56 %LET _CLIENTTASKLABEL=;
57 %LET _CLIENTPROCESSFLOWNAME=;
58 %LET _CLIENTPROJECTPATH=;
59 %LET _CLIENTPROJECTPATHHOST=;
60 %LET _CLIENTPROJECTNAME=;
61 %LET _SASPROGRAMFILE=;
62 %LET _SASPROGRAMFILEHOST=;
63
64 ;*';*";*/;quit;run;
65 ODS _ALL_ CLOSE;
66
67
68 QUIT; RUN;
69
