topic Re: help cipher can't create in SAS Procedures

help cipher can't create

RTelang — Thu, 21 Jan 2016 20:16:35 GMT

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

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 %macro Frm_send_email(TO=,FROM=,SUBJECT=,ATTACHMENT=,BODY=);

57 %if &to ne %then

58 %let TO="&TO";

60 %if &from ne %then

61 %let from=FROM="&FROM";

63 %IF &SUBJECT ne %THEN

64 %LET subject=SUBJECT="&SUBJECT";

66 %IF &ATTACHMENT ne %THEN

67 %LET attachment=ATTACHMENT="&ATTACHMENT";

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="***********" );

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

80 DATA _NULL_;

81 FILE outbox;

82 PUT &BODY;

83 RUN;

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

89 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

101

Re: help cipher can't create

ballardw — Thu, 21 Jan 2016 20:27:22 GMT

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

Re: help cipher can't create

RTelang — Thu, 21 Jan 2016 20:30:59 GMT

i have created this macro to send mail with the parameters. can u correct d error ?

Re: help cipher can't create

RTelang — Thu, 21 Jan 2016 20:34:18 GMT

Email host FILENAME not found. i get this error if i remove email hostname option...

Re: help cipher can't create

ballardw — Thu, 21 Jan 2016 20:59:36 GMT

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.

Re: help cipher can't create

RTelang — Thu, 21 Jan 2016 21:05:23 GMT

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;

Re: help cipher can't create

RTelang — Fri, 22 Jan 2016 06:37:53 GMT

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

Re: help cipher can't create

Reeza — Sat, 23 Jan 2016 01:25:11 GMT

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