Adding Comma in ODS ExcelXP output

[khfor2007]

Hi everyone,

I am using ODS ExcelXP on Mainframe to send a proc print output to Excel, however the format in the ODS output does not seem to agree with the format comma10. I specified in the proc print

For example:

Proc print data=test;
var Price;
format Price comma10. ;
run;

My SAS output:
Price
3,000,000
But my ODS output would have no comma:
Price
3000000

I used the TAGATTR in style option as follows (but still DOES NOT WORK)

ODS TAGSETS.EXCELXP Options(sheetname='xxxx');
proc print data=test label noobs;
var price/ style(data)={tagattr="format:comma10."};
run;
ODS _all_ close;

I would really appreciate it if someone could help me on this.

Thanks.

K

 

[sarav1981]

Hi Khfor2007,

Try using the "Thousands_separator" option of the EXCEL XP Tagset. It would apply the separator specified after every thousand-th value for Numeric values.

Your code should look similar to this:

ODS TAGSETS.EXCELXP
    Options(sheetname='xxxx'
            Thousands_separator=',');
    proc print data=test label noobs;
         var price;
    run;
ODS _all_ close;

Hope this helps!

Sarav

 

[khfor2007]

Thanks Sarav for your help!

But it still does not work with the THOUSANDS_SEPARATOR. However, I used TAGATTR like this:

ODS TAGSET.EXCELXP options(....);
Proc print data=test;
var price / style={tagattr='format:#,##0'} ;
run;
ODS _all_ CLOSE;


And IT WORKS !!! thanks,