Help using Base SAS procedures

help cipher can't create

Reply
Regular Contributor
Posts: 190

help cipher can't create

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
Super User
Posts: 10,871

Re: help cipher can't create

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

Regular Contributor
Posts: 190

Re: help cipher can't create

i have created this macro to send mail with the parameters. can u correct d error ?
Super User
Posts: 10,871

Re: help cipher can't create

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.
Regular Contributor
Posts: 190

Re: help cipher can't create

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;
Regular Contributor
Posts: 190

Re: help cipher can't create

Email host FILENAME not found. i get this error if i remove email hostname option...
Regular Contributor
Posts: 190

Re: help cipher can't create

[ Edited ]

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);

Super User
Posts: 18,580

Re: help cipher can't create

So to be clear, your non-macro version does not work?
Ask a Question
Discussion stats
  • 7 replies
  • 552 views
  • 0 likes
  • 3 in conversation