How to resolve a macro-variable within simple quotes ?

[phil27]

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

[Florent]

Hi,

Couldn't you use the following statement ?

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

Regards,
Florent

[phil27]

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

phil

[Florent]

Phil,

What & are you talking about ?

It doesn't appear in your first message.

Florent

[phil27]

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

phil

[Florent]

Ok 🙂

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

Florent

[phil27]

This syntax works well :

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

Thank you for your help.

phil