topic Re: Increase Decimal places in Excel using ODS TAGSETS EXCELXP option in ODS and Base Reporting

Increase Decimal places in Excel using ODS TAGSETS EXCELXP option

Sulabh — Wed, 30 Sep 2015 05:56:19 GMT

I am trying to increase the decimal places in the excel output that ODS EXCELXP tagsets generate. The SAS dataset does show about 5 decimal places, however, when I exporrt it using ODS I see only 2 decimal places.

Could you please let me know which format/procedure/etc could I use to increase the decimals in the output?

Re: Increase Decimal places in Excel using ODS TAGSETS EXCELXP option

user24feb — Wed, 30 Sep 2015 06:58:48 GMT

Try:

Data A;
Number=123; Output;
Run;

ODS Tagsets.ExcelXP File="D:\Test.xml" Style=HTMLBlue;
Proc Report Data=A;
Column Number;
Define Number/Display Style(Column)={TagAttr='Format:0.00000'};
Run;
ODS Tagsets.ExcelXP Close;