topic Re: Email Macro NRQUOTE Issue in SAS Programming

Email Macro NRQUOTE Issue

sasmaverick — Wed, 25 Mar 2015 15:26:26 GMT

Below is a part of a macro I am using for email. The problem arises when I have email containing single quotations like john o'brien@gmail.com in which case I get an error. Even though I am using %nrquote function for masking, I am getting this error.

filename Mailbox

542 EMAIL

543 FROM = maverick@gmail.com

544 TO = %nrquote(&personsemail)

548 SUBJECT = "I am having an issue"

Would highly appreciate the help.

Thanks

Re: Email Macro NRQUOTE Issue

ballardw — Wed, 25 Mar 2015 15:32:44 GMT

You may want %nrbquote

Re: Email Macro NRQUOTE Issue

sasmaverick — Wed, 25 Mar 2015 18:23:15 GMT

I want the email to be double quoted instead of single quote.

Eg. TO="john'obrien@gmail.com"

the issue is occurring because by default the email is single quoted when resolved. ie. 'john'o'brien'@gmail.com'

Re: Email Macro NRQUOTE Issue

Astounding — Wed, 25 Mar 2015 18:37:51 GMT

Should be easier to switch to %SUPERQ. Note that %SUPERQ does not want to see the ampersand:

TO = "%superq(personsemail)"

Of course, that assumes that the rest of the syntax is correct ... this is just to get rid of the macro quoting issue. I mention that because it's difficult to determine from your post what SAS statements you are hoping to generate.

Good luck.

Re: Email Macro NRQUOTE Issue

sbb — Wed, 25 Mar 2015 18:47:07 GMT

What is the exact SAS error received? My attempt resolved the quote / double-quote correctly and the EMAIL was generated as expected. Suggest you post the exact SAS code piece in its entirety and the SASLOG error diagnostics.

Re: Email Macro NRQUOTE Issue

sasmaverick — Wed, 25 Mar 2015 19:09:40 GMT

Hi SBB,

Thanks for the reply. Below is the code and the log. Basically I need to double quote emails in the TO= statement. Believe that would solve the issue

data test;

email="testing o'brien@gmail.com";

run;

proc sql noprint;

select email into : email from test;

quit;

options symbolgen mprint mlogic;

%put email=%nrbquote(&email.);

%macro mail;

filename MailBox

FROM = 'testing@gmail.com>'

TO = %nrbquote(&email.)

SUBJECT = "My Email Is Not Working";

data _null_;

file MailBox;

put "Hello" ;

put " " ;

run;

%mend mail;

%mail;

LOG:

94 options symbolgen mprint mlogic;

96 %put email=%nrbquote(&email.);

SYMBOLGEN: Macro variable EMAIL resolves to testing o'brien@gmail.com

email=testing o'brien@gmail.com

97 %macro mail;

99 filename MailBox

100 EMAIL

101 FROM = 'testing@gmail.com>'

102 TO = %nrbquote(&email.)

103 SUBJECT = "My Email Is Not Working";

104 data _null_;

105 file MailBox;

106 put "Hello" ;

107 put " " ;

108 run;

109

110 %mend mail;

111

112 %mail;

MLOGIC(MAIL): Beginning execution.

SYMBOLGEN: Macro variable EMAIL resolves to testing o'brien@gmail.com

NOTE: Line generated by the macro function "NRBQUOTE".

1 testing o'brien@gmail.com

-----

MPRINT(MAIL): filename MailBox EMAIL FROM = 'testing@gmail.com>' TO = testing

o'brien@gmail.com SUBJECT = "My Email Is Not Working";

ERROR: Error in the FILENAME statement.

MPRINT(MAIL): data _null_;

MPRINT(MAIL): file MailBox;

MPRINT(MAIL): put "Hello" ;

MPRINT(MAIL): put " " ;

MPRINT(MAIL): run;

ERROR 23-2: Invalid option name brien.

NOTE: The file MAILBOX is:

Filename=C:\Users\212441413\mailbox.dat,

RECFM=V,LRECL=256,File Size (bytes)=0,

Last Modified=26Mar2015:00:35:04,

Create Time=26Mar2015:00:14:58

Re: Email Macro NRQUOTE Issue

sbb — Wed, 25 Mar 2015 19:17:33 GMT

The final syntax must have double-quotes surrounding your EMAIL address, whether you generate that in the PROC SQL or hardcode it in the TO= ( .... ) parameter surround your macro variable resolved EMAIL address(es). The error is due to the TO= lacking double-quotes surrounding each address and if you intend to code multiple addresses, the entire TO=(....) must be surrounded with parentheses.

Re: Email Macro NRQUOTE Issue

data_null__ — Wed, 25 Mar 2015 19:19:39 GMT

I think you will be better off using e-mail directives. You probably won't need any messy macro bits. Have a look at the examples in the link.

Specifying E-mail Directives in the PUT Statement

Re: Email Macro NRQUOTE Issue

Tom — Wed, 25 Mar 2015 20:00:13 GMT

How are you populating the macro variable with the email address?

You should not need to use macro quoting, just quote the address. Use the QUOTE() or CATQ() function to make sure that quotes are generated properly.