topic Re: French Canadian Currency Format to use in Proc report. in New SAS User

French Canadian Currency Format to use in Proc report.

ashna — Fri, 06 Dec 2019 16:10:10 GMT

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

Re: French Canadian Currency Format to use in Proc report.

tomrvincent — Fri, 06 Dec 2019 17:04:48 GMT

Perhaps DOLLARXw.d is what you want to use.

Re: French Canadian Currency Format to use in Proc report.

Ksharp — Sat, 07 Dec 2019 11:43:06 GMT

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

Re: French Canadian Currency Format to use in Proc report.

Cynthia_sas — Sat, 07 Dec 2019 14:14:30 GMT

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