On Mon, 11 Aug 2008 13:44:54 -0700, JT <Railfan1975@GMAIL.COM> wrote:
>First off, I'm using SAS Enterprise Guide 4 and my data files are on a
>I've created a set of global variables to use in my code. I have two
>variables EmailAdd and ExcelDir that I am using.
>Here's problem number 1. When I put the EmailAdd variable in a PUT '!
>EM_TO!' statement, it will not resolve the variable. I've tried PUT '!
>EM_TO! &EmailAdd.', PUT '!EM_TO!' &EmailAdd. and several other
>variations and no luck.
>Problem number 2. When I try to do multiple attachments in the PUT '!
>EM_ATTACH!' statement, it either will not resolve the variable
>ExcelDir or it thinks the multiple attachments are one file name.
>I've tried putting parenthesis around the names, spaces between them
>and commas between them. No luck, and the help file is no good
>Any help at all is appreicated.
I suspect that your problem has nothing to do with the intricacies of the
PUT statement and the EMAIL Access Method.
Macro variables will not resolve inside a character literal bounded by
single quotes. Use double quotes; to specify a double quote as part of the
literal, repeat it, as in
"!em_attach! (""&ExcelDir\a.xls"" ""&ExcelDir\b.xls"")"