proc pwencode issue with single and double quotes

[sathya66]

Hi All,

how to mask single and double quotes from my password.

proc pwen code is not working if my password has single and double quotes.

even if I use %str.

%let d=%nrstr(,3xc'wqm_W");

proc pwencode in= ",3xc'wqm_W"";
run;

 Thanks,

SS

[Astounding · Accepted solution]

Have you tried the usual way?  Within double quotes refer to a double quote with an extra double quote character:

proc pwencode in= ",3xc'wqm_W""";
run;

[sathya66]

I tried this but  I doubt, will SAS take extra double Quote as a letter or will it mask  ",3xc'wqm_W"""

[Astounding]

SAS uses this syntax everywhere else within the software.  There's now reason why PWENCODE should be different.

Within double quotes, consecutive double quotes get treated as a single double quote character.  With three double quotes in a row, the first two combined get treated as a double quote character, and the third one ends the quoted string.

[AnandVyas]

SAS treats the two consecutive quotation marks as one quotation mark.

[AnandVyas]

Just In-case any non programmer background admin stumbles upon this situation you can use a workaround to get auto generated encoded password. Create an auth in SMC and add the required credentials as part of that auth. Create a library in SMC using the auth. Once created, right click the library and select display libname statement. This should show the libname with encoded pass.

[Tom]

Please show the actual code since what you show is not using the macro variable you created. 

Did you use %STR() or %NRSTR()?  I would think you would want %STR() or %BQUOTE() since you have no need to remove the macro quoting.

But it is much easier to use normal quoting instead of macro quoting.  Just double the embedded quotes. So either of these should work.

",3xc'wqm_W"""
',3xc''wqm_W"'

Or just use the QUOTE() function to add the quotes.  

%let d=%bquote(,3xc'wqm_W");
proc pwencode in=%qsysfunc(quote(%superq(d)));
run;

[sathya66]

getting below error
28 %let d=%bquote(,3xc'wqm_W");
29 proc pwencode in=%qsysfunc(quote(%superq(d)));
NOTE: Line generated by the macro function "QSYSFUNC".
29 ",3xc'wqm_W"""
_
22
76
ERROR 22-322: Expecting a quoted string.
ERROR 76-322: Syntax error, statement will be ignored.
30 run;

[Tom]

Probably the macro quoting added by %Qsysfunc.
Use %sysfunc instead. But in that case I would pass the QUOTE() function a single quote as the second argument so that it generates a string quoted with single quotes. That way any & or % characters in the string will be ignored by the macro processor.
%sysfunc(quote(%superq(d),%str(%'))