French Canadian Currency Format to use in Proc report.

[ashna]

Hello all,

I'm using "format=nlmny15.2;" to write the currency in french in Proc report. It works perfectly but in excel it shows as below

When we need to copy the value from the cell $ symbol is written instead of only value. 

I want similar to how it appears when we use dollar10.2 

Any help is appreciated

[tomrvincent]

Perhaps DOLLARXw.d is what you want to use.

[Cynthia_sas]

Hi: I agree with @tomrvincent -- if you want something similar to the DOLLAR format, then either use the DOLLAR or DOLLARX format for your cell instead of format=nlmny15.2.

You can find examples of using TAGATTR in this paper https://support.sas.com/resources/papers/proceedings11/266-2011.pdf . ODS EXCEL works the same way that the paper shows for ODS TAGSETS.EXCELXP.

Cynthia

[Ksharp · Accepted solution]

use style TAGATTR='format:xxxxx ' . @Cynthia_sas  might give you a whole example.