| Date: | Mon, 9 Mar 2009 12:53:44 -0600 |
|---|
| Reply-To: | Joe Matise <snoopy369@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Joe Matise <snoopy369@GMAIL.COM> |
|---|
| Subject: | Re: Macro quoting |
|---|
|
| In-Reply-To: | <d091a5bf0903091136i38c39abbx9f344c8b19b56e76@mail.gmail.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Use double quotes (" ") on the outside instead of single quotes (' ') to
resolve a macro. Inside a string, double double quotes ("" "") resolve to a
single set of double quotes (" ") if you're unable to use single quotes
(like in this case, excel won't accept ' ').
So:
put "[paste(""r4c1:r&ac8"")]";
-Joe
On Mon, Mar 9, 2009 at 12:36 PM, leawell solutions <
leawellsolutions@googlemail.com> wrote:
> I am using DDE commands to pass info from SAS to Excel.
>
> How do I resolve the following macro
>
> put '[paste("r4c1:r&ac8")]';
>
> to read put '[paste("r4c1:r2223c8")]';
>
> FIA.
>
| 
