BookmarkSubscribeRSS Feed
RTelang
Fluorite | Level 6

here is my code to send mail but a error arises please help to solve it.

 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55
56 %macro Frm_send_email(TO=,FROM=,SUBJECT=,ATTACHMENT=,BODY=);
57 %if &to ne %then
58 %let TO="&TO";
59
60 %if &from ne %then
61 %let from=FROM="&FROM";
62
63 %IF &SUBJECT ne %THEN
64 %LET subject=SUBJECT="&SUBJECT";
65
66 %IF &ATTACHMENT ne %THEN
67 %LET attachment=ATTACHMENT="&ATTACHMENT";
68
69 %IF &BODY ne %THEN
70 %LET BODY="&BODY";
71 options emailhost=
72 (
73 "smtp.gmail.com" port=465
74 SSL auth=plain
75 id="sample@gmail.com"
76 pw="***********" );
77
78 FILENAME outbox EMAIL &TO &FROM &SUBJECT &ATTACHMENT;
79
80 DATA _NULL_;
81 FILE outbox;
82 PUT &BODY;
83 RUN;
84
85 %MEND Frm_send_email;
86 /* options mlogic mprint symbolgen; */
87 %Frm_send_email(TO=sample.com,FROM=sample@gmail.com,SUBJECT=details,ATTACHMENT=,BODY=here is it take a
87 ! look);
 
NOTE: The file OUTBOX is:
E-Mail Access Device
 
ERROR: Unable to create cipher.
 
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds
 
 
88
89 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
101
7 REPLIES 7
ballardw
Super User

Did you have a program that did what you wanted before adding macro elements?

RTelang
Fluorite | Level 6
i have created this macro to send mail with the parameters. can u correct d error ?
ballardw
Super User
I asked if you had a working version without the macro elements as part of the debug. If the answer was 'yes' then the place to look is in the macro elements. If 'no' then I would recommend getting a basic non-macro program to work first or at least simpler to debug.
RTelang
Fluorite | Level 6
FILENAME outbox EMAIL ("***********");
DATA _NULL_;
FILE outbox
TO=("************")
FROM=("***********")
SUBJECT=("Example of a SAS E-mail" );
PUT " ";
PUT "Hello Boss,";
PUT " ";
PUT "Attached are the Daily Operational Reports.";
PUT " ";
PUT "uu";
RUN;
RTelang
Fluorite | Level 6
Email host FILENAME not found. i get this error if i remove email hostname option...
RTelang
Fluorite | Level 6

here is my macro to send mail through sas but above mentioned error arises cipher can't be created... what changes can i do to remove the error.

%macro Frm_send_email(TO=,FROM=,SUBJECT=,ATTACHMENT=,BODY=);
%if &to ne %then
%let TO="&TO";

%if &from ne %then
%let from=FROM="&FROM";

%IF &SUBJECT ne %THEN
%LET subject=SUBJECT="&SUBJECT";

%IF &ATTACHMENT ne %THEN
%LET attachment=ATTACHMENT="&ATTACHMENT";

%IF &BODY ne %THEN
%LET BODY="&BODY";


options emailhost=(
"smtp.gmail.com" port=465
SSL auth=plain
id="sample@gmail.com"
pw="***********" );

FILENAME outbox EMAIL &TO &FROM &SUBJECT &ATTACHMENT;

DATA _NULL_;
FILE outbox;
PUT &BODY;
RUN;

%MEND Frm_send_email;
options mlogic mprint symbolgen;
%Frm_send_email(TO=sample.com,FROM=sample@gmail.com,SUBJECT=details,ATTACHMENT=,BODY=here is it take a look);

Reeza
Super User
So to be clear, your non-macro version does not work?

sas-innovate-2024.png

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!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1445 views
  • 0 likes
  • 3 in conversation