topic Re: How to resolve a macro-variable within simple quotes ? in SAS Programming

How to resolve a macro-variable within simple quotes ?

phil27 — Thu, 22 Apr 2010 11:30:10 GMT

Hi,
I am using ods ods tagsets.excelxp to make an xls file.

I need to customize the header with a macro-variable.

The Print_Header statement :

Print_Header='&E Fichier audité : ' &fichierATraiter
Produces a syntax error.

Print_Header='&E Fichier audité : &fichierATraiter'
Works but the header of the xls file is Fichier audité : ichierATraiter
instead of Fichier audité :
followed by the value of &fichierATraiter.

What syntax would be correct ?
Thanks.

Phil

Re: How to resolve a macro-variable within simple quotes ?

Florent — Thu, 22 Apr 2010 12:14:42 GMT

Hi,

Couldn't you use the following statement ?

Print_Header="&E Fichier audité : &fichierATraiter"

Regards,
Florent

Re: How to resolve a macro-variable within simple quotes ?

phil27 — Thu, 22 Apr 2010 12:25:39 GMT

Thanks Florent,
it works but in this case the Excel layout doesn't work no more; & is not recognized by sas.

phil

Re: How to resolve a macro-variable within simple quotes ?

Florent — Thu, 22 Apr 2010 12:40:51 GMT

Phil,

What & are you talking about ?

It doesn't appear in your first message.

Florent

Re: How to resolve a macro-variable within simple quotes ?

phil27 — Thu, 22 Apr 2010 12:44:47 GMT

Excuse me, I meant &E. &Amp was for the footer.

phil

Re: How to resolve a macro-variable within simple quotes ?

Florent — Thu, 22 Apr 2010 12:50:20 GMT

Ok 🙂

Could you try with the following statement ?
Print_Header='&E Fichier audité : ' || "&fichierATraiter"

Florent

Re: How to resolve a macro-variable within simple quotes ?

phil27 — Thu, 22 Apr 2010 12:51:12 GMT

This syntax works well :

Print_Header="%nrstr(&)E Fichier audité : &fichierATraiter"

Thank you for your help.

phil