Date:         Fri, 4 Oct 2002 14:00:50 +0200
Reply-To:     Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Subject:      Re: Macro variable translation problem
Comments: To: Ravi Vedantam <ravi.vedantam@ERICSSON.COM>
Content-Type: text/plain

Hi Ravi,

%LET MacroVar =
%SYSFUNC(TRANSLATE(%NRSTR(%("ELN-SAD-I&B","ELN-SAD-I&V"%)),%STR(%'),%STR(%")
));
%PUT MacroVar = &MacroVar;

Regards - Jim.
--
Y. (Jim) Groeneveld, MSc    IMRO TRAMARKO         tel. +31 412 407 070
senior statist./data man.   P.O. Box 1            fax. +31 412 407 080
J.Groeneveld@ITGroups.com   5350 AA BERGHEM, NL   www.imrotramarko.com

My computer does what I tell it to do; I do tell myself to believe that.

Notice of confidentiality: this e-mail may contain confidential information
intended for the addressed recipient only.
If you have received this e-mail in error please delete this e-mail and
please notify the sender so that proper delivery
can be arranged.

> -----Original Message-----
> From: Ravi Vedantam [SMTP:ravi.vedantam@ERICSSON.COM]
> Sent: Thursday, October 03, 2002 11:39 PM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      Macro variable translation problem
>
> Hello SAS-L,
>
> Supposing I have a macro variable with this value:
>
> ("ELN-SAD-I&B","ELN-SAD-I&V")
>
> I want to translate this macro variable to look like:
>
> ('ELN-SAD-I&B','ELN-SAD-I&V')
>
>
> Basically, I want to replace double quotes with single quotes.
> By the way &B and &V are not supposed to be macro variables.
>
> Any suggestion on how to do this are most welcome.
> Thank you,
> Ravi Vedantam