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 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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