PROC PWENCODE authorization issue

Leo9 — Wed, 02 Oct 2024 00:15:39 GMT

I am trying to send email from SAS and everything is working fine and as intended when I type my actual pwd in the SAS code using EMAILPW = option. Since I do not want to use my actual pwd in the program, I created an encoded pwd using PWENCODE procedure and stored it in the file with name 'pwfile'

1) Here is the first code to create the encoded pwd

filename pwfile 'Z:\Private\pwd\pwfile.txt';
proc pwencode in='pwd' out=pwfile;
run;

Now I am using code below to use this encoded pwd but I keep on getting login failure error. Basically, SAS is not recognizing the encoded pwd correctly (as intended).

Here is the second part for email.

filename pwfile

'Z:\Private\pwd\pwfile.txt';

options symbolgen;

data _null_;

infile pwfile truncover;

input line :$64.;

call symputx('dbpass',line);

run;

options

emailsys=smtp

emailauthprotocol= plain

emailid = 'user@xyz.com'

emailhost='smtp.office365.com'

emailpw = "&dbpass"

emailport=587

;

options emailhost=

(

'smtp.office365.com' port=587

STARTTLS auth=login

id='user@xyz.com'

pw="&dbpass"

)

;

/* Send email */

filename mymail email

to="user@xyz.com"

attach = "Z:\Private\pwd\test.docx"

subject="test";

data _null_;

file mymail;

put "this is test email";

run;

filename mymail clear;

Please provide any suggestions to correct this error.

Re: PROC PWENCODE authorization issue

Patrick — Wed, 02 Oct 2024 03:14:36 GMT

For debugging purposes:
1: Run your program with code as simple as possible using your clear text password. Once that works:

2: Only replace the clear text password with the encoded version (not passed via a macro variable) and run again. Does this work or already fail?

Re: PROC PWENCODE authorization issue

Kurt_Bremser — Wed, 02 Oct 2024 07:08:45 GMT

Instead of taking the detour through an external file, use the automatic macro variable _PWENCODE in your EMAILPW option. And do not use quotes around it.

topic PROC PWENCODE authorization issue in SAS Programming

PROC PWENCODE authorization issue

Re: PROC PWENCODE authorization issue

Re: PROC PWENCODE authorization issue